Friday May 17, 2013

EPM 11.1.2.2: How-to Setup Essbase Clustering on Unix

The steps on how to setup Essbase clustering on the 11.1.2.2 release has changed as compared to the previous releases.  This document goes through how to setup Essbase clustering on Unix on the EPM 11.1.2.2 release.  The information provided in this document has been taken from the EPM 11.1.2.2 Installation and Configuration Guide, which can be found here @ http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf

> Download the Essbase clustering on the 11.1.2.2 release step by step document

 


 

Friday Nov 30, 2012

Using Transaction Logging to Recover Post-Archived Essbase data

Data recovery is typically performed by restoring data from an archive.  Data added or removed since the last archive took place can also be recovered by enabling transaction logging in Essbase.  Transaction logging works by writing transactions to a log store.

[Read More]

Friday Jul 13, 2012

Oracle Hyperion Financial Management (HFM) Configurable Dimensions FAQ

What is Configurable Dimensions?

Configurable Dimension allows the HFM administrator to set the number of custom dimensions in the application. For each dimension it is possible to set the size of the dimension and give a short name and a long name (alias).

[Read More]

Wednesday May 23, 2012

EPM 11.1.2.2 - HFM Rules Editor no longer exists in HFM 11.1.2.2

 With the release of HFM 11.1.2.2.000, the Rules Editor is no longer available.  Per the readme file (http://docs.oracle.com/cd/E17236_01/epm.1112/hfm_1112200_readme.pdf), you will need to download and install Notepad++, which is a free product.

[Read More]

EPM 11.1.2 - EAS Jobs Taking Longer than 5 Minutes Launch Multiple Essbase Sessions

If a job initiated from EAS takes longer than 5 minutes, a new Essbase connection and a new Essbase session will be launched before the first session has completed.  An Essbase connection and a new session will be launched at 5 minute intervals while the job is running in Essbase, creating multiple sessions per job and unnecessarily creating a heavier load on the Essbase agent.

[Read More]

Tuesday May 01, 2012

EPM 11.1.2.2 - Hyperion Business Rules de-supported in this release

Please note that Hyperion Business Rules (HBR) is no longer supported with the 11.1.2.2 release. You will need to migrate Business Rules to Calc Manager in 11.1.2.2. The statement of direction for HBR can be found here - Hyperion Business Rules Statement of Direction (Support Doc ID 1448421.1) - https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1448421.1

The steps for migrating from Business Rules to Calc Manager can be found here (see pages 22-23 regarding the steps needed to be taken depending on your installation type - http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf


Wednesday Mar 07, 2012

EPM 11.1.2 - Service unavailable errors using EPM System

Users experience intermittent Service Unavailable errors using different components of the Oracle EPM System. A blank page with the following error message shows up:

                The service is unavailable.

Reviewing the application specific log files and testing the WebLogic application servers in the back end does not show any issues. As the client can still connect to the web server and the Java Application Server is working fine in the back end, it is clear that there is some issue in between web and application server. To track this down, logging for the WebLogic web server plug-in needs to be enabled. Setting up logging depends on the web server, so we need to distinguish between Internet Information Services (IIS) and Oracle HTTP Server (OHS).

[Read More]

Tuesday Mar 06, 2012

EPM 11.1.2 - VBScript error using HFM in a load balanced environment

Financial Management is installed in an environment using two or more web servers and a load balancer is used to distribute user request across the web servers. The following errors occur in the web client:

Microsoft VBScript runtime error '800a01a8'
Object required
/hfm/data/webformgenerated.asp, line 48

Error number:424
Error description: Object required
Error source: Microsoft VBScript runtime error
Page On which Error Occured: /hfm/DocMgr/OpenItem.asp

Make sure IIS logging is configured to log include "Cookies". You can check this as follows:

[Read More]

EPM 9.3.3 - Cannot log in to Financial Reporting Studio 9.3.3

The following error occurs in Financial Reporting Studio after entering user credentials and server name into login dialog, also the Financial Reporting Studio does not connect to the Financial Reporting Server at all:

You are not authorized to use this functionality. Contact your administrator.

Financial Reporting Studio log file (HYPERION_HOME\logs\BIPlus\FRClient.log) does not exist.

[Read More]

Wednesday Feb 22, 2012

EPM 11.1.2 - Setting the Dynamic Calc property in Planning when using ERPI

The current release of ERPI has a limitation when dimension hierarchies are pulled in from Oracle EBS.  This limitation hard codes the storage property as a stored member and prevents defining the storage property as dynamic calc.  Planning applications typically set the Account and Period dimensions as dense, and parent members are typically set as dynamic calc members to reduce the block size and improve overall performance.  Therefore, it is typically best practice to set all upper level dense members as dynamic calc.

Beginning with the 11.1.2.2 release, ERPI will be enhanced to allow member storage properties to be user defined.  For earlier releases, a workaround is available to prevent ERPI from setting member storage properties and use Planning to maintain the member storage properties instead.  The following is the trigger code for ERPI to enable this workaround:

CREATE OR REPLACE TRIGGER AIF_HS_DIM_HIER_PROP_INS

BEFORE INSERT ON AIF_HS_DIM_HIERARCHY FOR EACH ROW BEGIN

     :NEW.DATASTORAGE := NULL ;

END AIF_HS_DIM_HIER_PROP_INS ;

 

CREATE OR REPLACE TRIGGER AIF_HS_DIM_HIER_PROP_UPD

BEFORE UPDATE ON AIF_HS_DIM_HIERARCHY FOR EACH ROW BEGIN

     :NEW.DATASTORAGE := NULL ;

END AIF_HS_DIM_HIER_PROP_UPD ;

Monday Feb 20, 2012

OBIEE 11.1.1 - How to turn off EM centralized control

There is a flag in the central config file which can be used to turn off all of the EM central configuration. It is in user_projects\domains\bifoundation_domain\config\fmwconfig\biee-domain.xml. The flag is near the top; it says: centralConfigurationEnabled="true" . If you change this to "false", then none of the config files will be modified centrally.

(You will need to restart the managed server and BI System Components)

Important Note: Turning off EM centralized control for managing BI config files is NOT recommended.


Thursday Dec 22, 2011

EPM 11.1.2: How to setup JRockit Flight Recorder for EPM web components

Below is the example on how to setup JVM profiling for Hyperion Planning managed server in Windows Server:

1. In HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Planning0\HyS9Planning,  add and update following registry keys:
  •   update > JVMOption51 -XX:+FlightRecorder
  •   create >  JVMOption59 -Xmanagement:port=8888,ssl=false,authenticate=false
  •   update > JVMOptionCount  60

2. Restart Hyperion Planning service.

3. Start Jrockit Mission Control, goto \Oracle\Middleware\jrockit_160_20\bin and then type in JRMC in command prompt.

4. Add localhost:8888 as per following screenshot and Start Flight Recording…:



Tuesday Dec 13, 2011

EPM 11.1.2 - Optimize Workspace Server Settings

Disable products which are installed but not running. A dialog box is displayed with products that can be deselected. If the checks are cleared, the products are de-integrated at the next logon, as if they were never installed.

 

[Read More]

Wednesday Nov 30, 2011

EPM 11.1.2 - R&A DATABASE CONNECTIONS DISAPPEAR FROM THE "DATABASE CONNECTION MANAGER

When accessing the database connection panel through Reporting and Analysis all previously entered database connection do not appear.

[Read More]

Thursday Oct 20, 2011

EPM 11.1.2 - SSL Offloading flavors

While EPM documentation clearly lists the different SSL flavors available in 11.1.2.1 (http://download.oracle.com/docs/cd/E17236_01/epm.1112/epm_security_11121.pdf - termination at web server, ssl offloading, full ssl, 2 way ssl...), it requires additional information to adapt further depending on your environment.

Three main elements to know about:

  • Some EPM pages generate HTTPS links in their web pages based on request scheme. An http request will generate an http link, and an https request will generate an https link. This is the standard behavior of the request.getScheme servlet api method. The solution to let Weblogic know it has to use HTTPS in link is through a header named WL-Proxy-SSL true or false. This header has to be set by layers fronting Weblogic.
  • The Weblogic plugin (in Oracle Http Server, or IIS) has 2 parameters to add or propagate this header: WLProxySSL and WLProxyPassThrough  http://download.oracle.com/docs/cd/E21764_01/web.1111/e14395/toc.htm and http://download.oracle.com/docs/cd/E21764_01/web.1111/e14395/plugin_params.htm#WLPLG475)

quoting from above url: When WLProxySSL is set to ON, the location header returned to the client from WebLogic Server specifies the HTTPS protocol.

If you have a chained proxy setup, where a proxy plug-in or HttpClusterServlet is running behind some other proxy or load balancer, you must explicitly enable the WLProxyPassThrough parameter. Enabling this parameter allows the plug-in to trust the proxy fronting it, under the assumption that the network between them is trusted so user certs and so forth can be passed along.

This also means the WL-Proxy-SSL header amongst other headers are not going to be removed by the weblogic plugin when it receives headers from SSL Offloader.

About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today