参数_门店
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]