Can any one help me to understand the exact difference between CalcDIM and CalcAll

here my concern is if we are calculating a dimension then all dimensions and all combinations should be calculated because we refer data in Essbase member combination off all dimensions(data point) not by a single dimension.

thanks in advance !!

Sameer,

You really owe it to yourself to read the Database Administrator's Guide (DBAG):

http://docs.oracle.com/cd/E57185_01/EDB ... cadevcs_32

Short answer: CALC DIM calculates but one dimension, CALC ALL does the entire database.

Fwiw, CALC DIM is only required for dense dimensions although it will work for spare ones. If the latter, AGG (dimname) ; is usually faster. If you are calculating a dense dimension, consider making all calculations dynamic.

Regards,

Cameron Lackpour

P.S. Take a look at interrel's series on Essbase books as well. You might check out my books as well. The first one has a great chapter on BSO by Dave Farnsworth.