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!

Essbase Clearblock clear date in child member

Hector AndradeApr 25 2025

Hi Community,

I have a BSO Cube where I have a Entities Dimension where there are some parents with only one child, when we want to delete consolidated members and only leave the Level 0 Data, we use something like :

FIX (Entity10, Entity20, Entity30)

CLEARBLOCK ALL;

ENFIX

But the thing is that when we check the parent with only one Level0 Member, also delete the Level0 Member Data, is there a way to tell Essbase only to delete the parent data and not the Level0 Member Data?

Thanks,

Hector Andrade

Comments
Post Details
Added on Apr 25 2025
0 comments
106 views