Advertisement
Guest User

Untitled

a guest
May 30th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. Age European | ParameterCaption | ParameterValue | ParameterLevel
  2. -----------------------------------------------------------------
  3. XXX | XXX | XXX | XXX
  4.  
  5. WITH MEMBER [Measures].[ParameterCaption] AS
  6. IIf (
  7. ( [Age At Activity].[Age European].CurrentMember .Member_Caption ) = "1 - 4", "01 - 04",
  8. IIf ([Age At Activity].[Age European].CurrentMember .Member_Caption = "5 - 9", "05 - 09", [Age At Activity].[Age European].CurrentMember .Member_Caption )
  9. )
  10. MEMBER [Measures].[ParameterValue] AS
  11. [Age At Activity].[Age European].CurrentMember.UniqueName
  12. MEMBER [Measures].[ParameterLevel] AS
  13. [Age At Activity].[Age European].CurrentMember .Level .Ordinal
  14. SELECT
  15. { [Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel] } ON COLUMNS,
  16. Order ( [Age At Activity].[Age European].[Age European].Members, [Measures].[ParameterCaption], BASC ) ON ROWS
  17. FROM ReportingPBR
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement