Explanation/Reference:
Differences bettewen CALC DIM and AGG.
CALC DIM (Product);
This line calculates the Product dimension doing both outline aggregation (such as rolling all the Colas up into the parent value) and member formulas (C), if they exist for members in that dimension. If we want to calculate multiple dimensions using this command (say, Market and Product), just separate them with commas:
CALC DIM (Market, Product);
Remember how we said that "CALC DIM" not only does aggregation but also member formulas? Well, how many member formulas are there in the Market and Product dimensions?
That's right: none, so "CALC DIM" is wasting time looking for formulas that you know aren't there. For sparse dimensions that don't have formulas, there's a command that only does aggregation and as such, is usually faster:
AGG (Market, Product) (B, F)
Note: The CALC DIM command calculates the formulas and aggregations associated with each member of all the specified dimensions. This command calculates the formulas and aggregations associated with each member of all of the specified dimensions. The order in which dimensions are calculated depends on whether they are dense (G) or sparse (E). All of the dense dimensions are calculated first, in the order that the dense dimensions appear in dimList. The sparse dimensions are then calculated in a similar order.
Incorrect answers:
H: Analytic Services cannot use the AGG command with dense dimensions.