Followers

Friday, July 5, 2013

Shared services Recovery in Hyperion 11.1.1.3 version

Shared services Recovery in Hyperion 11.1.1.3 version

Hyperion Foundation OpenLDAP Service is not stated as shown below:











Hyperion Foundation Shared services – web Application is not started as shown below:












Go to this path as shown below:

























Execute the following command to get back the shared services up and running

D:\Hyperion\products\Foundation\openLDAP\bdb\bin>db_recover -v -h D:\Hyperion\products\Foundation\openLDAP\var\openldap-data













Now, Start Foundation services, it will starts without any error messages.




Thanks,
mady

Monday, July 1, 2013

How to Connect to the Smart View from Excel Sheet in Hyperion 11.1.2.2 version

How to Connect to the Smart View from Excel Sheet:
Install Smart view using Hyperion workspace. In the workspace, Tools à Install à SmartView
Open Excel Worksheet:



















Xxxxxxxxx: Server name

In the next popup window, it will ask for username and password to connect to the server.




























Double click on the forms



Thanks,
mady

Wednesday, June 19, 2013

Internet Explorer (IE7, IE8 and IE9) Recommended Settings for Oracle HyperionProducts

Internet Explorer (IE7, IE8 and IE9)

Recommended Settings for Oracle HyperionProducts
Applies to:
Hyperion BI+ - Version 9.3.0.0.00 to 11.1.2.2.300 [Release 9.3 to 11.1]
Hyperion Planning - Version 9.3.1.0.00 to 11.1.2.2.300 [Release 9.3 to 11.1]
Hyperion Essbase Administration Services - Version 9.3.0.0.00 to 11.1.2.2.000

[Release 9.3 to 11.1]
Hyperion Financial Management - Version 9.2.1.0.00 to 11.1.2.2.302

[Release 9.2 to 11.1]
Hyperion Financial Data Quality Management - Version 9.2.0.0.00 to 11.1.2.2.300 [Release 9.2 to 11.1]
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 and IE9).


The following Internet Explorer settings should be applied in order for Oracle Hyperion Products to work correctly with Internet Explorer 7 (IE 7), Internet Explorer 8 (IE 8) or Internet Explorer 9 (IE9).

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. Minimize security setting for 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
Select custom level
From "Reset to:" list select "Low"
Click OK
Click Apply, then OK


5. Customize security settings
Open Internet Explorer
Go to Tools > Internet options > Security Tab
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".


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


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


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


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

Note: IE10 is currently not supported with any Oracle EPM products


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


Cheers,
Mady
https://www.facebook.com/hyperioninstallations

Wednesday, June 5, 2013

Getting a Blank Page When Accessing Shared Services and Workspace via FireFox 8,9,10. [ID 1467507.1]

Getting a Blank Page When Accessing Shared Services and Workspace via FireFox 8,9,10. [ID 1467507.1]


Applies to:

Hyperion BI+ - Version 11.1.2.2.000 to 11.1.2.2.000 [Release 11.1]
Information in this document applies to any platform.

Symptoms
When accessing EPM Workspace or Shared Services in Mozilla FireFox 8,9,10 it brings up a blank page.

There are no errors, just a blank screen comes up with "done" message in the FireFox status bar in the bottom left corner.

Cause:

Remote XUL Manager Add-on is required for Logon screen to be accessed in Firefox 8,9 and 10 version.

This is documented in the Certification Matrix.

Solution

Follow these steps:
1. Install Remote XUL Manager 1.0.1 Add-on, available at https://addons.mozilla.org/en-US/firefox/addon/remote-xul-manager/

2. In Mozilla FireFox Tools Menu, go to Web Developer -> Remote XUL Manager and add the EPM web server name.

3. Restart FireFox.


Thanks,
mady
https://www.facebook.com/hyperioninstallations