Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Age European | ParameterCaption | ParameterValue | ParameterLevel
- -----------------------------------------------------------------
- XXX | XXX | XXX | XXX
- WITH MEMBER [Measures].[ParameterCaption] AS
- IIf (
- ( [Age At Activity].[Age European].CurrentMember .Member_Caption ) = "1 - 4", "01 - 04",
- IIf ([Age At Activity].[Age European].CurrentMember .Member_Caption = "5 - 9", "05 - 09", [Age At Activity].[Age European].CurrentMember .Member_Caption )
- )
- MEMBER [Measures].[ParameterValue] AS
- [Age At Activity].[Age European].CurrentMember.UniqueName
- MEMBER [Measures].[ParameterLevel] AS
- [Age At Activity].[Age European].CurrentMember .Level .Ordinal
- SELECT
- { [Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel] } ON COLUMNS,
- Order ( [Age At Activity].[Age European].[Age European].Members, [Measures].[ParameterCaption], BASC ) ON ROWS
- FROM ReportingPBR
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement