I have to clear data from members in Essbase.
This is the structure
I have to cleardata from the lowest level I0101, I0102, etc, and there are a lot of members in the bottom level.
How do I delete them.
But it did not work.
Is there something wrong I am doing, do i need to use some @descendants,, etc.
I believe "Buildings" is sparse, if that is the case why not use clearblock:
Use clearblock in a FIX for which you want to clear data and remember If CLEARBLOCK is used within a FIX command on a dense dimension, the FIX statement is ignored and all blocks are scanned for missing cells.
Edited by: RahulS on Nov 9, 2012 8:54 PM