is there a way to set level-0 blocks clean in essbase without performing any level-0 calcs? SET CLEA
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.