Oracle® Hyperion Provider Services

Release 11.1.2.0.000 Patch Set 1 (PS1): 11.1.2.1.000

Readme

Purpose. 1

New Features. 1

Installation Information. 1

Supported Platforms. 2

Supported Languages. 2

Supported Paths to this Release. 2

Defects Fixed in this Release. 3

Defects Fixed in Release 11.1.2.0. 4

Known Issues. 5

Tips and Troubleshooting. 6

Documentation Updates. 6

Accessibility Considerations. 7

 

Purpose

This document includes important, late-breaking information about this release of Hyperion Provider Services. Review this Readme thoroughly before installing Provider Services.

Top of Document

New Features

See the Oracle Hyperion Provider Services New Features.

For new features relating to installation, architecture, and deployment changes in this release, see “New Features” in the Oracle Hyperion Enterprise Performance Management System Installation Readme.

Top of Document

Installation Information

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.

Top of Document

Supported Platforms

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

Top of Document

Supported Languages

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

Top of Document

Supported Paths to this Release

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.

Top of Document

Defects Fixed in this Release

Defect Number

Defect Fixed

• 7347141

Customized data perspectives created in Smart View Smart Slices are lost upon refresh if free form operations are performed.

• 8456130

In Smart View, the Member Selection dialog box may not display the list of members for each dimension.

• 8502594

In Smart View, member names that contain an ampersand (&) are treated as a substitution variable and must be placed within brackets and quotation marks in order to be interpreted as a member name.

• 9438068

In Smart View, the Member Selection dialog box filter may not display all user-defined attributes (UDAs) if there are more than 100 UDAs in the outline.

• 9404387

JAPI sessions and XMLA sessions cannot be processed in parallel; they must be processed serially. When a request times out, we recommend that you create a new session rather than use the same session to process any other requests. The reason is that Provider Services might still be processing the request that has timed out on the client side, and any subsequent request issued to Provider Services will result in concurrent requests for the same session.

• 9448140

In Smart View, when you try to create a Smart Slice with more than 200 user-defined attributes (UDAs), Excel may freeze.

• 9488558

When working with recursive hierarchy drill-through, if you specify drill-through by generation, the drill-through report is not populated.

• 9491559

When working with recursive hierarchy drill-through, if you specify drill-through by level and provide a level number, users are able to drill-through on all levels, not only the one you specified.

• 9665573

You cannot retrieve data for an outline that contains duplicate and shared members using fully qualified names in Smart View.

• 9693564

If you create a script in EIS to perform incremental updates and then run the script from the command line, you get a “Cannot perform cube view operation, null” error when you try to drill down in Smart View. This does not happen if you run the script from EIS.

• 9797078

Smart View cannot connect to Oracle Business Intelligence Enterprise Edition 11g through Provider Services.

• 9871108

In Smart View, if both Include selection and Within selected group are selected as Member Selection options, the grid is displayed wrongly when a dimension is pivoted from the grid to the POV.

• 9886065

Increasing the number of maximum allowable rows in the Provider server does not work.

• 9899590

Java API invokes set-active calls for each instance of the main API. This can consume a large amount of time on Essbase. With the fix, all set-active calls are optimized in JAPI and only one set-active is sent to Essbase during a user session.

• 9871108

In Smart View, if both Include selection and Within selected group are selected as Member Selection options, the grid is displayed wrongly when a dimension is pivoted from the grid to the POV.

• 9886065

Increasing the number of maximum allowable rows in the Provider server does not work.

• 10163140

Provider Services may issue a stack overflow error, after which it freezes and accepts no further connections.

• 10181819

Drill-through performance in Smart View is very slow.

• 10214443

In Smart View free-form mode, you may get an error if the Essbase outline contains aliases for dimensions.

• 10363455

After the initial log on and off, user names do not appear in Provider Services.

• 10416397

When you try to connect to Provider Services through Administrative Services, you get several error messages.

 

Top of Document

Defects Fixed in Release 11.1.2.0

Defect Number

Defect Fixed

• 7516872

Applications whose names are greater than 8 characters in length may cause an error. In this release, application names can contain up to 30 characters.

• 8207401

During ad hoc analysis in Smart View, if you change POV values from base values and refresh, refresh works as expected. However, if you then enter free form mode and refresh, all POVs are set back to base values.

• 8244313

In Smart View, if Repeat Member Labels Suppression is enabled in Smart Slice preferences, incorrect data may be returned when you refresh after performing an Excel delete.

• 8397348

Essbase text lists that contain Cyrillic characters are not visible in Smart View.

• 8547688

In Smart View with German regional settings, numbers entered may be returned incorrectly after refreshing. For example, 32,45 may become 32.450.000.000.

• 8596467

The Java API method setPasswordChangeNeededNow(true) does not work. The reason is that this method has been deprecated.

• 8603848

In Smart View, Provider Services accepts invalid cube names that are passed to the VBA function HypExecuteCalcScriptEx() rather than throwing an error.

• 8689647

In Smart View, running the VBA function HypDeleteCalc results in an error even if no actual error exists.

• 8845267

In Smart View, if you attempt to log into a data source without proper permissions, you receive an "Requested operation failed. Error: java.lang.NullPointerException" message rather than one that states that you do not have permission.

• 8875047

In the Smart View Query Designer, when you filter on “Levels” nothing is returned for dimensions with more than one word in their names.

• 8914243

In XMLA, queries against measures whose name contains an ampersand (&) result in an error.

• 8927887

XMLA queries generated via the Microsoft Reporting Services are significantly slower than the same queries run in Administration Services.

• 8965389

If multiple Essbase servers are defined in Provider Services, only applications from the first server defined are displayed in Smart View.

• 8965395

Invalid members (members that are shown in the POV but do not exist in the outline) may cause Excel to terminate abruptly. Now, instead of terminating, Smart View displays an error message and enables users to select a valid member name.

• 8989951

In Smart View, you cannot perform queries against Oracle BI EE.

• 9003778

Date measures submitted to Essbase in Spreadsheet Add-in may be incorrect when retrieved in Smart View.

• 9041719

XMLA clients do not return the correct number of members in dimensions that contain more than 10,000 members.

• 9233608

Multiple calls to Essbase from HsGetValue in Smart View through Provider Services may result in “stuck thread” errors.

 

Top of Document

Known Issues

The following issues are the noteworthy known issues of this release.

 Defect Number

Known Issues

9104922

MaxL statements that require API support do not work. On such statements, you will receive an error message that the statement is not supported.

8674073

In Smart Slice dimensions that contain more than 5000 members, not all members will be displayed when users zoom in on the dimension. To use Smart Slices on dimensions with more than 5000 members, in the essbase.properties file, located in EPM_ORACLE_INSTANCE\bin, set the property service.olap.dataQuery.grid.maxRows=0 and increase maximum heap size to 512M. Restart Provider Services.

9071025 

Users connected to Essbase through Provider Services may be prompted repeatedly to log into Essbase for an obsolete connection used in a previous session. Workaround: From Shared Services, locate datasource.xml and manually edit the file to delete obsolete connections.

11655006

Ensure that you use the correct syntax to specify secure mode. When you set the OLAP_NAME to cluster URL, use the values “yes” or “no” to specify whether you want to use secure mode, for example, OLAP_SERVER=http://<servername>:<port>/aps/Essbase?ClusterName=Win32Cluster-1&SecureMode=yes

All other values (for example, SecureMode=true or SecureMode=false) are invalid and are interpreted by Provider Services as SecureMode=no.

If you use invalid syntax, no error message is generated, nor is the connection halted. Therefore, if you were to enter SecureMode=true to specify secure communication, it would be interpreted as SecureMode=no, and the connection would be made successfully but not in secure mode.

11772464

In XMLA stateless session, you may get this error message: "...Concurrent requests on the same session are not allowed. Wait till the previous request completes processing or kill the request....”

11839647

When you connect a Java API client to  Essbase using a Provider Services URL without the port, for example, http://<hostname>/aps/Essbase?ClusterName=<logical name>, you may get the following error: Cannot connect to Essbase server, Error(1030027): Port length must be less or equal to 9 character9Including white space) when passed to ESSAPI function  EssLogin.

This occurs only in Provider Services instances that are deployed on default ports (80/443) and only for Java API clients that use the Provider Services URL as the OLAP server name for resolving the Essbase logical name for implementation in release 11.1.2.

11898620

When you use the Essbase cluster URL in a Java API client program running in 3-tier APS mode, the Provider Services host used to resolve the Essbase cluster URL is the Provider Services host name to which the client is connected in the 3-tier mode; the Provider Services host name within the Essbase Cluster URL is not used. These two references to Provider Services hosts are usually same. When you use the Essbase cluster URL in a Java API client program running in embedded 2-tier mode, then the Provider Services host used to resolve the Essbase cluster URL is the Provider Services host name within the Essbase cluster URL.

 

Top of Document

Tips and Troubleshooting

If you use Oracle BI EE with Provider Services, Oracle recommends that you increase maximum heap size to 512M.

Top of Document

Documentation Updates

Accessing EPM System Product Documentation

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.

Copying and Pasting Code Snippets from PDFs

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.

Top of Document

Accessibility Considerations

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. The Oracle Hyperion Provider Services Administration Guide and this readme file are accessible in HTML format.

The most up-to-date version of this guide can be found in the EPM System Documentation Library on the Oracle Technology Network  (http://www.oracle.com/technology/documentation/epm.html).

Top of Document