参数_时间

WITH
MEMBER [Measures].[ParameterCaption]   AS [Time].[YM].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue]     AS [Time].[YM].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel]     AS [Time].[YM].CURRENTMEMBER.LEVEL.ORDINAL
MEMBER [Measures].[T]                  AS strtovalue([Time].[YM].CURRENTMEMBER.name)

SELECT
  {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel],T} ON COLUMNS
, order(filter([Time].[YM].MEMBERS,[Time].[YM].CURRENTMEMBER.name<>"ALL"),T,desc) ON ROWS
FROM [chunshen]

原文地址:https://www.cnblogs.com/chunshen/p/2557004.html