Internet Explorer (IE7, IE8, IE9, IE10 and IE11) Recommended Settings for Oracle Hyperion Products (Doc ID 820892.1)

To Bottom

---

APPLIES TO: Hyperion Essbase Administration Services - Version 9.3.0.0.00 and later Hyperion Planning - Version 9.3.1.0.00 and later Hyperion Financial Data Quality Management - Version 9.2.0.0.00 and later Hyperion BI+ - Version 9.3.0.0.00 and later Hyperion Financial Management - Version 9.2.1.0.00 and later Information in this document applies to any platform. GOAL Some Internet Explorer versions discussed in this article are not compatible with certain releases of Oracle Hyperion products. For detailed information about version compatibility please see Document 1355681.1 - Enterprise Performance Management Products Compatibility with Internet Explorer ( IE6, IE7, IE8, IE9, IE10 and IE11). The following Internet Explorer settings should be applied in order for Oracle Hyperion Products to work correctly with Internet Explorer. The information in this document applies to the following Enterprise Performance Management products: Calculation Manager Data Relationship Management (DRM) Enterprise Performance Management Architect (EPMA) EPM Workspace Essbase Administration Services (EAS) Financial Data Quality Management (FDM) Financial Management (HFM) Financial Reporting Foundation Services Interactive Reporting Planning Shared Services Web Analysis SOLUTION 1. Configure browser to check for new version every time user visits a page Open Internet Explorer Go to Tools > Internet options > General            In "Browsing history" section click on "Settings" button and then select "Every time I visit the webpage" option Click OK, then Apply. 2. Disable default pop-up blocking Open Internet Explorer Go to Tools > Internet options > Privacy tab   Uncheck "Turn on Pop-up Blocker" 3. Add Workspace URL to trusted sites Open Internet Explorer Go to Tools > Internet options > Security tab Select "Trusted sites" from "Select a zone to view or change security settings" window, then click on "Sites" button. Type your workspace URL in form http://workspaceserver:portnumber in "Add this website to the zone" Uncheck "Require server verification (https:) for all sites in this zone" Click Add, then Close. Click OK and Apply. 4. Customize security settings Open Internet Explorer Go to Tools > Internet options > Security tab Select "Trusted sites" from "Select a zone to view or change security settings" window  Select zone containing your Oracle Hyperion servers and click on "Custom level..." button In "Miscellaneous" section enable options "Access data sources across domains" and "Allow script-initiated windows without size or position constraints" In "ActiveX controls and plug-ins" section enable "Run ActiveX controls and plug-ins" and "Script ActiveX controls marked safe for scripting". Click OK Click Apply, then OK 5. Enable option "Always allow session cookies". Open Internet Explorer Go to  Tools > Internet options > Privacy Tab > Advanced. Check the "Override automatic cookie handling", accept the first and third party cookies and check the "Always allow session cookies" option. 6. Only for SSL enabled environments: Disable option "Do not save Encrypted Pages to Disk". Open Internet Explorer Go to Tools > Internet options > Advanced Tab. In "Security" section uncheck the option "Do not save Encrypted Pages to Disk". 7. Disable option "Enable Native XMLHTTP". This setting is recommended only for customers using HFM 9.3.1 or older with IE 7. If you are using version 11.1.1.x of EPM products or newer, this option should be enabled. Open Internet Explorer Go to Tools > Internet options > Advanced Tab. In "Security" section uncheck the option "Enable Native XMLHTTP". 8. Using Internet Explorer 9 Compatibility View option. Open Internet Explorer For 11.1.2.1.600 Planning and EPMA: Compatibility View should be enabled in Tools > Compatibility View Settings For EPM 11.1.2.2 products: Go to Tools > Compatibility View Settings. Make sure EPM Workspace URL is not enabled for Compatibility View and uncheck all available options at the bottom of the pop-up window. 9. For products using JRE Plugin (Web Analysis, Performance Scorecard, Administration Services)  make sure that a compatible version of plugin is installed on the client machine. Check JRE Plugin certification for your EPM product in support matrix Check installed Java version in Control Panel > Java > General > About. If required update Java version to a supported release. Enable option "Always Auto-Download" in Control Panel > Java > Advanced > JRE Auto-Download 10. Using Internet Explorer 11 Enterprise Mode - only required with with EPM 11.1.2.2.500 and 11.1.2.3.500. For more information see Document 1920566.1. Open Internet Explorer > Tools Select Enterprise Mode. This option is visible only after enabling it in Windows Registry. See this Microsoft document for more details: http://msdn.microsoft.com/en-us/library/dn640687.aspx 11. For Interactive Reporting Web Client (IRWC) on Windows 7 only: Internet Explorer Protected Mode should be disabled. If login User is not a member of Administrators group, User Account Control should be set to 'Default' option. 12. Financial Data Management (FDM) - Configuration Changes to IIS in Order to Support Internet Explorer 11 - Steps are required to add / edit custom HTTP Response Header. Please refer to Note 2028236.1 for more information.

Smart View Error "The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval" After Installing Internet Explorer 7 or Later (Doc ID 756288.1)

To Bottom

---

APPLIES TO: Hyperion Financial Management - Version 9.3.0.0.00 to 11.1.1.3.00 [Release 9.3 to 11.1] Information in this document applies to any platform. 10.29.15 SYMPTOMS When attempting to connect to Hyperion Financial Management (HFM) using SmartView the following error message appears: The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval. CHANGES The web browser was upgraded to Internet Explorer 7.0 or higher. CAUSE This issue occurs because of a time-out limit introduced during installation of Internet Explorer (IE) 7. By default this is set to 1 minute. In previous IE versions it was 60 minutes. SOLUTION To avoid this error the default time-out value for persistent HTTP connections may be increased. Follow the steps below to change the default time-out value: Click Start, click Run, type regedit and press Enter Locate and select the following key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings  On the Edit menu, point to New and click DWORD Value. Type 'KeepAliveTimeout' and press Enter. On the Edit menu, click Modify. Select Decimal Enter the appropriate time-out value (in milliseconds). For example, to set the time-out value to two minutes, type 120000. For three minutes, 180000. Click OK If you use a KeepAliveTimeout value higher than 120000 (two minutes), you must create an additional registry key and set its value equal to the KeepAliveTimeout value that you want: 9.1. Repeat steps 3-8, creating DWORD value 'ServerInfoTimeout' Restart Internet Explorer.

Studio Dimension Build rejects records with error \\Record #n - (3345) Error setting ID (###@#~MemberName) to member (MemberName) on Essbase Duplicate Dimension (Doc ID 2032860.1)

APPLIES TO:

Hyperion Essbase Studio - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

SYMPTOMS

• Essbase ASO Cube Deployment with Duplicate Member Name support.
• Dimension build records are rejected with below message:
  MEMBER1 MEMBER1, MEMBER2 MEMBER2 MEMBER3 MEMBER3 KEY_ID KEY_ID
  \\Record #11 - (3345) Error setting ID (#~@12#0#304#0@#~@3#0#6867#0@#~MemberName) to member (MemberName)

CAUSE

Reason 1. Caption binding does not work with duplicate member names

As per Studio user guide (page 100 ff) , "Choosing a Key Binding Option for a Dimension Element"

Advanced (binding)
Select this option and then enter an expression in the Key Binding text box
that tells Essbase how to build this member.

Use the Advanced binding option when you know that the Caption Binding contains
duplicate member names and you know how to build the unique member key from the
data source.

Tip:
Use the Advanced binding option when this particular dimension element will
participate in an outline that contains duplicate member names.

 Reason 2: There are scenarios where the member name or alias has special characters causing this issue

SOLUTION

Scenario A: Where Duplicate Member Names are causing the issue:

As e.g MEMBER1, MEMBER2 and MEMBER3 Dimension members may not be unique for HIER1 Hierarchy

Edit the Caption binding of the three dimension members and set the Binding as Advanced Key Binding.

---

In the Key Binding Field, Concatenate a key field KEY_ID in this case, so that it becomes unique.

E.g.
MEMBER1 || KEY_ID
MEMBER2 || KEY_ID
MEMBER3 || KEY_ID

or similar to this example:

Note:

• you can use doublequotes to insert strings (e.g. "_") to separate the fields
• the key field and the caption field must be of the same (database) field type (CHAR or VARCHAR)

---

The dimension build will now work on Duplicate Member Outlines, and the results will be similar to this example:

 Scenario B: Where there are special characters in Member Name or Alias

Ensure to remove those characters from the data source so that the dimension build goes through in Essbase Studio.

7. Feature Differences Between Aggregate and Block Storage

Features	Aggregate Storage	Block Storage
Aliases	Supported	Supported
Currency conversion	Not supported	Supported
Hybrid analysis	Support with the following restriction: queries that contain a relational member and an Essbase member with a formula in the same query are not supported. For example, if California is a relational member, and the member Profit has a formula, the following report script returns an error: Jan California Profit !	Supported
Incremental data load	Supported	Supported
LROs	Not supported	Supported
Time balance reporting	Support with the following restrictions: Skip Zeros is not supported Time dimension must contain only stored hierarchies Shared members must be at level zero	Supported
Triggers	After-update triggers supported	On-update triggers and after-update triggers supported
Unicode	Supported	Supported
Variance reporting	Not supported	Supported
Date-time dimension type and linked attribute dimensions	Supported	Not supported
User ability to change data (write-back)	Transparent partition technique used to enable limited write-back	Fully supported

6. Query Differences Between Aggregate Storage and Block Storage

Query Functionality	Aggregate Storage	Block Storage
Report Writer	Supported, except for commands related to sparsity and density of data	Fully supported
Spreadsheet Add-in	Supported, with limited ability to change data (write-back)	Fully supported
API	Supported	Supported
Export	Support with the following restrictions: Export of level 0 data only (no upper-level export) No columnar export	Supported
MDX queries	Supported	Supported
Queries on attribute members that are associated with non-level 0 members	Returns values for descendants of the non-level 0 member. See also Design Considerations for Attribute Queries.	Returns #MISSING for descendants of the non-level 0 member
Queries on attribute members and shared members	A shared member automatically shares the attribute associations of its nonshared member	A shared member does not share the attribute associations of its nonshared member
Query logging	Not supported	Supported
Query performance	Considerations when querying data from a dimension that has multiple hierarchies. See Query Design Considerations for Aggregate Storage.	Hierarchies not relevant