Oracle Essbase Integration Services
Release 11.1.2.0.000 Patch Set 1 (PS1): 11.1.2.1.000
Readme
Supported Paths to this Release
Defects Fixed in Release 11.1.2.0
This document includes important, late-breaking information about this release of Oracle Essbase Integration Services. Review this Readme thoroughly before installing Integration Services.
Late-breaking information about installation of EPM System products is provided in the Oracle Hyperion Enterprise Performance Management System Installation Readme. Review this information thoroughly before installing EPM System products.
Information about system requirements and supported platforms for EPM System products is available in a spreadsheet format in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on the Oracle Technology Network (OTN) and listed in the Oracle Business Intelligence product area:
http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html
Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab in the Oracle Hyperion Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN (listed in the Oracle Business Intelligence product area):
http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html
<Input Shannon's update of 6/27. // Input updates from Shannon through 3/8>You can upgrade to EPM System Release 11.1.2.1 from the following releases:
Note: For instructions to upgrade, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide, “Upgrading EPM System Products.”
|
Release Upgrade Path From |
To |
|
11.1.2.0.x |
11.1.2.1 Note that when moving from Release 11.1.2.0.x to Release 11.1.2.1, you use the "Apply Maintenance Release" option in EPM System Installer, instead of following the documented upgrade procedures. |
|
11.1.1.3.x |
11.1.2.1 |
|
9.3.3.x Note: If you were using Performance Management Architect Release 9.3.1, you can download the Performance Management Architect release 9.3.3 from My Oracle Support. |
11.1.2.1
|
|
9.2.1.x |
11.1.2.1 |
|
An environment that includes multiple releases, which can include an environment with one instance of Shared Services or an environment with two instances of Shared Services |
See “Upgrading from an Environment with Multiple Releases” in the "Upgrading EPM System Products" chapter in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. |
Notes:
· If you are starting from Release 9.2.x, Oracle recommends the following upgrade path: 9.2.0 to 9.2.1 to 11.1.2.1
· If you are starting from Release 9.3.x, Oracle recommends the following upgrade path: 9.3.0 to 9.3.1 to 9.3.3 to 11.1.2.1
· If you are starting from Release 11.1.1.x, Oracle recommends the following upgrade path: 11.1.1.0 or 11.1.1.1 or 11.1.1.2 to 11.1.1.3 to 11.1.2.1
· If you are starting from an earlier release, Oracle recommends that you upgrade to the highest level release that directly supports upgrade from your starting release.
· Security Synchronization between Essbase and Shared Services was removed in Essbase Release 9.3, starting with Release 9.3.1.4.1. Essbase and Shared Services Release 11.1.1.3, however, still synchronize security information. For this reason, if you are using Essbase Release 9.3.1.4.1, 9.3.1.5, 9.3.1.6, or 9.3.1.7, you must first upgrade all products to Release 9.3.3, as recommended above. Upgrading to Release 11.1.1.3 is not an option for these Essbase releases.
|
Defect Number |
Description of Fix |
|
• 9955378 |
When adding drill-through reports, a copy is no longer created in error when clicking "No" in response to the question, "Do you want to make a copy @ of report 'Report 1'? |
|
• 10246476 |
Integration Server now loads members and data to Unicode-enabled aggregate storage applications without errors. |
|
Defect Number |
Description of Fix |
|
• 7378293 |
Member loads and data loads from two different data sources fail. |
|
• 7420035 |
Integration Services hangs in production environment because of RDBMS utility. |
|
• 7559453 |
A compression dimension is not applied to the Product dimension after being applied to the Accounts dimension following a data load or member load. |
|
• 8304260 |
Data loads into an aggregate-storage-option (ASO) cube fails when the dataload is run from a cube building script (CBS) script. |
|
• 8309113 |
Decimal data from RDBMS is not loaded in Integration Services when there are null columns in a row. |
|
• 8329903 |
Message for error 2004002 (re: invalid model) contains no text. |
|
• 8868519 |
Integration Server 11.1.1.2 inserts the characters ^M at the end of every line in the /sample/tbcdbase scripts. |
|
• 9083714 |
Integration Services Console disappears if Use Alternate Fact Table is selected during a data load. |
The following issues are the noteworthy known issues of this patch.
|
Defect Number |
Known Issues |
|
6536313 |
When using the Drill-Through Wizard in Essbase Spreadsheet Add-in, users will only see the first 80 characters of the table or column name. |
|
6551802 |
If column names contain 0x5C double-byte characters, the columns may not display in a table. |
|
6576813 |
The JISX0213 Japanese character set, which replaces the JISX0208 and JISX0212 Japanese character sets, is supported on Windows Vista. The Oracle Essbase family of products, including Integration Services, does not support the JISX0213 Japanese character set. |
|
6584211 |
When building a shared hierarchy for a block storage database, adding a shared hierarchy a second time may duplicate the values stored on a single element, resulting in incorrect data. This problem occurs when shared members are from the same hierarchy, such as these two hierarchies from the TBC sample database: Diet > 100-20 and 100 > 100-20. Workaround: Use user-defined SQL to edit data load commands. |
|
7253757 |
On Windows 2003 SP1, after installing Integration Services, the EPM System Installer uses Windows services to start and stop the services for Integration Services. Sometimes after stopping the service using Windows Services console, the Integration Server process, olapisvr.exe, continues to run. Workaround: Manually stop the “olapisvr.exe” and “olapisvc.exe” processes by using the Windows Task Manager. |
|
7386388 |
Data is not available in Excel although Integration Services Console indicates a successful data load. Workaround: Perform the data load twice. |
|
7482771 |
Using the INCRESTRUC setting in the essbase.cfg file when performing an incremental restructuring does not work on large outlines. The outline must have less than 2 billion possible blocks for Essbase to allow for incremental restructuring. The number of possible blocks is equal to the number of members in each SPARSE dimension multiplied with each other. For example, consider an outline with five dimensions, and the number of members in each dimension is 50, 10, 100, 1000, and 10,000. If the first dimension is dense and all other dimensions are sparse, then the total number of possible blocks is 10 billion (10*100*1000*10,000).Incremental restructure is not possible in this example. However, if both the first and second dimensions are dense, the number of possible blocks is 1 billion. Incremental restructure is possible. |
|
7831887 |
Integration Services does not support connections to Shared Services. Attempting to connect to Shared Services will result in the error message, “JAVA.LANG no such method.” |
|
9320561, 10320758 |
XML Import/Export and sample application creation are not supported on 64-bit UNIX platforms or on the Windows 2008 64-bit platform. |
|
9354454 |
When Integration Server is started before the crontab file is created, operations such as data loads may fail, and the error number OLAPISVR 2001011 is displayed. (Missing error text reads, “Cannot open a file in the crontabs directory.” ) Workaround: Before starting the Integration Services server, issue a “crontab – e” command to create the crontab file. Save the crontab file and then start the server. |
|
9956385 |
When creating an OLAP Metadata Catalog, ODBC errors may appear in the olapisvr.log file even though catalog creation was successful. The bolded lines below are examples of the types of ODBC errors you might see in olapsvr.log: [DataDirect][ODBC SQL Server Native Wire Protocol driver][Microsoft SQL Server] Invalid object name 'OM_DESCRIPTIONS'.
[DataDirect][ODBC SQL Server Native Wire Protocol driver][Microsoft SQL Server] Invalid object name 'OM_INFO'. |
|
N/A |
DB2 OS/390 is supported only as a data source and should not be used as an OLAP Metadata Catalog. If you use IBM DB2 OS/390 as a data source, you must add an entry to the ais.cfg file for each data source name you configured in your DataDirect Wire Protocol driver for DB2. Add an entry to the ais.cfg file in the following format: [DS:dsn:390]. For example, using the sample database, TBC, the following is the entry to the ais.cfg file: [DS:TBC:390] |
|
N/A |
Note the following regarding ODBC: · “Localhost” is not a valid server name. In the Login dialog box, you must specify a computer name or IP address in both the Integration Server frame and the Essbase Server frame. · For UNIX systems, Integration Services installation creates a template odbc.ini. To store information about how to connect to a relational data source, edit the file using your preferred editor. · To configure a Teradata data source, the TDODBC environment variable must be set manually. |
|
N/A |
Multibyte-character-set characters should not be used in the names of OLAP models, metaoutlines, data sources, and owners. |
|
N/A |
If you run Integration Services on Windows and access an Oracle database as an MBCS or Unicode data source using the DataDirect Wire Protocol Driver, characters corresponding to 0x4E88 in UTF-8 encoding may not be processed properly. |
|
N/A |
Due to database restrictions in some databases such as Oracle, if the IN clause has more than 1,000 outline members that require updating during time-based incremental loads, SQL statements may not execute. In such cases, we recommend full loads rather than time-based incremental loads. |
|
N/A |
Although Oracle Essbase Administration Services validates recently added functions in formulas for the block storage option (BSO), Integration Services may not. We strongly recommend you use Oracle Essbase Administration Services to validate these functions. |
|
N/A |
If you use Japanese encoding, Oracle recommends you use MS932 encoding instead of Shift-JIS. |
|
N/A |
If you customize drill-through reports at run time and add a user-defined filter, keep the length of the filter under 8KB; otherwise, some members may not be included in the drill-through report query. |
|
N/A |
To verify member formulas, users must have Create access to the Essbase Server. |
|
N/A |
Drill-through operations are not supported on Unicode data in release 11.1.2. |
|
N/A |
The current batch files and scripts used to create the TBC sample tables and to load the sample data do not function with SQL Server 2005. These files require the executable named SQLCMD.EXE. Workaround: Edit the batch file install_sqlsrv.bat located in the AIS\samples directory, and replace the name of the executable ISQL.EXE with the new executable name SQLCMD.EXE. |
|
N/A |
When managing Oracle’s Hyperion Shared Services models and naming applications, you cannot use the forward slash (/), backslash (\), or double quotation (“) characters. |
|
N/A |
Oracle recommends that your users be granted read-only permission to external data sources for drill-through reports and custom data load SQL. |
|
N/A |
If you are using Windows Server 2003 Service Pack 1 with Integration Services, your system may experience an abnormal shutdown. To prevent this, install the update from Microsoft by going to: http://support.microsoft.com/kb/923996/. |
|
N/A |
Integration Services does not support updating drill-through information in an outline containing duplicate member names. For such outlines, you should perform a full member load. |
|
N/A |
If the Time dimension is built directly from the fact table, and you select an alternate fact table, the data load may reject those records for which time members are not found in Oracle Essbase. In such cases, be sure that the time dimension is built to span time periods of all fact tables. |
· Integration Services supports full Unicode functionality only on Oracle relational database servers.
· Oracle recommends you use the same language for your Data Source Names (DSNs) as you use for your applications. (English will work in all cases.)
·
When creating a drill-through report with an OLAP intersection
level based on a user-defined dimension or column, neither of the variables of
the form $$dimension-COLUMN$$ or
$$dimension-VALUE$$ will be created.
The most recent version of each EPM System product guide is available for download from the Enterprise Performance Management System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html). For faster access to the documentation, you can also use the Enterprise Performance Management Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html) which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.
Deployment-related documentation is also available from the Oracle E-Delivery Web site (http://edelivery.oracle.com/EPD/WelcomePage/get_form).
Individual product guides are available for download on the Oracle Technology Network Web site only.
When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid.
Workaround: Cut and paste from the HTML version of the document.
Oracle® Essbase Integration Services no longer supports Oracle® Call Interface (OCI). References in the documentation to OCI should be disregarded.
It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. This Readme file is accessible in HTML format.
Copyright © 2011, Oracle and / or its affiliates. All rights
reserved.
http://www.oracle.com