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!

PBCS - Can Intelligent Calculation be useful?

Teresa ModestaJul 3 2018 — edited Jul 4 2018

Hi,

when I first looked into Intelligent Calculation it seemed useful.

Then I saw that you needed to calculate the entire database for blocks to be marked clean, and marked it down as an opportunity lost in my own mind.

Recently I saw in the Essbase documentation; 'SET CLEARUPDATESTATUS' ..... "AFTER - Marks blocks as clean , even if you are calculating a subset of your database"

So now I am thinking that to minimise unnecessary aggregation processing is it worth using SET CLEARUPDATESTATUS AFTER in conjunction with SET UPDATECALC ON in my pure aggregation scripts.

My question then is is the above observation valid, is it worth using the settings I describe in the way that I describe?

This post has been answered by user11440683 on Jul 3 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 1 2018
Added on Jul 3 2018
3 comments
218 views