3

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?

yizzlez
  • 8,757
  • 4
  • 29
  • 44
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
  • Not sure what you are doing with your MDX, but if it is going into Reporting Services, this might be helpful: http://blog.gbrueckl.at/2014/01/reporting-services-mdx-field-list-and-using-measures-on-rows/ – mmarie Jan 04 '14 at 16:27
  • Hey mmarie! Thanks for your input. I am required to create multitude of such kind of Named Sets with which I will create other Calculated Members and will later use in Performance Point Dashboard (SharePoint 2013) to create KPIs and Score Cards. – Merin Nakarmi Jan 05 '14 at 03:27
  • 1
    Add a PerformancePoint tag to your question. There are some clever people subscribing to that tag that might be able to help. – Ola Ekdahl Jan 05 '14 at 03:36
  • I do not understand your requirement in detail, but maybe creating a dynamic set and omitting the measure altogether from the definition would work? You would then alter provide the measure to use as a context to this set. – FrankPl Jan 07 '14 at 11:07

0 Answers0