Hyperion Essbase Knowledgebase

Essbase create block example

  • Print
User Rating:  / 1
PoorBest 

User wants to inflate FY11 data to FY12, FY13……till FY21 with a fixed percentage. FY12 to FY21 do not have data. The formula is not working.  Why is this not working?  This example assumes that the years dimension is sparse.  If years was dense this block creation would not be an issue.

set updatecalc off;

fix (budget)

           fy12 = fy11 * 1.2;

           fy13= fy11 * 1.2;

           ..

           fy21 = fy11 * 1.2;

 endfix

Issue: There is no data in the out years (fy12 - fy21).  Since there is no data, there are also no blocks.  By default essbase does not create blocks.  There are multiple ways to create blocks.  Blocks are created by:

-loading data

-locking and sending data

-datacopy command

-SET CREATEBLOCKONEQ ON;  -this is a very dangerous performance killing option.  Be sure to test before and after turning this option on.  It can take a script that ran in 2 seconds and make it take 1 hour.  http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/calc/set_createblockoneq.htm

 

In this example, I believe the datacopy is the best solution.  So the script would be modified to the following:

 

set updatecalc off;

fix(budget)

            datacopy fy11 to fy12;

            datacopy fy121to fy12;

            ..

             datacopy fy11 to fy21;

             fy12 = fy11 * 1.2;

             fy13= fy11 * 1.2;

             ..

             fy21 = fy11 * 1.2;

endfix

 

hj