Impact of Enabling Hybrid Cubes on Calculations and Member Formula in Planning

Review your calculated results in Hybrid Cube-enabled Oracle Hyperion Planning business processes if you are using constants, and not data values from other members (for example, for Feb, Days in month = 28), to assign values in calculations.

Calculation results in Hybrid Cube-enabled Planning business processes may be different from the results observed in business processes that are not Hybrid Cube-enabled. The difference in calculation results may be attributed to the fact that Hybrid Cube-enabled Planning business processes use a configuration that ignores any formula that is based only on constants to assign a data value. To resolve this issue, add a @CreateBlock into the formula on a dense element of the formula. When the @CreateBlock is on a dense dimension, this addition creates the blocks for all the other dense elements at the same time. Also, use the ELSE statement for every IF statement to ensure that all required blocks have been created.

For information on the user of Oracle Essbase in Oracle Enterprise Performance Management Cloud, see About Essbase in EPM Cloud in Oracle Enterprise Performance Management Cloud Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.