SET CLEARUPDATESTATUS (Calculation Command):
Specifies when Essbase marks data blocks
as clean. This clean status is used during intelligent calculation.
Question : How dirty blocks are created?
Ans : Dirty blocks are created when we
load partial data for child members .So,parent members become dirty block.
Syntax :
SET
CLEARUPDATESTATUS AFTER | ONLY | OFF;
AFTER
|
Essbase marks calculated data blocks as clean,
even if you are calculating a subset of your database.
|
ONLY
|
Essbase marks the specified data blocks as
clean but does not actually calculate the data blocks. This does the same as
AFTER, but disables calculation.
|
OFF
|
Essbase does not mark the calculated data
blocks as clean. Data blocks are not marked as clean, even on a default calculation
(CALC ALL;) of
your database. The existing clean or dirty status of the calculated data
blocks remains unchanged.
|
Examples:
No comments:
Post a Comment