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!

ASO clear trouble

DzefFeb 20 2019 — edited Feb 20 2019

Hi

In PBCS, I have to clear some data from an ASO cube before running a Data Management load.

As a business rule, where I set the values to 0 (ie. Month = Month-Month), there seems to be a tipping point in terms of the POV submitted before it just hangs.  If I scale back the POV, it runs very quickly. 

I've also tried a partial clear using the Clear Cube funcationality, but that gives me the error Clear Data job failed to complete due to -  Dynamic members are not allowed in data clear region specification.  This is despite me checking and cant see any dynamic calc members in the specified POV.

Cheers

Comments