Clear Dense DimensionOctober 31 2011 at 2:49 PM
No score for this post
|Raj Bhatta |
from IP address 126.96.36.199
Would you be so kind to tell me the fastest way to clear data from some members in a dense dimension?
I will be forever grateful.
More InfoNo score for this post
|October 31 2011, 2:54 PM |
Just to be more clear:
1. Put dense dimension in FIX and CLEARBLOCK ALL
2. Put dense dimension inside FIX and use CLEARDATA
Gee Raj, we hardly know each other.No score for this post
|November 1 2011, 9:05 AM |
>>I will be forever grateful.
^^^Isn't this all a little sudden? :)
If you put a dense dimension in the fix, you will cause Essbase to cycle through every possible block as restricted by the sparse dimensions in the FIX. Of course, CLEARBLOCK is fast. You will not actually clear the block but just the cells within the block as defined by the FIX.
If you put the dense dimension within the FIX and do a CLEARDATA, you will limit the number of blocks impacted.
Can't you stick the CLEARBLOCK within the sparse FIX?
|Current Topic - Clear Dense Dimension|