Tuesday 15 May 2012

Know Your Calculated Measure Definition Using MDX Query

select measure_name, expression from$system.mdschema_measures
where measure_unique_name = '[Measures].[Internet Ratio to Parent Product]'






Definition used for calculated Measure [Measures].[Internet Ratio to Parent Product]

 Case    When [Product].[Product Model Categories].CurrentMember.Level.Ordinal   = 0 Then 1          Else
[Measures].[Internet Sales Amount]    /    [Product].[Product Model Categories].CurrentMember.Parent,                [Measures].[Internet Sales Amount] )      End 

No comments:

Post a Comment