Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with member Measures.Test as Measures.Actual / 100000000
- SELECT
- NON EMPTY {Hierarchize({[Department].[Department].Members})} ON COLUMNS,
- NON EMPTY {Hierarchize({[Region].[Region].Members})} ON ROWS
- FROM [Quadrant Analysis]
- WHERE {Hierarchize({[Measures].[Test]})}
Add Comment
Please, Sign In to add comment