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 ;

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
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
24
25
26
27
28
29
30
   
       
Today