x

All Adapters - Version 7 Release 7.06

• Changing Common Adapter Settings. The Web Console Adapters page has a new button in the Troubleshooting group, labeled Change common adapter settings, that allows you to customize data type mappings and other miscellaneous settings that are common to all adapters. Adapter-specific settings are customizable by right-clicking a configured adapter folder and selecting Change Settings from the context menu.

All Adapters - Version 7 Release 7.02

• Support for Reading BLOB Data From Remote Data Sources. BLOB data can be retrieved for remote data sources, that is, synonyms with SUFFIX=EDA.

All Adapters - Version 7 Release 7

• Support for Data Caching in Data Retrieval. Supports both static and dynamic caching using the ENGINE INT SET CACHE ON command.
• Support for Multi-Valued Fields. Processing has been enhanced for data sources that contain data in non-first Normal Form. This data is represented by multi-segment Master File structures.
• Support for Null Testing in Left Outer Join. Provides support for outer joins in SQL style by generating full paths with NULL values instead of short paths.
• Parameterization of Master and Access File Values Using Variables. You can define global variables in a Master File and use them to parameterize certain attributes in the Master File and its corresponding Access File.
• SQL Optimization of Legacy DATE Format Fields. Legacy date formats have been optimized.

x

All SQL Adapters - Version 7 Release 7.06

• Creating Indexes for an Existing Table. When you issue a CREATE FILE command for a table, an index is created in the relational DBMS for the primary key and for each index specified in the Access File. If you want to create a table without creating all of the indexes at that time, you can omit the index declarations from the Access File and issue the CREATE FILE command to create only the table and the index on the primary key. Then, at a later time, you can add the index declarations to the Access File and issue the CREATE FILE command with the INDEXESONLY phrase. The option of adding the indexes later makes loading data into a relational table much faster.
• Optimization of Full Outer Joins. The WebFOCUS join command and conditional join command now have a FULL OUTER join option.
• Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT. The JOIN AS_ROOT command adds a new fact table as an additional root to an existing fact-based cluster (star schema). The source Master File has a parent fact segment and at least one child dimension segment. The JOIN AS_ROOT command supports a unique join from a child dimension segment (at any level) to an additional fact parent.
• Joining From a Multi-Fact Synonym. Multi-parent synonyms are now supported as the source for a unique join to a single segment in a target synonym.
• Improved Handling of a Star Schema With Fan Trap. A new context analysis process has been introduced in this release that detects the multiplicative effect and generates SQL script commands that retrieve the correct values for each segment context. These scripts are then passed to the RDBMS as subqueries in an optimized SQL statement.
• Support for Discontiguous Key Definition in the Access File. Key fields in the Master File can be listed in the order established by the relational DBMS or in any order that is convenient. New syntax is available that does not require reordering of the fields in the Master File.
• Optimization of Simplified Character Functions. The SUBSTRING, LTRIM, RTRIM, TRIM_, CHAR_LENGTH, LOWER, POSITION, and UPPER simplified functions are optimized to SQL.
• Optimization of Simplified Date and Date-Time Functions. The DTPART, DTRUNC, DTADD, and DTDIFF functions have been optimized for SQL adapters, as reflected in the SQL Optimization Report.
• Optimization of Legacy Character and Numeric Functions. The TRIMV function with the L/B (left/both) option, TRIM, ARGLEN, and POWER functions have been optimized.
• Optimization of Date and Date-Time Functions. You can determine which functions are optimized to their SQL counterparts by adapter in the SQL Optimization Report available from the Web Console.
• Automatically Generating FORMAT SQL_SCRIPT for HOLD Files. This feature allows the specification for temporary HOLD file formats to be SQL_SCRIPT. It affects all ON TABLE HOLD requests that do not have an explicit format specified. It also enables you to convert procedures from disk HOLD files to SQL HOLD files through a single SET command.
• Amper Variables for SQLTAG and ABORTREPORT Settings. Variables that hold the values of SQLTAG and ABORTREPORT settings have been added.
• Extended Bulk Load Support for the ON TABLE HOLD Clause. When using HOLD with a FORMAT of a SQL database, a new option enables you to use a bulk load procedure to load the table.

Adapter for DB2 - Version 7 Release 7.06

• Case-Insensitive Filtering. Setting server collation (either as SET COLLATION=SRV_CI or under the NLS configuration) triggers the underlying i5 DB2 to also be case-insensitive for local IBM i DB2 connections.

Adapter for C9 INC - Version 7 Release 7.06

• The Adapter for C9 INC has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder. It provides read access to Salesforce data stored in C9 and supports C9 temporal features by generating fields in the Master File with temporal properties.

Adapter for Greenplum - Version 7 Release 7.06

• Extended Bulk Load Support. DataMigrator supports Extended Bulk Load for EMC Greenplum using the Greenplum Load Utility, gpload. This provides a faster load option than insert/update.
• Unicode Support. The Adapter for Greenplum can read and write data in Unicode.

Adapter for Greenplum and PostgreSQL - Version 7 Release 7.06

• A256V Data Type Mapping. The Adapter for PostgreSQL supports data type mapping using the following setting:

  ENGINE SQLPSTGR SET CONVERSION LONGCHAR ALPHA n

  The setting affects the mapping of all PostgreSQL native fields that have a data type of [VAR]CHAR(32767) or TEXT.

Adapter for Hive - Version 7 Release 7.06

• Bulk Loading With DataMigrator. DataMigrator can create Hive metadata and load it into Hadoop using the Bulk Load via a Disk File load type.
• Increased CREATE FILE Functionality. The CREATE FILE process for a synonym that refers to a Hive table creates columns for files created by DataMigrator with data types that Hive supports.
• Specifying the Maximum String Length When Creating Synonyms. When creating a synonym for character columns in Hive data sources, an option enables you to specify the maximum string length.

Adapter for Hyperstage - Version 7 Release 7.06

• Performance Improvements. The increased use of parallelization in joins and sorting has improved the ability to run concurrent queries.
• Memory Management Improvements. Hyperstage now uses memory more efficiently. In addition, various changes have been made which reduce the amount of memory needed.
• Hyperstage ODBC Adapter. A new ODBC adapter for MySQL-based Hyperstage supplements the existing JDBC adapter on the Windows platform.
• Lookup Attribute Added to Denormalized Dimension Columns. When using Quick Copy for a cluster join describing a collection of tables that comprise a Star Schema with a denormalized Hyperstage target, character columns in dimension tables are created with the Hyperstage lookup comment attribute.
• DataMigrator and Quick Copy Support for Unicode. You can load Unicode data to a Hyperstage target using DataMigrator or Quick Copy.

Adapter for Hyperstage (PG) - Version 7 Release 7.06

• Adapter for Hyperstage. The Adapter for Hyperstage using PostgreSQL (PG) has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.
• Column Comments Supported as DESCRIPTION Attribute. Column Comments is now supported as the synonym DESCRIPTION attribute for PostgreSQL-based Hyperstage, and for all other JDBC-based engines that return Column Comments information in a JDBC Metadata call.

Adapter for i Access - Version 7 Release 7.06

• Adapter for i Access. The Adapter for i Access has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for Informix - Version 7 Release 7.06

• Support for SDK 4.10.x. The Adapter for Informix supports the Informix SDK 4.10.x.

JDBC Adapters - Version 7 Release 7.06

• Support for COMMANDTIMEOUT Setting. The SET COMMANDTIMEOUT command is introduced for JDBC-based adapters whose drivers support the setQueryTimeout() call.

Adapter for Microsoft SQL Server - Version 7 Release 7.06

• ODBC Adapter for Microsoft SQL Server. The ODBC-based adapter is introduced for Microsoft SQL Server and is available as a named adapter on the Web Console in the SQL folder.
• Support for View Properties. The Adapter for Microsoft SQL Server can retrieve and store view properties (if present) in a Master File synonym.

Adapter for Microsoft SQL Server and Oracle - Version 7 Release 7.06

• Support for HINT. The Adapters for Microsoft SQL Server and Oracle can speed up the DML SELECT by specifying a HINT clause.

Adapter for MongoDB - Version 7 Release 7.06

• Adapter for MongoDB. The Adapter for MongoDB has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for MySQL - Version 7 Release 7.06

• DataMigrator and Quick Copy, with a MySQL database target, now support the load type Extended Bulk Load, which provides faster load times than insert/update processing.

Adapter for Netezza - Version 7 Release 7.06

• Support for Column and Table Comments. The Adapter for Netezza supports column and table comments. They can be used as titles during the Create Synonym process.
• Support for Password Passthru. The Adapter for Netezza now supports Password Passthru authentication.

Adapter for Oracle - Version 7 Release 7.06

• Create Synonym Support for Materialized View. The Adapter for Oracle recognizes the Oracle synonym for materialized view as a candidate and presents it among the available objects on the Web Console Create Synonym page.
• Support for Version 12c (Cloud). Support has been added for Oracle Version 12c (Cloud).
• Support for 12c Extended String Size. The Adapter for Oracle supports Oracle 12c extended-string data types. [N]VARCHAR2(32767) is supported.

Adapter for Oracle TimesTen - Version 7 Release 7.06

• Adapter for Oracle TimesTen. The Adapter for Oracle TimesTen has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for SAP HANA - Version 7 Release 7.06

• Adapter for SAP HANA DB. The Adapter for SAP HANA Database has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.
• Metadata For Different Types of Views. The Adapter for SAP HANA can now retrieve metadata and create Synonyms for different types of HANA DB views.
• Adapter for SAP HANA ODBC. he ODBC-based adapter is introduced for SAP HANA and is available as a named adapter on the Web Console in the SQL folder. This adapter (available on Windows 64-bit) supports SSO with Kerberos security.

Adapter for Sybase - Version 7 Release 7.06

• Support for Connection Name. Connection Name has been added as a configuration parameter for the Adapter for Sybase.

Adapter for Teradata - Version 7 Release 7.06

• Extended Bulk Load for Unicode Data. The Adapter for Teradata configured with CLI Teradata Client supports the loading of UTF8-encoded data through Extended Bulk Load.
• Support for Version 14.10. The Teradata CLI and ODBC adapters support read/write access to Teradata Version 14.10.
• Support for Version 15.0. The Teradata CLI and ODBC adapters support Read/Write access to Teradata Version 15.0.
• Support for Reading INTERVAL and PERIOD Data Types. The Adapter for Teradata now supports read access to the PERIOD and INTERVAL data types.
• Support for Long Table and View Names. Teradata introduced Extended Object Name (EON) in v.14.1. The Adapter for Teradata now supports table and view names (containing multi-byte characters) with length up to 128-bytes.

Adapter for Vertica DB - Version 7 Release 7.06

• JDBC-based Native Adapter for Vertica (SQLVRT). This adapter has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

All SQL Adapters - Version 7 Release 7.05

• Selectively Controlling FOCUS Function Optimization Through FEATOPT. The optimization of some FOCUS features and functions can now be controlled using the FEATOPT SET command. This enables users to switch off SQL optimization for a particular function or feature when the optimization might produce unsatisfactory results.
• Support for SELECT ON TABLE HOLD FORMAT SAME_DB. An SQL SELECT statement with all the sources in the same relational database can now be used with an ON TABLE HOLD AS name FORMAT SAME_DB command. This uses the underlying database capabilities, such as INSERT INTO ... SELECT, that provide much faster throughput than alternative methods.
• Full Synonym Support Added for SQL Strings. Synonyms created for SQL strings without parameters can now be used in JOIN, WHERE clause (passed to SQL), Aggregation (passed to SQL) and as a result of the ON TABLE HOLD FORMAT SAME_DB (passed to SQL).
• AUTOINCREMENT for PACK Fields Added. Surrogate Keys Support has been enhanced and now includes fields defined with the PACK data type. Therefore, auto-incrementing can now be assigned to PACK data type fields.
• BY HIERARCHY Reporting Available From SQL and Hold Files. BY HIERARCHY reporting now can be applied to relational data sources. The end user is responsible for properly representing the hierarchy in the Master File. The Dimension Builder in the Data Management Console enables you to assign the properties of the hierarchy.
• Using Segment Names as Tags When Generating SQL. The default tag name used by the server SQL generator is T1, T2, and so on. A new setting has been introduced that enables you to assign tag names to match the segment names that contain the referenced fields. To switch to using the SEGNAMEs as tag names, use the following setting:

  SQL engine SET SQLTAG SEGNAME

• Support for FOCUS Amper Variables as SQL String Parameters. The ability to run a request against a synonym for an SQL string has been enhanced to allow the parameterization of the SQL string using Dialogue Manager global variables. After the synonym has been created against the relational adapter where the SQL will be processed, global variables can be added to the source SQL file. The Synonym Editor is then used to add the Variable Declarations.
• Specifying a Time Limit to Logon to a Data Source. A new LOGINTIMEOUT setting has been added to the Session Parameter settings. It enables you to specify the amount of time that an adapter should allow to complete a logon to a data source before returning an error.

Adapter for DB2 - Version 7 Release 7.05

• Truncate Table Added to Existing Table Target Properties. A new Prior to Load option has been added for existing tables in DB2 on Windows, UNIX, and zSeries platforms. The Truncate Table target property removes all rows from the target table without logging.

Adapter for Greenplum® - Version 7 Release 7.05

• Adapter for Greenplum. The Adapter for Greenplum has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for Informix - Version 7 Release 7.05

• Truncate Table With Prior to Load Option Support. When Truncate table is selected as the Prior to Load option on a data flow target, the SQL generated now produces the code to execute TRUNCATE TABLE on the Informix database. Formerly, the SQL sent to the database was DELETE FROM.

Adapter for JBoss Application Server - Version 7 Release 7.05

• Adapter for JBoss Application Server . The JBoss Application Server is now supported, and the Adapter for JBoss is available as a named adapter on the Web Console in the SQL folder. It replaces the Adapter for MetaMatrix.

Adapter for Microsoft SQL Server - Version 7 Release 7.05

• Primary Key Order Respected by the Create Synonym Process. A new Create Synonym mechanism ensures that a Primary Key is prioritized, regardless of how and in what order it was created in the DBMS.

Adapter for Microsoft SQL Server and Sybase - Version 7 Release 7.05

• TSTOPACK Function: Converting a Microsoft SQL Server or Sybase Timestamp Column to Packed Decimal. Microsoft SQL Server and Sybase have a data type called TIMESTAMP. Rather than containing an actual timestamp, columns with this data type contain a number that is incremented for each record inserted or updated. The value is stored in Binary(8) or Varbinary(8) format in the table, but is returned as a double-wide alphanumeric column (A16). You can use the TSTOPACK function to convert the timestamp value to packed decimal.

Adapter for Oracle - Version 7 Release 7.05

• Support for XMLType Data Type. The Create Synonym facility can now describe a column defined in the DBMS as native XMLType. This provides support for the XMLType in various server operations.
• Support for NCLOB Data Type Added. The adapter now can report and update Oracle columns that are defined as NCLOB (National Character Large Objects) when the Reporting Server is configured for Unicode.

Adapter for PostgreSQL - Version 7 Release 7.05

• Support for SERIAL Columns Added. The adapter now supports PostgreSQL tables with SERIAL columns. The column that is produced by Create Synonym is identified as auto increment and read-only.

Adapter for Teradata - Version 7 Release 7.05

• Support for Number Data Type. The adapter now supports the NUMBER(p,s) data type that was introduced in Teradata Version 14. Numeric values with up to 31 digits are supported.

All SQL Adapters - Version 7 Release 7.04

• Create Synonym Gets Enhanced Index Information. The CREATE SYNONYM process now collects more metadata on database indexes, which then records the data into Access File attributes, such as INDEX_NAME, INDEX_UNIQUE, INDEX_COLUMNS, and INDEX_ORDER.
• Default Value Is Supported if a Table Is a DataMigrator Target. If a database column has a default value assigned in the database, and no value is assigned in Target Transformations, the database will now assign the default value. In previous releases, a NULL value was always assigned for NULLABLE columns and a space or zero was assigned for the NOT NULL columns.
• Enable DATEDIF and HDIFF (‘DAYS’) for SQLINF and SQLNUC. The Informix and Sand Analytical Server (formerly known as Nucleus) adapters translate calls of the DATEDIF and HDIFF functions to native SQL DATE-TIME functions with Datepart Parameter DAY, Startdate, and Enddate.
• Enhanced Feedback for Recreate DBMS Table. When viewing a list of synonyms in the browser, selecting a relational database table and the context menu choice Data Management and Recreate DMBS Table, the database table is created based on the information in the synonym. For example, the column names and data types, the key columns, and automatically incrementing columns. However, not every database attribute is stored in the synonym. A warning message now appears that some database table attributes may be lost when the table is recreated.
• Optimize the DEDIT and DSUBSTR Functions. The FOCUS functions, DEDIT and DSUBSTR with character arguments, are optimized to various native SQL character functions. This has been implemented for most SQL Adapters. These functions are designed to be used in multi-byte environments instead of the EDIT and SUBSTRING functions.
• Optimize the EDIT Function of Integer Arguments. The FOCUS function EDIT with an INTEGER argument has been optimized to various SQL native numeric functions. This is implemented for most SQL Adapters.
• Optimization of HADD Function for HOUR, MINUTE, and SECOND. The relational adapters now translate the HADD FOCUS functions to their SQL counterparts. The HOUR, MINUTE, and SECOND calculations are optimized as DATEADD for the mentioned components. This has been implemented for the Microsoft SQL Server and Sybase adapters.
• Optimization of POWER Scalar Function. The Auto-Passthru mode takes advantage of the ability to translate the POWER function for most engines, such as DB2, Sybase, Oracle, Teradata, Microsoft SQL Server, MySQL, Sand Analytical Server (formerly Nucleus), Informix, Redbrick, Microsoft Access, Microsoft Excel, Ingres, IDMS, Postgres, Progress, Cache, Netezza, and SQL1010.
• Optimizing the UPCASE and LOCASE Functions. Most SQL Adapters will optimize the UPPER and LOWER case function to their RDBMS SQL counterparts.
• [RANKED] BY HIGHEST n [TOTAL] Optimization. Some SQL Adapters, such as Teradata, Oracle, Microsoft SQL Server, and Sybase, can optimize BY HIGHEST n/BY HIGHEST n TOTAL to SQL analytical functions RANK() or DENSE_RANK() with subsequent filtering by means of a QUALIFY clause (if supported), or an outer SELECT with a WHERE clause on the RANK value.
• Reduce Synonym Candidate List Based on Access Rules. The i5 DB2 Web Console Synonym Candidate list and underlying metadata is formed from various qsys2/sys* tables, which are not restricted from an information perspective even though table data may be restricted. A site may now restrict this access (or have various special rules) by creating a DB2 UDF and activating the UDF by placing the keyword pair db2_sqlgetauth={udfname} in the server edaserve.cfg file.
• Research and Enable SUBSTR and SUBSTV Optimization. The SUBSTR and SUBSTV FOCUS functions have been optimized to their native SQL counterparts in Version 7.7.02 for most SQL Adapters. For this release, it was implemented for the Transoft, SQLBase, UniData, HP Neoview, and Netezza adapters.
• Sample Multifact Start Schema Load for Stress Testing. Sample Data can be created in a multi-fact Star Schema for stress testing the server. You can specify the number of rows in two fact tables and five dimension tables. This option is accessed from the Application Directories context menu.
• Subquery Supported in SELECT, WHERE, and HAVING Clauses. A SQL subquery (query within a query) can be used in several places in the SQL Select statement, including a from list, and a WHERE and HAVING clause.
• Support Indexed Columns in Create Synonym. A synonym for an RDBMS table now indicates column(s) with a Primary Key or INDEX. This information is added by CREATE SYNONYM. When CREATE FILE is used for the synonym, the table is created with the INDEX(ES) or with Primary Key.
• Synonym Column Name Limit Increased. Synonym processing has been enhanced to support column names of up to 128 characters.

Adapter for 1010data - Version 7 Release 7.04

• Optimization of Functions. The Adapter for 1010data can translate certain functions (for example, ABS, CONCAT, CNT, MAX, MIN, and SUM) to their SQL counterparts, allowing the optimization of TABLE requests with DEFINE fields that call these functions.

Adapter for Business Objects - Version 7 Release 7.04

• Business Objects Conversion Kit. The Adapter for Business Objects will extract JOIN information from a Metadata Exchange XML file produced from a Business Objects Universe and use the information to enhance existing synonyms with foreign key information. If the existing synonyms already have the required foreign key information, no action will be taken.

Adapter for DB2 - Version 7 Release 7.04

• Support of Change Data Capture Added. Change Data Capture support has been added in the Adapter for DB2 v10 on z/OS.

Adapter for Hyperstage - Version 7 Release 7.04

• New Hyperstage Adapter. The Adapter for Hyperstage has been introduced in this release. Hyperstage is a column-oriented relational database produced by InfoBright, with high INSERT/UPDATE/DELETE performance based on the MySQL storage engine.
• Hyperstage Administration Capabilities. Some administrative tasks, such as configuration, monitoring, logging, and tracing, can be performed in the Web Console using the Adapter for Hyperstage.

Adapter for Microsoft SQL Server - Version 7 Release 7.04

• Multiple Tables Bulk Insert From Memory. The Adapter for Microsoft SQL Server has been enhanced with capabilities of multiple concurrent FastLoad rowsets for insertion from memory.
• Use Client-Side Cursors if MARS Is Supported. The Adapter for Microsoft SQL Server for Windows (OLE DB-based version) utilizes advantages of the Multiple Active Result Sets (MARS) option when connecting to instances of Microsoft SQL Server 2005 or higher and if the client and server versions are Microsoft SQL Server 2005 or higher.

Adapter for MySQL - Version 7 Release 7.04

• Supports Synonym for Stored Procedure. The Adapter for MySQL supports create synonym for MySQL stored procedures and can report from answer set(s) returned by such procedures.

Adapter for Netezza - Version 7 Release 7.04

• Support for Multiple SQL Statements. The JDBC version of the Adapter for Netezza now supports the ability to execute two or more concurrent SQL queries within one request. The adapter will create a separate connection for each SQL statement to bypass a Netezza limitation that allows only one active SQL statement per connection. This functionality will also apply to any other JDBC adapter targeting a DBMS with a similar limitation.

Adapter for PostgreSQL - Version 7 Release 7.04

• Creating Synonyms With Uppercase Table Names. The Adapter for PostgreSQL now supports the creation of synonyms for tables with uppercase and mixed-case names. Table names containing numbers and special characters are also supported.

Adapter for Sybase - Version 7 Release 7.04

• Multiple Bulk Insert From Memory. The Adapter for Sybase ASE now supports Multiple Bulk Insert from memory.

Adapter for Teradata - Version 7 Release 7.04

• Add BULK LOAD Support for Teradata Parallel Transporter API. The Adapter for Teradata 13.10 is enhanced with capabilities to utilize Teradata Parallel Transporter API in the new Bulk Load common logical layer that eliminates needs in HOLD file on a disk and feed data to the DBMS Utility from memory using pipe or directly to the specific API. The performance gain is significant.
• Add Support for LOB Data Types in ODBC. An ODBC-based adapter for Teradata can describe, report, and update Teradata columns that are defined as Large Objects (LOB) when Datasource Properties are set to UseNativeLOBSupport=Y in the odbc.ini file and Teradata DBS and TTU versions are 13.10 or higher.
• Support for Teradata 14. Teradata CLI and ODBC adapters were tested with Teradata 14 and support read/write access to this version of the DBMS.

All SQL Adapters - Version 7 Release 7.03

• Testing TX Columns With Sample Data. The Data Management Console facility for Sample Data now displays the columns described with a USAGE value of TXnn.
• Support for Indexed Columns in Create Synonym and Synonym Editor. A synonym for an RDBMS table indicates the column(s) with a Primary Key or INDEX.
• Aggregation of Boolean Expressions. The relational adapters optimize FOCUS Boolean expressions as SQL CASE expressions.
• Capture of Data Definition Language While Using the CREATE FILE Command. You can capture the SQL Data Definition Language (DDL) generated during a CREATE FILE command in an external file called filename.sql.
• DEFINE FUNCTION Optimization. The DEFINE FUNCTION syntax can be sent directly to an SQL engine as long as all expressions used in the function can be optimized.
• SQL.Function Syntax for Direct DBMS Function Calls. The SQL adapters support SQL scalar functions in a request.
• Generating SQL CASE and COUNT Expressions. FOCUS DEFINE and IFTHENELSE expressions are now optimized as SQL CASE logic and SQL COUNT expressions for Informix, MySQL, IDMS, MetaMatrix, NonStop, Pervasive, and Nucleus data sources.
• Sort by Expression Enabled. Most SQL adapters can now translate FOCUS sorting calls into the SQL ORDER BY expression.

Adapter for DB2 - Version 7 Release 7.03

• Support for Array Insert on iSeries. Starting in iSeries (or IBM i) V6, the CLI Adapter for DB2 supports array inserts.

Adapter for Informix - Version 7 Release 7.03

• Support for SDK 3.7. The Adapter for Informix supports the Informix SDK 3.7.
• Support for Native CLOB or BLOB Data Types. The Adapter for Informix supports Native CLOB and BLOB data types for the Informix IDS server.

Adapter for Microsoft SQL Server - Version 7 Release 7.03

• Generating TITLE Attributes During Create Synonym. During the Create Synonym process, the Adapter for Microsoft SQL Server maps the SQL Server 2008 and 2005 TITLE attribute in the Master File.

Adapter for Oracle - Version 7 Release 7.03

• Change Data Capture Support for Unicode Servers. Change Data Capture is supported for Unicode servers that are configured with Oracle 11gR2.

Adapter for Teradata - Version 7 Release 7.03

• Owner/Schema Selection List Added to Create Synonym. The Adapter for Teradata includes an Owner/Schema selector for choosing a data source filter on the Create Synonym page of the Web Console.
• ODBC: Support for Array insert (Block Size) and Array Fetch. The Teradata Array Insert and Array Fetch mechanisms are supported by the ODBC Adapter for Teradata when the driver is from the TTU 13.1 utility pack.
• CLI: Support for Block Size Insert. Block Size Insert (also known as Array Insert) is supported by the CLI Adapter for Teradata.

Adapter for Netezza - Version 7 Release 7.03

• Creating Synonyms in Unspecified Databases. The Adapter for Netezza can create synonyms in databases that are not explicitly specified in the ODBC data source or the JDBC URL.

Adapter for Nucleus - Version 7 Release 7.03

• Optimization of HPART Function. The Adapter for Nucleus can translate certain HPART function calls to SQL date and time functions, allowing the optimization of TABLE requests with DEFINE fields that call these functions.

Adapter for Sybase ASE - Version 7 Release 7.03

• Support for BIGDATETIME and BIGTIME. The Adapter for Sybase ASE supports the BIGDATETIME and BIGTIME data types.

All SQL Adapters - Version 7 Release 7.02

• Optimization of SUBSTR and SUBSTV Functions. The SUBSTR and SUBSTV FOCUS functions have been optimized to their native SQL counterparts.
• Optimization of DATEADD and HADD Functions for YEAR and MONTH. The relational adapters now translate the DATEADD and HADD FOCUS functions to their SQL counterparts. The year/month calculations are optimized as an ADD_MONTHS() SQL function that will be processed by the DBMS engine. This is implemented for Oracle, DB2, Teradata, Sybase IQ, and MySQL.
• IF-THEN-ELSE Optimization Enhancement. IF-THEN-ELSE optimization has been enhanced.

  The default OPTIFTHENELSE setting is set to ON:

  ENGINE sqleng SET OPTIFTHENELSE ON 

  This setting optimizes all relational adapter IF-THEN-ELSE FOCUS expressions as CASE or DECODE SQL expressions.

Adapter for DB2 - Version 7 Release 7.02

• Bulk Load Support for IBM iSeries. Bulk loading from a disk file is supported for IBM iSeries.
• Support for Redistributable Client on Windows. A redistributable run-time client is available on Windows using a separate configuration option for the Adapter for DB2.
• Support for Column Titles in Stored Procedure Synonyms (IBM iSeries only). In IBM i, the metadata of a stored procedure that has an answer set will include column descriptions. These will appear as title fields in the synonym.
• DSN3SATH Support for CA-ACF2. The Adapter for DB2 supports primary and secondary authorization security checking for DSN3SATH.

Adapter for Oracle - Version 7 Release 7.02

• Support for Oracle InstantClient on Windows. The Oracle InstantClient is supported using a separate configuration option for the Adapter for Oracle. InstantClient software is prepackaged as part of the Reporting Server installation.
• Expanded Unicode Support for Oracle NCHAR/NVARCHAR Fields. The Adapter for Oracle supports transparent data conversion for NCHAR/NVARCHAR fields when the Reporting Server is configured for Unicode, even if the Oracle instance is non-Unicode.

Adapter for parAccel - Version 7 Release 7.02

• Optimization of DPART and HPART Functions. The Adapter for parAccel can translate certain calls to the DPART and HPART functions to SQL date and time functions, allowing the optimization of some TABLE requests with DEFINE fields that call these functions.

Adapter for Microsoft SQL Server - Version 7 Release 7.02

• Support for VARBINARY (Max) as BLOB. The VARBINARY (MAX) data type will be mapped as BLOB in Microsoft SQL 2008. The SET parameter CONVERSION LONGCHAR must be set to BLOB.

Adapter for Teradata - Version 7 Release 7.02

• Support for BIGINT Data Type. The BIGINT data type is supported. It can be a signed, binary integer value from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. The data type should be mapped as USAGE=P20, ACTUAL=P10.
• Enhanced DECIMAL Data Type Support. The Decimal/Numeric(n,m) data type is supported in a wider range. The supported precision length has been increased from 18 up to 31 digits.

Adapter for 1010data - Version 7 Release 7.02

• Support for Stored Procedures. The Adapter for 1010data supports creating and using synonyms based on 1010data stored procedures.
• Optimization of Functions. The following scalar functions have been optimized to their native SQL counterparts:
  • ABS
  • ACOS
  • CONCAT or simply ||
  • CURRENT_DATE or CURDATE
  • CURRENT_TIME or CURTIME
  • CURRENT_TIMESTAMP or NOW
  • DAYNAME
  • DAYOFMONTH
  • DAYOFYEAR
  • DIV (integer division)
  • EXP
  • IF (the functional form of CASE WHEN X1 THEN Y1 ... ELSE Z)
  • IFNULL or NVL
  • ROUND
  • USER
  • WEEK
  • YEAR

  The following aggregate functions have been optimized to their native SQL counterparts:

  • AVG
  • CORRELATION
  • COUNT, including COUNT(*) and COUNT(DISTINCT ...)
  • COVARIANCE
  • MAX
  • MIN
  • STDEV
  • SUM
  • VARIANCE
  • WAVG
  • WSTDEV

Adapter for Netezza - Version 7 Release 7.02

• Support for NCHAR and NVARCHAR. The Adapter for Netezza supports the NCHAR and NVARCHAR data types using JDBC.

Adapter for HP Neoview - Version 7 Release 7.02

• Optimization of EDIT Function. The EDIT FOCUS function has been optimized to HP Neoview SQL.

All SQL Adapters - Version 7 Release 7

• Optimizing IF-THEN-ELSE Using CASE. Optimization is the process in which the adapter translates the projection, selection, join, sort, and aggregation operations of a report request into their SQL equivalents and passes them to the RDBMS for processing.
• Passing the Exact Number of Trailing Blanks to the DBMS. All relational adapters have been enhanced to pass character constants from the initial TABLE request to the database unchanged, without truncating trailing spaces.
• Capturing Rows Affected by DPT SQL Passthru Commands as Dialogue Manager Variables. The &ROWSAFFECTED variable is populated with the number of rows affected by the following DPT DML commands: INSERT, UPDATE, and DELETE.
• Passing the Equivalent of FOCUS PCT to the SQL Engine. The relational adapters optimize aggregation in the presence of the FOCUS PCT function (which has no direct SQL counterparts) to SQL SUM().
• Create Synonym Support for Long Table Names. For RDBMSs that support long table names, you can create a synonym name of up to 128 bytes.
• Using the DPART Function in SQL Generation. A new DPART FOCUS function, which extracts a specified component from a date field and returns it in numeric format, can be passed to SQL for improved performance.
• Optimization of the HPART, DPART, HDIFF, HDATE, and DATEDIF Functions. The relational adapters can translate certain calls to the HPART, DPART, HDIFF, HDATE, and DATEDIF functions to SQL date and time functions, allowing optimization of some TABLE requests with DEFINE fields that call these functions.
• Passing Virtual Fields Defined as Constants to an SQL Engine. A virtual field defined as a constant is passed directly to an SQL database engine (RDBMS) for optimized processing that takes advantage of RDBMS join, sort, and aggregation capabilities.
• Improved Error Diagnostics in Expression Generation. Diagnostic messages and tracing for aggregation functions, DB-lookup of SQL tables, and Cluster join structures that explain SQL statement generation have been improved.
• JDBC-Based Adapters: Cancelling Long Running Requests. You can cancel long running requests from the Web Console. Supported for HP Neoview, JDBC, Microsoft SQL Server, MySQL, Netezza, PostgreSQL, PSQL, Sybase, Transoft, and Unidata.

Adapter for DB2 - Version 7 Release 7

• CAF Support for SQL Statements With Lengths Greater Than 32K. Supports IBM’s increased length of SQL statements from 32K to 2MB.
• Surrogate Keys Support. The Reporting Server supports DB2 IDENTITY columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.
• Support for Change Data Capture for DB2/UDB on IBM iSeries. Support for Change Data Capture is implemented for DB2/UDB on IBM iSeries.
• Support for Change Data Capture on z/OS. Change Data Capture is supported for DB2/UDB on IBM iSeries.
• Support of Multirow-Fetch for DB2 (CAF). The FETCHSIZE value is the number of rows to be retrieved at once using array retrieval techniques for the CLI adapter or a cursor with Rowset positioning and multirow Fetch for the CAF adapter. Accepted values are 1 to 32000. The default is 100. If the result set contains a column that has to be processed as a CLOB or a BLOB, the FETCHSIZE value used for that result set is 1.
• Block Fetch Support. The Adapter for DB2 on iSeries offers Block Fetch Support. The default is 100 rows per fetch. The change consistently shows CPU usage reductions compared to a non-blocked fetch. Actual reductions will vary with the request.
• Passing the SUBSTR Character Function to SQL. The SUBSTR character function can be passed to SQL for optimized processing that takes advantage of RDBMS substring functions.

Adapter for Informix - Version 7 Release 7

• Surrogate Keys Support. The Reporting Server supports Informix SERIAL and SERIAL8 columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.
• Support for SDK 3.0. Informix SDK 3.0 is supported on UNIX and Windows platforms.

Adapter for Microsoft SQL Server - Version 7 Release 7

• Support for Microsoft SQL Server 2005 Synonyms. Supports creation of MS SQL Native Synonyms for MS SQL Server versions 2005 and higher.
• Improved SQL Server Adapter Configuration. The Server connection attribute allows you to choose from the list of Microsoft SQL Servers visible within the local network through the Microsoft SQL Native Client Enumerator.
• Capturing Column and Table Descriptions from SQL Tables. Allows capture of unicode and non-unicode column and table descriptions from Microsoft SQL tables.
• Support for New Date/Time Data Types for Microsoft SQL Server 10. Supports datetime2 (datetime with precision of 7), date (time with precision of 7), and datetime offset data types for Microsoft SQL 2008 server.
• Change Data Capture (CDC) Support for Microsoft SQL Server 2008. The adapter supports Change Data Capture (CDC). It provides the ability to capture incremental changes in the database, making them available to the server.
• Surrogate Keys Support. The Reporting Server supports Microsoft SQL Server IDENTITY columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.
• Passing the SUBSTRV Character Function to SQL. The SUBSTRV character function can be passed to SQL for optimized processing that takes advantage of RDBMS substring functions.
• Owner/Schema Selector. The Owner/Schema parameter allows you to choose from a list of schemas that contain objects within the target database. Schemas that do not contain any objects are not listed.

Adapter for Oracle - Version 7 Release 7

• Support for Non-Unicode Oracle Data Types From Unicode Server. The adapter supports non-Unicode Oracle character sets for char/varchar columns when the reporting server is configured for Unicode.
• Support for Change Data Capture (CDC). The adapter supports Change Data Capture (CDC). It provides the ability to capture incremental changes in the database, making them available to the server.

Adapter for Teradata - Version 7 Release 7

• Surrogate Keys Support. The Reporting Server supports Teradata IDENTITY columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.

Adapter for Sybase - Version 7 Release 7

• Support for Unicode in Sybase IQ. Unicode data is supported for the Adapter for Sybase IQ. To use this feature, the Reporting Server must be configured with UTF-8 code page 65001.
• Create Synonym Support for Comments in Sybase IQ. The adapter picks up comments from the Sybase IQ database table.
• Merged ASE and IQ Configurations. The Adapters for Sybase ASE and Sybase IQ have been integrated into a single Adapter for Sybase from which you can access both ASE and IQ data sources simultaneously.
• Password Encryption for Sybase ASE and Sybase IQ. You can control password encryption when the adapter connects to a Sybase ASE or Sybase IQ data source.
• Surrogate Keys Support for Sybase ASE and Sybase IQ. The Reporting Server supports Sybase IDENTITY columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.

Adapter for Progress - Version 7 Release 7

• Support for Multi-Database Connections. The Reporting Server can take advantage of the Progress automatic multi-database connection capability.

Adapter for Red Brick - Version 7 Release 7

• Surrogate Keys Support. The Reporting Server supports Red Brick SERIAL columns as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.

Adapter for Universe - Version 7 Release 7

• Left Outer Join Optimized. The adapter optimizes a FOCUS Left Outer Join to an SQL Join.
• Representing Universe Multi-Valued Fields. The adapter can present multi-valued fields in a non-normalized way, which allows it to display report in native Universe/Pick style.

Adapter for Excel - Version 7 Release 7. The Adapter for Excel is available as a named adapter on the Web Console SQL adapter selection pane.

Adapter for 1010data - Version 7 Release 7. The Adapter for 1010data is available as a named adapter on the Web Console SQL adapter selection pane.

Adapter for HP Neoview - Version 7 Release 7. The Adapter for HP Neoview is available as a named adapter on the Web Console SQL adapter selection pane.

Adapter for Netezza - Version 7 Release 7. The Adapter for Netezza is available as a named adapter on the Web Console SQL adapter selection pane.

Adapter for MySQL - Version 7 Release 7

• Surrogate Keys Support. The Reporting Server supports MySQL numeric columns with the AUTO_INCREMENT option as surrogate keys using FIELDTYPE=R (read-only) in the Master File and three attributes in the Access File.

Adapter for MetaMatrix - Version 7 Release 7

• Support for Coreid Cookies. The ObSSOCookie is passed from the Web-tier to the WebFOCUS Reporting Server to be used for a MetaMatrix connection.
• Support for Name/Value Pairs for Payload. The PAYLOAD customization option specifies a MetaMatrix trusted payload as one or more comma-delimited pairs (represented as Key, Value) that you can pass to MetaMatrix.

x

Adapter for JSON - Version 7 Release 7.06

• Support for UPDATE. Using DataMigrator, data can be loaded into new JSON targets in a data flow.
• Support for ON TABLE HOLD FORMAT JSON. A report can now save output in JSON (Java Script Object Notation) format.

XML Write Adapter - Version 7 Release 7.06

• Ability to Set Encoding in the XML Header. Previously, the XML Write Adapter always created the XML file with encoding="UTF-8" in the XML header. Now encoding can be specified in the synonym and is written to the XML header.

XML, Web Services, REST and Social Media Adapters - Version 7 Release 7.06

• Redirection Support for HTTP Status Codes 302, 303, and 307. Support has been added for HTTP calls made from the XML, Web Services, REST and Social Media adapters that require a redirection to a different URI. This support includes HTTP status code responses 302, 303, and 307.

All XML-Based Adapters - Version 7 Release 7.04

• Direct Load Flow to Load XML Hierarchy. You can copy a hierarchical structure to an equivalent XML document using Direct Load Flow. Previous releases supported only a single path hierarchy, but now multi-path hierarchies can also be loaded.
• DSTANDARD Versus Actual/Usage Conversion. When retrieving date and time values from salesforce.com, it is no longer required to issue a setting for DTSTANDARD.

Adapter for JSON - Version 7 Release 7.04

• New Adapter for JSON. The new Adapter for JSON supports JavaScript Object Notation (JSON) files as a data source.
• Add Support for JSON as Known File Type and In Editor. Files with type extension of JSON now appear as a known file type in the browser. They can be edited in the text editor and are shown with syntax coloring.

Adapter for XML - Version 7 Release 7.03

• Improved Processing of Large Schemas or DTDs. When creating a synonym from a large schema or DTD, you can use a subset instead of the entire file.

All XML-Based Adapters - Version 7 Release 7.02

• Copying BLOB Data to XML From a Database. The BLOB data type can be copied from a database to XML. The server writes bin64-encoded BLOBs to the XML file.

All XML-Based Adapters - Version 7 Release 7

• Support for a Proxy Server in TSCOM Outbound Connections. External XML data (such as XML/XSD documents) now can be obtained through a Proxy Server according to the server filtering rules.

Adapter for XBRL - Version 7 Release 7

• OLAP-Style Retrieval. Using the XBRLRD Master File, you can show the dimension information associated with concepts and their fact values.
• Support for footnoteLink. The adapter can read the footnoteLink from an XBRL document for reporting purposes.
• Publishing Mapping Tool. You can create a procedure using Developer Studio and create all the mappings necessary to generate output as an XBRL Instance document.

Adapter for XML - Version 7 Release 7

• Create Synonym Indicator (choice and sequence) for XML. Indicators <choice> and <sequence> are included if WRITE=YES is included in the Create Synonym process.
• XML Synonym Option to Relax Syntax Check. You can use the SYNTAX_CHECK Access File parameter to allow for one or multiple sets of tags to be allowed in the XML doc.

x

Version 7 Release 7.06

• Adapter for Axiom EMP. The Adapter for Axiom EMP has been introduced in this release and is available as a named adapter on the Web Console in the ERP folder.
• Adapter for SAP/R3 Setting Execution Mode. From the Change Settings page for SAP, you can select Online or Batch from the Execution mode drop-down menu.

Adapter for SAP - Version 7 Release 7.03

• Support for Cluster Synonyms Composed of BAPI. Support for cluster Master Files on SAP BAPI(s) allows reports on the combined BAPI in a single TABLE or SELECT statement.

Adapter for SAP - Version 7 Release 7.02

• SAP Support for a Function Module.

  There are two attributes (displayed in the Attributes tab of the function module) to consider before using a function module:

  • If the function module is not released (displayed in general data), it is internal to SAP, and a user should use it with extreme caution. From release to release, this function module can be removed or its behavior changed without any SAP prior notice.
  • The attributes normal function module or remote-enabled function module described in the Processing type tab do not make a technical difference for the interface. However, if the function module is RFC-enabled, it may show that SAP has taken some steps to externalize this function module.
• Support for IBM iSeries Platform. The adapter is extended to support SAP customers running on IBM iSeries (EBCDIC). Support for IBM iSeries requires the installation of the RFC 640E SDK (SAP Note 450870). For information on which iSeries OS/400 versions have been released, refer to SAP Notes 156557 and 392165. Support for customers running the new SAP NetWeaver RFC SDK is targeted for a future release.
• Using Explicit and Single Sign-On Connections in the Same Session. Multiple Adapter for SAP data source connections can be defined with more than one type of user ID/password, cookie, password/passthru, or trusted credentials.

Adapter for Peoplesoft - Version 7 Release 7.02

• Effective Date Support. The adapter supports queries involving Effective Date and Effective Sequence (if applicable) database fields.

Adapter for JD Edwards EnterpriseOne - Version 7 Release 7.02

• Improved UDC Lookup Performance. The Adapter for JD Edwards EnterpriseOne has improved performance for UDC (user-defined code) lookups. UDCs are captions (descriptive text) associated with a field, for example, Company Code = 0001.

• Adapter for SAP R/3 - Version 7 Release 7: Support for Single Sign-On Using the SAP SSO Ticket. Single sign-on (SSO) enables you to log in to the SAP portal with your credentials and then access WebFOCUS components, such as the Reporting Server, the Web Console, and the WebFOCUS Client (Managed Reporting) without a secondary logon.

x

Version 7 Release 7.06

• Adapter for Essbase. Two-tier connection support has been implemented for the Adapter for Essbase version 11.1.2 and higher. Since these Essbase versions require Application Manager or higher privileges in order to be able to read the outline while reporting from a cube, a user without those privileges can generate a report or create a synonym by referencing another connection whose user ID has the required privileges.
• Adapter for SAP BW: New Connection Parameters for SNC. Two configuration parameters have been added for SAP BW adapters to support Secure Network Communication (SECURITY_MODE=SNC).
• Adapter for SAP BW NetWeaver 7.x/Hana MDX Unicode. The Adapter for SAP BW NetWeaver 7.x/Hana MDX Unicode has been introduced in this release and is available as a named adapter on the Web Console in the OLAP/SAP folder. The adapter supports SAP BW NetWeaver 7.3 powered by the HANA database, HANA optimized infocubes, and SAP HANA optimized Data Store objects.
• Adapter for SQL Server Analysis Services - Version 7 Release 7.06
  • Certification of Version 2014. Certification is complete for Microsoft SQL Server Analysis Services (SSAS) 2014.
  • Exposing Member Unique Names for Standard Hierarchies. The Web Console screen to create a synonym for SSAS data sources has a button labeled Create Fields for Member Unique Names. Clicking this button adds the UNIQUEIDS INCLUDE syntax to the CREATE SYNONYM command. These names are now also generated using the "7X" style (0x0003), as this style yields shorter unique names and, according to MS SSAS documentation, they are "guaranteed unique names, which are stable over time."
  • Unicode Support. Support has been implemented for Unicode (UTF-8) code page 65001 for the SSAS adapter.

Adapter for SQL Server Analysis Services - Version 7 Release 7.05

• Customized Connection Name. When configuring the Adapter for SQL Server Analysis Services (SSAS), you can now customize the connection name.
• Support for Version 2012. SQL Server Analysis Services Version 2012 is now supported in both MDX and Tabular modes.
• Tabular Deployment. The adapter now supports both the traditional SQL Server 2012 Analysis Services Multidimensional Model and the new Tabular Model.
• Passing READLIMIT to MDX as TOPCOUNT/BOTTOMCOUNT. The adapter can now generate the TOPCOUNT and BOTTOMCOUNT for the reports that have both:

  1. BY [HIGHEST/LOWEST] TOTAL <measure field>              

  2. IF READLIMIT n              

• Generating Qualified Field Names for Dimension Elements. The adapter can now generate Master File field names for dimension elements based on the concatenation of dimension, hierarchy, level, and property captions. This feature is implemented by selecting Generate Qualified Field Names on the Web Console Create Synonym page.
• Support for Multiple Field Restrictions in DBA Security Statements. The adapter now has the ability to use multiple field restrictions connected with the AND operator within a DBA security statement in the Master File for SSAS cubes.

Adapter for Microsoft SQL Server Analysis Services - Version 7 Release 7.04

• Selecting Valid Dimensions for a Measure. A data source view may have multiple fact tables, as well as multiple dimension tables. Each fact table contains records for a specific set of measures called a measure group. A particular measure group may not have a relationship to every dimension table, and if you select a measure/dimension combination where there is no relationship, the returned data might be meaningless. Starting in Version 7 Release 7.04, when you create a synonym, each measure group and its related dimensions are listed at the bottom of the synonym. In addition, the FIELD declaration in each measure in the Master File has a MEASURE_GROUP attribute identifying the measure group to which it belongs. Using this information, the WebFOCUS tools will gray out the dimensions that are not valid for each measure group so that you can make a valid measure/dimension selection for your report.
• Setting ROLLUP_USING_VISUALTOTALS Options From the Synonym Editor. In prior releases of the adapter, you could use the SET ROLLUP_USING_VISUALTOTALS syntax to set a default value for using visual totals, and you could also set a value for a specific file and hierarchy. Starting in the current release, you can use the SET ROLLUP_USING_VISUALTOTALS command to set a default value, but you must use the Synonym Editor to set this parameter for a file or a hierarchy. To retrieve data from a SSAS cube, the adapter translates the WebFOCUS request to MDX, the language that is used by the SSAS engine. SSAS then returns the cells containing values of the selected measures for the specified members. The values stored in the cube are aggregates resulting from rolling up measures along the cube dimensions when the cube was processed, and are based on rolling up all the underlying members of the hierarchy. Some reports perform selections on hierarchy levels below the levels selected for display.

Version 7 Release 7.03

• DBA Support for Level Hierarchies. FOCUS DBA features have been implemented to provide additional security on a file-by-file basis for non-FOCUS data sources, such as SAP/BW, Microsoft Analysis Services 2005/2008, Oracle-Hyperion Essbase 9.x, and other cube adapters.

Adapter for SAP BW - Version 7 Release 7.03

• Reversing the Sign When Displaying a Measure. You can create a synonym that specifies that a measure should display with reversed signs on report output.
• Custom Exit to Set the Value of the MYSAPSSO2 Cookie. The installation can now develop an exit that obtains the MYSAPSSO2 cookie using an external procedure and submits that value for the SAP RFC connection.

Adapter for Essbase - Version 7 Release 7.03

• Requests From Web Console Displayed in Session Log. When requests generated by adapter MDX requests are run from the Web Console, they are displayed in the Web Console Session Log window.

Adapter for Microsoft SQL Server Analysis Services - Version 7 Release 7.03

• Support for Key Performance Indicator (KPI). If a Microsoft SQL Server Analysis data source has Key Performance Indicators (KPIs) defined, you can access and display these performance measures in a WebFOCUS report.

Adapter for SAP BW - Version 7 Release 7.02

• Support for IBM iSeries (EBCDIC Platforms). The adapter is extended to support SAP customers running on IBM iSeries (EBCDIC). Support for IBM iSeries requires the installation of the RFC 640E SDK (SAP Note 450870). For information on which iSeries OS/400 versions have been released, refer to SAP Notes 156557 and 392165. Support for customers running the new SAP NetWeaver RFC SDK is targeted for a future release.
• Using Explicit and Single Sign-On Connections in the Same Session. Multiple Adapter for SAP data source connections can be defined with more than one type of user ID/password, cookie, password/passthru, or trusted credentials.
• Support for MDX Results With More Than 1 Million Instances per Axis. SAP has introduced a new set of OLAP BAPIs that support requests with more than one million instances per axis. The SET USE_RSR_MDX command enables the Adapter for SAP BW to take advantage of these new BAPIs.

Adapter for SQL Server Analysis Services (SSAS) - Version 7 Release 7.02

• Support for Key Performance Indicator (KPI). The Adapter for SQL Server Analysis Services supports the key performance indicator (KPI). This includes a new record in the Master File with the following syntax:

  KPI=KPI_NAME, CAPTION=KPI_CAPTION, 
  KPI_STATUS_ICON='KPI_STATUS_GRAPHIC', 
  KPI_TREND_ICON='KPI_TREND_GRAPHIC' 
   {,PARENT=KPI_PARENT_KPI_NAME} ,$

• Automatic Redirection of UDA References to Attribute Hierarchies. User-Defined Attributes (UDAs) are properties that are represented by Master File fields with the attribute PROPERTY=ATTRIBUTE. They correspond to SSAS metadata entities defined in the MDSCHEMA_PROPERTIES Rowset for hierarchies and their levels. In the Business Management Studio, these entities are created as Attribute Relationships that link attributes comprising hierarchy levels to other related attributes. Examples of such property/attribute relationships could be Color and Net Weight for Product, or Address, Phone Number, and Gender for Customer.

Adapter for Essbase - Version 7 Release 7.02

• Support for Oracle EPM Release 11.1.2.0.0. Support has been added for the API/MDX features of the Oracle Hyperion EPM System Release 11.1.x Client API library.

All OLAP Adapters - Version 7 Release 7

• Limit Removed on Number of WITHINs in a Master File. This enhancement removes any limits associated with the total number of attributes in all dimensions for an SSAS cube.

Adapter for SAP BW - Version 7 Release 7

• Support for Time-Dependent Hierarchies in BW Queries. You can use the SET ENGINE BWBAPI SET KEY_DATE [yyyymmdd] command for time-dependent hierarchies in BW queries.
• Support for Hierarchies in the Synonym Editor. Enables you to view, edit, and delete InfoObject-bearing hierarchies and related attributes that are described in the Master File for an SAP BW data source.
• Refreshing Cube Synonyms. A Refresh option added to the adapter Create Synonym facility, enables you to maintain up-to-date metadata for your SAP BW queries, InfoCubes, and other BW InfoSources.

Adapter for MSOLAP - Version 7 Release 7

• Developing MDSCHEMA Down to MEMBERS Level. The number of SEGMENTS in the MDSCHEMA.MAS file that describes the OLAP data source is extended from four to eleven.

Adapter for SQL Server Analysis Services (SSAS) - Version 7 Release 7

• Implementing Rollups Using the MDX VISUALTOTALS Function. You can implement rollups by using the MDX VISUALTOTALS function.
• Using Dimension Members in a Heading. Dimension members are supported in a report heading, subhead, and footing.
• Developing MDSCHEMA Down to MEMBERS Level. The number of SEGMENTS in the MDSCHEMA.MAS file that describes the OLAP data source is extended from four to eleven.
• Auto Redirection of UDA References to Attribute Hierarchies. You can use the ENGINE SSAS SET USE_ATTRIBUTE_HIERARCHIES ON setting to allow a report request to automatically interpret references to UDA fields as references to attribute hierarchies.
• Using the MSOOLAP 10.0 OLEDB Provider if Present. The SSAS physical level adapter picks up the SSAS 2008 CTP (Katmai) OLAP client if it is present in the system.
• Option Added to Verify Adapter for SQL Server Analysis Services (SSAS) Connection. You can test the SQL Server Analysis Services (SSAS) adapter from the Web Console Adapter page.

Adapter for Essbase - Version 7 Release 7

• Refreshing Cube Synonyms Preserving User Changes. You can refresh Cube synonyms, preserving user changes.

x

Adapter for Microsoft Dynamics CRM 2011 (IWAF) - Version 7 Release 7.06 The IWAF (iWay Adapter Framework) adapter for Microsoft Dynamics CRM 2011 can be used with the WebFOCUS Reporting and DataMigrator server to retrieve data.

Adapter for REST - Version 7 Release 7.06

• Basic Authentication Enabled for Chained Authentication. User credentials can be passed using Basic Authentication for Chained Authentication in a SOAP or REST request.
• Producing a REST Request Trace as a Text File for Diagnostics. The FILEDEF RESTTSCQ command will produce a text file showing the information that a REST request would contain without actually running the REST request.
• Passing an Authorization Token in a REST Request Header. After authenticating through a REST call and receiving a token, all future REST calls for the web service must have the token passed as part of the authorization in the HTTP header.
• Passing a Global Variable for the OBJECT Parameter in a REST Access File. You can pass a global variable for the OBJECT parameter value in a REST Access File.
• Support for Mutual Authentication Certificates for REST and SOAP. A check box labeled SSL Mutual Authentication has been added to the Advanced HTTP connection options collapsible form.

Adapter for REST - Version 7 Release 7.05

• Adapter for REST. The Adapter for REST has been introduced in this release and is available as a named adapter on the Web Console in the Procedures folder.

Adapter for Web Services - Version 7 Release 7.05

• Using TX Fields as Input. The length of unstructured content can vary from a couple of words to many pages, which may be more than the allotted length of an Alpha field. In light of this situation, the Adapter for Web Services can now accommodate TX fields as input.
• Support for Proxy Server Connections Needing NTLM Authentication. Connections through a Proxy server that require NTLM (NT LAN Manager) authentication are now supported.

Query Adapter for Salesforce.com - Version 7 Release 7.04

• Query Adapter for Salesforce.com. The new query adapter for Salesforce.com utilizes SOQL (Salesforce Object Query Language) to simplify creating synonyms and reporting from Salesforce business objects.

Adapter for AddressDoctor - Version 7 Release 7.04

• Adapter for Address Databases. The Adapter for AddressDoctor provides an interface for DataMigrator to allow use of AddressDoctor functions without the need for programming in languages like C++ or Java, or licensing additional development software.

Adapter for Web Services - Version 7 Release 7.03

• Enhanced Support for External Security Policies. The Adapter for Web Services has enhanced support for external security policies. The approach utilizes open source Apache™ Axis2/Rampart Java classes to fulfill the security requirements defined in the Web Services Description Language (WSDL).

Adapter for Web Services - Version 7 Release 7.02

• Create Synonym Facility for Web Service That Returns a .NET Data Set. The Create Synonym facility can be used directly against a WSDL file that has a web service function which returns a .NET data set. This eliminates the former need to run the Create Synonym facility twice.
• BLOB Support. The Adapter for Web Services supports the BLOB data type for use with Sharepoint.
• Passing Multiple Values for the Same Segment of a SOAP Request. The Adapter for Web Services can process a flat file that is embedded in a SOAP Response document. A synonym is created for the segment, which can also include multiple values.
• Generating Output From a Procedure Run as a Web Service. The Adapter for Web Services can handle output HOLD files like PDF or GRAF and return them as single bin64-encoded response elements.

All Procedure Adapters - Version 7 Release 7

• Using a Virtual Field to Hold Current File Name. A DATASET parameter or a FILEDEF for a flat file can use an asterisk (*) as a wildcard to represent multiple files. To identify which file (of many) a record comes from, you can add a field with an ALIAS of INSTANCE to the Master File. When used in a SELECT, TABLE, or MODIFY procedure, that field will have the name of the specific file.

Adapter for Web Services - Version 7 Release 7

• Passing a Blank Element as Input to an Element. The adapter handles a blank element in the WHERE condition differently from a NULL element.
• Support for ARRAY_ITEM for Unbounded Elements. During synonym creation, the adapter sets the attribute ACCESS_PROPERTY=MULTIVALUES on the field level when it finds maxOccurs=unbounded for a particular Object or Element definition in the XSD.
• Support for Windows Communication Foundation (WCF) Data Services. The adapter supports Windows Communication Foundation (WCF) Data Services.

x

Adapter for Excel (via Direct Retrieval) - Version 7 Release 7.06

• File Listener for Excel Worksheet. The File Listener component of DataMigrator can process Microsoft Excel workbooks that are delivered to a specified directory. In addition to the synonym for the workbook as Excel (via direct read), this requires a synonym for a flat file with the normal file listener parameters specified. An additional segment contains a copy of the synonym for the Excel workbook.

Adapters for Flat and Delimited Flat Files - Version 7 Release 7.06

• Reading a Field Containing Delimited Values as individual Rows. A field that contains a list of delimited values (such as email addresses separated by spaces) can now be pivoted to be read as individual rows when an additional segment is added with SEGSUF=DFIX (Delimited Flat File).
• Option to Show Raw Data When Creating a Synonym for a Delimited File. hen creating a synonym for a delimited flat file, the user may need to look at the file in order to see whether there is a header line, what is being used as the delimiter, and what is being used as the enclosure character, if there is one. The Show File option was added to display the selected file.

UPLOAD Support for Discovery of Erroneous Input Data - Version 7 Release 7.06

• When creating metadata and loading data from an Excel worksheet, detection of erroneous data, such as non-numeric values, has been improved.

Trimming Blanks from Uploaded Files - Version 7 Release 7.06

• When working in debug mode, the Change Common Adapter Settings page has a group named Data cleansing functionality (DCF) settings that has a drop-down list for trimming leading spaces and another for trimming trailing spaces.

Adapter for Excel (via Direct Retrieval) - Version 7 Release 7.05

• Creating Synonyms for Named Ranges. When creating a synonym and after selecting a workbook, you can now see a list of all the named ranges in the workbook. You will be able to create a synonym for any of those named ranges.

Sequential and Indexed Adapters - Version 7 Release 7.04

• File Listener Enhanced to Monitor Files and Subdirectories. The File Listener has a new Monitor capability to detect files of any type that are added, changed, or removed in a specified directory (and subdirectories) without reading them. The action, full path, and name are available in a data flow.
• Support RECTYPE and OCCURS with SUFFIX=DFIX. Sequential and Indexed Adapters now support variable length records and mixed record types using OCCURS and RECTYPE respectively, for delimited flat files.
• Adapter for C-ISAM: Access to Micro Focus Cobol Files Without an Index File. The adapter has been enhanced to support access to Micro Focus® Cobol files without requiring an index file.

Adapter for Excel (via Direct Retrieval) - Version 7 Release 7.03

• Adapter for Excel (via Direct Retrieval). Available as a named adapter on the Web Console in the Sequential and Indexed folder. It supports direct retrieval from Excel files (.xls and .xlsx files).

Adapter for Flat Files - Version 7 Release 7.03

• Virtual Field Added to Hold Current File Name. A DATASET parameter or a FILEDEF for a flat file can use an asterisk (*) as a wildcard to represent multiple files.

Adapter for Flat Files - Version 7 Release 7.02

• Support for File Listener and FTP Options. A File Listener mode is available to process TABLE or MODIFY requests on collections of data files.
• Support for UTF-16. The Adapter for Flat Files can read Unicode UTF-16 files as data sources.
• Adding a Virtual Field to Hold Current File Name. A DATASET parameter or FILEDEF for a flat file can use an asterisk (*) as a wildcard to represent multiple files. To identify which file (of many) a record comes from, you can add a field with an ALIAS of INSTANCE to the Master File. When used in a SELECT, TABLE, or MODIFY procedure, that field will have the name of the specific file.

Adapter for Delimited Flat Files - Version 7 Release 7.02

• Support for UTF-16. The Adapter for Delimited Flat Files can read Unicode UTF-16 files as data sources.

Adapter for Flat Files - Version 7 Release 7

• Support for Listening Mode. The Adapter for Flat Files has been enhanced with File Listener mode to process TABLE or MODIFY requests on collections of data files.

Adapter for Delimited Flat Files - Version 7 Release 7

• Support for Synonym Creation for CVS Files Uploaded From the Desktop. When creating synonyms for comma-delimited files, you can upload the files from a local Windows machine.
• Extended Mapping Functionality Allows Parameterization. Extended mapping functionality allows parameterization of OCCURS and POSITION attributes in SEGMENT definitions.
• Support for Linefeed. You can use the PRESERVEFRMT synonym attribute to define whether original non-printable characters in a field value are preserved or replaced by printable characters.

x

Adapter for Salesforce - Version 7 Release 7.06

• JOIN Support. Child-to-parent retrieval (reversed join) queries are now enabled for custom objects. This feature adds support for queries with multiple objects.

Adapter for iWay Adapter Framework (IWAF) - Version 7 Release 7.05

• Single Login Support. When using the Adapter for iWay Adapter Framework (IWAF) for a connection, such as to salesforce.com, each operation generates a server login. This could result in a large number of login attempts. Now this situation can be handled with a single login.

Adapter for Adabas - Version 7 Release 7.04

• Support Added for Multiple SVCs and Logical Names. The Adapter for Adabas supports the Logical name to help identify the particular set of connection attributes defining connections to the same or different database(s). This feature significantly enhances adapter flexibility by allowing access to databases with different SVCs and releases through the same adapter.

Adapter for Adabas - Version 7 Release 7.03

• Support Added for Release 8 Extended Adabas Control Block (ACBX). The Adapter for Adabas supports the Extended Adabas Control Block (ACBX), introduced by SoftwareAG in Adabas 8.

Adapter for LDAP - Version 7 Release 7.03

• Retrieval From Selected Object Classes. To enable retrieval from selected object classes, the adapter supports flat views of LDAP objects with the SCHEMA FLAT processing mode.

DBMS Adapters - Version 7 Release 7.02

• Testing a Connection Before Configuring an Adapter. When configuring an adapter, you can test the connection before completing the configuration. The Test button appears to the right of the Configure button.
• Adapter for Adabas - Version 7 Release 7.02: Support for Record Buffers Larger Than 32K. The Adapter for Adabas can read Adabas record buffers that are longer then 32K when processing MU/PE (simple PE only) fields.

• Adapter for Adabas - Version 7 Release 7: Support for LA and W Fields. Support has been added for the following Adabas 8 data types: LA fields (native Adabas CLOB data) and Unicode fields in W format.

x

Version 7 Release 7.06

• Adapter for Google Analytics. Report against the information residing in the Google Analytics environment. Metrics, such as Page Views and Users, can be analyzed by various dimensions (for example, Country and City).
• Adapter for Facebook: Enhanced Create Synonym Functionality. Create Synonym functionality has been enhanced to create DataMigrator flows and metadata for SQL Server tables to support the warehousing of Facebook information.
• Adapter for Twitter: Enhanced Create Synonym Functionality. Create Synonym functionality has been enhanced to create DataMigrator flows and metadata for SQL Server tables to support the warehousing of Twitter information.
• Adapter for LinkedIn. The Adapter for LinkedIn has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder.

Version 7 Release 7.05

• Adapter for Facebook®. The Adapter for Facebook has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder.
• Facebook Wizard. The Facebook Wizard enables you to easily configure and use the Adapter for Facebook.
• Adapter for Alchemy. The Adapter for Alchemy has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder. It provides sentiment analysis of documents or web pages.
• Adapter for WAND®. The Adapter for WAND has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder. It provides consumer sentiment analysis using software from WAND, Inc.
• Adapter for Words Analysis. The Adapter for Words Analysis has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder. It performs word analysis on text fields.
• Adapter for Twitter®. The Adapter for Twitter is a Candidate for Release and is available as a named adapter on the Web Console in the Social Media folder. It provides the ability to read tweets for a specific Screen Name and perform a search on words indexed by Twitter for tweets.
• Twitter Wizard. The Twitter Wizard is a Candidate for Release. It enables to you easily configure and use the Adapter for Twitter.