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

5. Data Load Differences Between Aggregate Storage and Block Storage

Data Load Functionality	Aggregate Storage	Block Storage
Cells loaded through data loads	Only level 0 cells whose values do not depend on formulas in the outline are loaded	Cells at all levels can be loaded (except Dynamic Calc members)
Update of database values	At the end of a data load, if an aggregation exists, the values in the aggregation are recalculated	No automatic update of values. To update data values, you must execute all necessary calculation scripts.
Data load buffers	The loading of multiple data sources into aggregate storage databases is managed through temporary data load buffers	Not supported
Atomic replacement of the contents of a database	When loading data into an aggregate storage database, you can replace the contents of the database or the contents of all incremental data slices in the database	Not supported
Data slices	Aggregate storage databases can contain multiple slices of data. Data slices can be merged	Not supported
Dimension build for shared members	Full support for parent-child build method. Duplicate generation (DUPGEN) build method limited to building alternate hierarchies up to generation 2 (DUPGEN2).	Support for all build methods
Loading data mapped to dates	In a date-time dimension, you can load data into level 0 members using supported date-format strings instead of member names	Date-time dimension type is not supported

4. Partitioning Differences Between Aggregate Storage and Block Storage

Partitioning Functionality	Aggregate Storage	Block Storage
Partitioning	Support with the following restrictions: No outline synchronization	Fully supported

3. Calculation Differences Between Aggregate Storage and Block Storage

Calculation Functionality	Aggregate Storage	Block Storage
Database calculation	Aggregation of the database, which can be predefined by defining aggregate views	Calculation script or outline consolidation
Formulas	Allowed with the following restrictions: Must be valid numeric value expressions written in MDX; cannot contain the % operator—replace with expression: (value1 / value2) * 100 No support for Essbase calculation functions On dynamic hierarchy members, formulas are allowed without further restrictions	Support for Essbase calculation functions
Calculation scripts	Not supported	Supported
Attribute calculations dimension	Support for Sum	Support for Sum, Count, Min, Max, and Average
Calculation order	Member formula calculation order can be defined by the user using the solve order member property	Defined by the user in the outline consolidation order or in a calculation script

2. Outline Differences Between Aggregate Storage and Block Storage

Outline Functionality	Aggregate Storage	Block Storage
Dense or sparse dimension designation	Not relevant	Relevant
Multiple hierarchies enabled, dynamic hierarchy, or stored hierarchy designation	Relevant	Irrelevant
Accounts dimensions and members on dynamic hierarchies	Support with the following exceptions: No two-pass calculation (however, for information on specifying the calculation order, seeCalculation Order) No association of attribute dimensions with the dimension tagged Accounts Additional restrictions for shared members. See Alternate Hierarchies.	Full support
Members on stored hierarchies	Support with the following exceptions: Support for the ~ (no consolidation) operator (underneath label-only members only) and the + (addition) operator Cannot have formulas Restrictions on label only members (See Member storage types.) No Dynamic Time Series members Stored hierarchy dimensions cannot have shared members. Stored hierarchies within a multiple hierarchies dimension can have shared members. See Stored Hierarchies.	Full support
Member storage types	Support with the following exceptions: Dynamic Calc and Store not relevant On stored hierarchies, two limitations if a member is label only: All dimension members at the same level as the member must be label only The parents of the member must be label only. Note: On dynamic hierarchies, ability to tag any member as label only Note: On conversion from a block storage database, attribute dimension members are tagged as Dynamic Calc. On standard dimension members Dynamic Calc tags are converted and tagged as stored members, which changes the Members Stored value on the Dimensions tab of the Database Properties window in Administration Services.	Support for all member storage types in all types of dimensions except attribute dimensions
Ragged hierarchies and hierarchies with more than 10 levels	Support, with possible performance impact	Support
Outline validation	When database is started When outline is saved When block storage outline is converted to aggregate storage outline When user requests	When outline is saved When user requests
Outline paging	Support	No support
Database restructure	Levels of restructure; see Aggregate Storage Database Restructuring	Levels of restructure; seeOptimizing Database Restructuring

1. Inherent Differences Between Aggregate Storage and Block Storage

Inherent Differences	Aggregate Storage	Block Storage
Storage kernel	Architecture that supports rapid aggregation, optimized to support high dimensionality and sparse data	Multiple blocks defined by dense and sparse dimensions and their members, optimized for financial applications
Physical storage definition	Through the Application Properties window, Tablespaces tab in Administration Services	Through the Database Properties window, Storage tab in Administration Services
Create database	Migrate a block storage outline or define after application creation Note: Do not use the file system to copy a block storage outline into an aggregate storage application. Use the migration wizard in Administration Services to migrate the outline.	Define after application creation
Copy database	Not supported	Supported
Databases supported per application	One	Several (one recommended)
Application and database names	See Naming Restrictions for Applications and Databases. Names reserved for tablespaces, cannot be used as application or database names: default log metadata temp	See Naming Restrictions for Applications and Databases.
Application and database information display	Displayed in the Application Properties window and the Database Properties window in Administration Services. Information not supported by or relevant to aggregate storage applications is not shown. For a description of aggregate storage-specific information, see the Oracle Essbase Administration Services Online Help for the Application Properties window and Database Properties window.	Displayed in the Application Properties window and the Database Properties window in Administration Services
Configuration settings (essbase.cfg)	For a list of the settings that apply to aggregate storage databases, see the Oracle Essbase Technical Reference.	For a list of the settings that do not apply to block storage databases, see the Oracle Essbase Technical Reference.

Recommended Settings for Oracle Hyperion Products

Problem

Oracle has recommended settings for Internet Explorer (IE7, IE8, IE9, IE10 and IE11) when using Hyperion products.  I get this question a lot from my clients, so I thought I would share Oracles suggested settings.  Without changing these, there will be intermittent problems, and frustration points.

Solution

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.

Disable default pop-up blocking

• Open Internet Explorer
• Go to Tools > Internet options > Privacy tab
• Uncheck "Turn on Pop-up Blocker"

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.

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

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.

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".

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".

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.

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=

Using Internet Explorer 11 Enterprise Mode. Limited support with EPM 11.1.2.2.500 and 11.1.2.3.500. For more information see Document 1920566.1.

Linux - How to execute *.sh

This is a very simple tutorial which shows you how to execute .sh files step by step:

1)First of all, download the file that you are going to execute e.g. "name_of_file.sh" and save it in your Desktop

2)Secondly open the Terminal from Menu  Accessories  Terminal

3)Now type cd ~/Desktop (With this command we change the default directory "/" to "/Desktop")

4)Then type chmod +x name_of_file.sh to make your file executable.

5)Then type sh ./name_of_file.sh to execute the file.

6)After that continue as usual.