Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE MEMBER CURRENTCUBE.[Measures].[Test] AS
- [Measures].[Measure1] / ( AXIS( 1 ).ITEM( 0 ).DIMENSION.LEVELS( 0 ).ITEM( 0 ), [Measures].[Measure1] )
- SELECT [Measures].[Measure1] ON 0,
- ORDER( [Dimension1].MEMBERS, [Measures].[Test] ) ON 1
- FROM [MyCube]
- CREATE MEMBER CURRENTCUBE.[Measures].[Test] AS
- [Measures].[Measure1] / ( [Dimension1].[All], [Measures].[Measure1] )
- SELECT [Measures].[Measure1] ON 0,
- ORDER([Dimension1].MEMBERS) ON 1
- FROM [MyCube]
- WHERE ([Measures].[Test])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement