参数_门店

WITH

MEMBER [Measures].[ParameterCaption] AS [D_Store].[门店].CURRENTMEMBER.MEMBER_CAPTION

MEMBER [Measures].[ParameterValue] AS [D_Store].[门店].CURRENTMEMBER.UNIQUENAME

MEMBER [Measures].[ParameterLevel] AS [D_Store].[门店].CURRENTMEMBER.LEVEL.ORDINAL

SELECT
   {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS
, [D_Store].[门店].children ON ROWS

FROM [chunshen]

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