All Member Formula

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

del.icio.us Tags: MDX,All Member,dimension,SSAS,Analysis Services