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