Dimensions in Analysis Services 2000 have property that defines value of All member:
All Member Formula = [Reporting Period].[All reporting Period].FirstChild
To convert it to Analysis Services 2005 or Analysis Services 2008 you will need to set it as calculation on cube designer:
CALCULATE;
[Reporting Period].[Reporting Period].[All Reporting Period] = [Reporting Period].[Reporting Period].[All Reporting Period].FirstChild
Simply put the name of the dimension in the select statement:
select [Product Completion Date] on 0
from [SBCD New Business]
You will get a result set with default member of the dimension and default measure.
If you get an error like the following back from SSAS server:
Either the user, DEV\Smith, does not have permission to access the referenced mining model, ABCD New Business, or the object does not exist.
This occurs when you omit to specify axis of your MDX query:
select [Product Completion Date] - -on 0
from [SBCD New Business]
