Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Agg only Dirty Blocks?

KrishnanV2014Apr 21 2016 — edited Apr 27 2016

Hello,

Is there a way to Agg parents of only dirty blocks?

Requirement: I have a replicated partition to another BSO and want to agg only changed level 0 data. I thought intelligent calc will help. But no go.

SET UPDATECALC ON;

SET CLEARUPDATESTATUS AFTER;

SET AGGMISSG ON;

Set lockblock high;

SET CACHE HIGH;

SET EMPTYMEMBERSETS ON;

SET FRMLRTDYNAMIC OFF;

/*========================Aggregate cube to start============================================*/

FIX ( "YR", "SCENARIO","USD")

    CALC DIM ( "Sparese1", "Sparse2", "Sparse3", "Sparse4");

ENDFIX

Regards,

Krishnan

This post has been answered by USER1211 on Apr 25 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2016
Added on Apr 21 2016
21 comments
3,443 views