参数_时间

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]

posted @ 2012-06-20 21:31  chunshen  阅读(148)  评论(0)  编辑  收藏  举报