Interaction between MDX Subselect and Calculation

As Mosha Pasumansky has described in his blog AS2008MDX: subselects and CREATE SUBCUBE in non-visual mode, an MDX subselect performs two functions:

• Limits each axis set through dimension autoexists.
• Applies visualtotals to cell values if there are no coordinate overwrites.
Read more...