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

Review your calculated results in Hybrid Cube-enabled 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 differ from those in business processes that do not use Hybrid Cube. The difference occurs because Hybrid Cube-enabled Planning business processes use a configuration that ignores formulae that assign data values using only constants. To resolve this issue for dynamic calc members (where the blocks are created, data is returned to the user, and then the block is discarded), add a @CreateBlock function into the formula on a dense member. Adding @CreateBlock on a dense dimension ensures that blocks are created for all other dense members. Additionally, include an ELSE statement for every IF statement in the formula to ensure that all required blocks are created.

Note: Use @CreateBlock with dynamic calc only. The use of @CreateBlock on a dense dimension simultaneously creates the blocks for all the other dense elements.

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