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.
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.