This discussion is archived
2 Replies Latest reply: May 24, 2010 3:21 AM by CL RSS

Remove Blocks from Essbase databse

user4958421 Explorer
Currently Being Moderated
Hello all-

If in my database i have few blocks that have all 0 in & not #missing, Is there a way to identify & remove those blocks from databse ?

Thanks!
  • 1. Re: Remove Blocks from Essbase databse
    _RahulS_ Guru
    Currently Being Moderated
    Hi Thr,

    There is a nice technique which is used to convert 0 to #Missing.
    If we have many blocks in the cube which are 0 and we want to convert them into #missing so that we can use Clear Empty block to remove unnecessary blocks.

    member = member * member / member;

    it will make 0 #missing;

    then clear empty block.

    Cheers...!!!
  • 2. Re: Remove Blocks from Essbase databse
    CL Oracle ACE Director
    Currently Being Moderated
    I remember reading Edward Roske's post on this a while back: http://www.network54.com/Forum/58296/thread/1209018907/Replace+0+with+%23missing+Calc+Script

    Interestingly, you will note that multiply and divide process was slower than an IF test. Every database is different, and benchmarking is a really, really good idea.

    Regards,

    Cameron Lackpour

Legend

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