This discussion is archived
2 Replies Latest reply: Nov 9, 2012 7:58 AM by hyperion start RSS

CLEARDATA

hyperion start Newbie
Currently Being Moderated
Gurus,
I have to clear data from members in Essbase.
This is the structure
ACCOUNT
BUILDINGS
I01
I0101
I0102
102
I03
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.
I tried:
FIX(Versionname, year)
CLEARDATA BUILDINGS;
ENDFIX

But it did not work.

Is there something wrong I am doing, do i need to use some @descendants,, etc.
  • 1. Re: CLEARDATA
    _RahulS_ Guru
    Currently Being Moderated
    I believe "Buildings" is sparse, if that is the case why not use clearblock:

    http://docs.oracle.com/cd/E17236_01/epm.1112/esb_tech_ref/clearblock.html

    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.

    Cheers..!!
    Rahul S.

    Edited by: RahulS on Nov 9, 2012 8:54 PM
  • 2. Re: CLEARDATA
    hyperion start Newbie
    Currently Being Moderated
    Thank you very much.
    It worked.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points