an MDX question RRS feed

  • Question

  • What's the meaning of the following calculated measure?

    ([Product].[Model Name].[Model Name].members,[Measures].[Test])=[Measures].[Sales Amount]

    The hierarchy is [product name]  -->[model name]--> [product line]

    say we have product A1,A2,A3,A4, all with the same model name A.

    Does it say, if we slice the [product name] to browse measures.test, then it will automatically slice the [model name],  so if we slice the product name A1, then the [Measures].[Test] will be the result of summary (roll up) all the [Sales Amount] whose product names are A1,A2,A3,A4? I didn't a test, looks not that case. But then what's the meaning of it?





    Saturday, August 27, 2011 6:58 AM


All replies

  • Hi Daniel,

    The statement is very similar to a scope.  In the cube calcualtion space there are a couple of ways to replace the value of measures.  This is one of them.

    All the statement is saying is when the members of that hierarchy are shown with the measure [test], the [sale amount] will be shown.



    Saturday, August 27, 2011 7:42 AM
  • Thanks Paul,


    The MDX is defined at [Model Name] level, if we query at [Model Name] level or above, the values is exactly the same as [Measures].[Sales Amount]. 

    But what if we query at a level below [Model Name] level, such as [product name] level.  It shows something, but not the same as [Measures].[Sales Amount].



    Saturday, August 27, 2011 7:49 AM
  • Yeah, Its probaly stated somewhere or perhaps even a materialised measure.

    The statement only applies for the defined tuple.



    Saturday, August 27, 2011 7:54 AM