2 Replies Latest reply: Nov 9, 2012 9:58 AM by hyperion start RSS

    CLEARDATA

    hyperion start
      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_
          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
            Thank you very much.
            It worked.