Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. CREATE MEMBER CURRENTCUBE.[Measures].[Test] AS
  2. [Measures].[Measure1] / ( AXIS( 1 ).ITEM( 0 ).DIMENSION.LEVELS( 0 ).ITEM( 0 ), [Measures].[Measure1] )
  3.  
  4. SELECT [Measures].[Measure1] ON 0,
  5. ORDER( [Dimension1].MEMBERS, [Measures].[Test] ) ON 1
  6. FROM [MyCube]
  7.  
  8. CREATE MEMBER CURRENTCUBE.[Measures].[Test] AS
  9. [Measures].[Measure1] / ( [Dimension1].[All], [Measures].[Measure1] )
  10.  
  11. SELECT [Measures].[Measure1] ON 0,
  12. ORDER([Dimension1].MEMBERS) ON 1
  13. FROM [MyCube]
  14. WHERE ([Measures].[Test])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement