Hyperion Essbase (MOSC)

MOSC Banner

is there a way to set level-0 blocks clean in essbase without performing any level-0 calcs? SET CLEA

edited Oct 30, 2014 10:02AM in Hyperion Essbase (MOSC) 3 commentsAnswered

Our calculation (aggregation) does not perform any level-0 calcs. We load level-0 daily to a sparse time dimension and delete all of these blocks before loading. A perfect candidate for intelligent calc. The dbag is confusing about level-0 blocks and intelligent calc, but the tech ref has the following example"

SET CLEARUPDATESTATUS ONLY;

CALC ALL;

Essbase searches for all dirty blocks in the databaes and marks them as clean. It does not calculate the blocks, even though a CALC ALL; command is used.

However, after running this example on my level-0 load, the blocks are still empty because Essbase computes upper blocks when I run a calc all; after turning on intelligent calc.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center