Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. SELECT NON EMPTY {[Measures].[contributors.COUNT], [Measures].[Calculation.TRSYNC], [Measures].[Calculation.TRSIZE], [Measures].[Calculation.CPSYNC], [Measures].[Calculation.CPSIZE], [Measures].[Calculation.SYNC], [Measures].[Calculation.SKIP], [Measures].[Calculation.SIZE], [Measures].[Calculation.PCT], [Measures].[Calculation.STATUS], [Measures].[Calculation.TIME] } ON COLUMNS, NON EMPTY CrossJoin(Hierarchize([Markets].[Calculation Sets].[Calculation Set].Members ), Hierarchize([Markets].[Market Names].[Market Name].Members ), Hierarchize([Markets].[Valuation Dates].[Valuation Date].Members ), Hierarchize([Results].[Result Scenarios].[Scenario Group].Members ), Hierarchize([Results].[Result Types].[Record Type].Members ) ) ON ROWS FROM [Risk Cube]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement