Table of Contents:
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 Oracle Enterprise Performance Management System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration 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 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):
Note that XML Import/Export and sample application creation are not supported on the following platforms:
Windows 2008 64-bit
IBM DB2 when used on Windows 2003 64-bit
Information about supported languages for EPM System products is available in a spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:
You can upgrade to EPM System Release 18.104.22.168 from the following releases:
For instructions to upgrade, see the Oracle Enterprise Performance Management System Installation and Configuration Guide, "Upgrading EPM System Products."
Table 1. Supported Paths to this Release
|Release Upgrade Path From||To|
When moving from Release 22.214.171.124.x or 126.96.36.199.x to Release 188.8.131.52, you use the "Apply Maintenance Release" option in Oracle Hyperion Enterprise Performance Management System Installer, instead of following the documented upgrade procedures.
For Oracle Hyperion Financial Close Management, applying the maintenance release is supported only from Release 184.108.40.206.
If you were using Oracle Hyperion EPM Architect Release 9.3.1, you can download the Oracle Hyperion Shared Services release 9.3.3 from My Oracle Support.
A release earlier than Release 9.3.3.x
If you are upgrading from a release earlier than 9.3.3.x, you must first upgrade to a supported release and then upgrade to release 220.127.116.11. For upgrade procedures for the earlier release, see the product installation guides for the interim release that you are upgrading to.
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 Enterprise Performance Management System Installation and Configuration Guide.
If you are starting from Release 18.104.22.168+, 9.3.0.x, 9.3.1.x (except for Oracle Essbase 22.214.171.124.1, 126.96.36.199, 188.8.131.52, and 184.108.40.206), or 11.1.1.x, Oracle recommends that you upgrade to Release 220.127.116.11 as your interim release. 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 18.104.22.168.1. Essbase and Oracle Hyperion Shared Services Release 22.214.171.124, however, still synchronize security information. For this reason, if you are using Essbase Release 126.96.36.199.1, 188.8.131.52, 184.108.40.206, or 220.127.116.11, you must first upgrade all products to Release 9.3.3, instead of Release 18.104.22.168.
If you are coming from Release 22.214.171.124 or 126.96.36.199, use the Defects Fixed Finder tool to review the list of defects fixed between those releases and Release 188.8.131.52.100. This tool is available here:
13471002 -- From the Drill-Through Reports dialog box, when making a copy of an existing drill-through report, the report does not copy completely. The OLAP Intersection Levels and the Drill-Through Report Columns lists are empty.
The following issues are the noteworthy known issues of this patch.
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:
For example, using the sample database, TBC, the following is the entry to the ais.cfg file:
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:
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 Essbase. In such cases, be sure that the time dimension is built to span time periods of all fact tables.
6536313 -- When using the Drill-Through Wizard in Oracle 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 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 Oracle Hyperion Enterprise Performance Management 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 Oracle 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, 13654820 -- XML Import/Export and sample application creation are not supported on the following platforms:
Windows 2008 64-bit
IBM DB2 when used on Windows 2003 64-bit
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 Integration 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
10073704 -- Hybrid Analysis is not supported on aggregate storage databases. Note that the Integration Services Console does not prevent you from enabling a metaoutline for aggregate storage, even when it contains members that are enabled for Hybrid Analysis.
13720788 -- After successfully logging into Integration Services, a read lock error occurs when trying to launch an OLAP model or metaoutline. The error message reads, “Failed to set a read lock”.
Workaround: To correct this problem, you must implement a connection option, “TimestampTruncationBehavior” as described in Oracle Only: OLAP Model or Metaoutline Read Lock Error in the Tips and Troubleshooting section.
13696003 -- The member and data load scheduling functionality in Integration Services Console does not work in a Windows 2008 on 64-bit environment.
Workaround: Use the Save Script functionality in the Member and Data Load dialog box to create a CBS script. Then use Windows Task Scheduler to run the script.
After successfully logging into Integration Services, a read lock error occurs when trying to launch an OLAP model or metaoutline. The error message reads, “Failed to set a read lock”.
To correct this problem, a connection option, “TimestampTruncationBehavior” must be implemented as follows:
Windows: To add the connection option to the data source listing in the Windows Registry:
UNIX: To add to the connection string to a DSN entry in the odbc.ini file:
[oradata] Driver=/EPM_ORACLE_HOME/common/ODBC/Merant/6.1/lib/arora25.so Description=DataDirect 6.1 Oracle Wire Protocol HostName=oraclehost SID=tbc1 PortNumber=1521 TimestampTruncationBehavior=1 ... [ODBC] IANAAppCodePage=4 InstallDir=products/common/ODBC/Merant/6.1 Trace=0 TraceDll=products/common/ODBC/Merant/6.1/lib/odbctrac.so TraceFile=odbctrace.out UseCursorLib=0
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 downloading or viewing from the EPM System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html). You can also use the Oracle Enterprise Performance Management System 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 Software Delivery Cloud 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.
Windows Vista and later versions of Windows do not include the WinHlp32.exe file. This file must be installed in order to open and view the online help (HLP and CNT files).
To obtain and install the WinHlp32.exe file directly from Microsoft, go to this link:
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.
Recently used OLAP models and metaoutlines no longer display in the File menu of the Integration Services Console.
To view all OLAP models and metaoutlines, select File, and then Open. The Existing tab of the Welcome dialog box is displayed where you will find listed all OLAP models and metaoutlines associated with the OLAP Metadata Catalog to which you are connected.