Essbase discussion board
is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this message
Return to Index
Posted Nov 2, 2011 9:14 AM
Because you are only fixing on the largest sparse dimension.
In Bob's example you are fixing on all the level 0 members of each sparse dimension, and the calculating the dense dimensions.
Then you are releasing a sparse dimension at a time, and calculating that - so effectively you are reducing the calculation requirements.
I would also suggest that you use SET CALCTASKDIMS 3; as well.
I use something similar and it is about 50% more efficient.
You are not logged in
Provides additional benefits such as notifications, signatures, and user authentication.
Also send responses to my email address
RSS feed for this forum -
. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.