Passing Measures as parameters in a Named Set - MDX

861 views Asked by Merin Nakarmi At 31 December 2013 at 21:42

I am using SSAS 2012.

Lets say I have a date dimension [Date].[Calendar Month].[Month].

I have several measures like [Sales], [Purchases], [Commission] etc.

I want to create a Named Set that calculates non-empty months as a Calculated Member in Cube.

For example

NonEmpty(
            [Date].[Calendar Month].[Month], 
            [Measure].[Sales]
         )

calculates non-empty months for [Sales] measure.

Nonempty(
           [Date].[Calendar Month].[Month], 
           [Measure].[Purchases]
         )

calculates non-empty months for [Purchases] measure and so on.

I would like to reuse the Named Set and pass measures like [Sales] and [Purchases] as parameters.

Is it possible?

TechQA.