select measure_name, expression from$system.mdschema_measures
where measure_unique_name = '[Measures].[Internet Ratio to Parent Product]'
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