WITH
SET [e16a30d0-2174-4874-8dae-a5085a75a3e2] as NONEMPTY({[Measures].[终端销售数量], [Measures].[终端销售吊牌额]})
SET [d1876d2b-e50e-4547-85fe-5b8ed9d629de] as NONEMPTY( VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[出方渠道ID] })}}) ),{[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) MEMBER [Measures].[3d268ce0-664d-4092-b9cb-fece97175006] AS Count([e16a30d0-2174-4874-8dae-a5085a75a3e2])
MEMBER [Measures].[8d7fe8c1-f09f-410e-b9ba-eaab75a1fc3e] AS Count ([d1876d2b-e50e-4547-85fe-5b8ed9d629de])
SELECT { [Measures].[3d268ce0-664d-4092-b9cb-fece97175006] , [Measures].[8d7fe8c1-f09f-410e-b9ba-eaab75a1fc3e] } ON AXIS(0)
FROM [RegentCube]
WITH
SET [a69e818b-1183-4635-af2a-08199b74b905] as SUBSET({ NONEMPTY({[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) }, 0, 50)
SET [e16a30d0-2174-4874-8dae-a5085a75a3e2] as Distinct({Hierarchize({ Generate({[a69e818b-1183-4635-af2a-08199b74b905]}, Ascendants([a69e818b-1183-4635-af2a-08199b74b905].Current.item(0)))})})
SET [4d3bfd6d-d89a-487a-b5a9-348689f2db58] as SUBSET({ NONEMPTY( VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[出方渠道ID] })}}) ),{[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) }, 150, 50)
SET [d1876d2b-e50e-4547-85fe-5b8ed9d629de] as Distinct({Hierarchize({ Generate({[4d3bfd6d-d89a-487a-b5a9-348689f2db58]}, Ascendants([4d3bfd6d-d89a-487a-b5a9-348689f2db58].Current.item(0)))})})
SELECT
[a69e818b-1183-4635-af2a-08199b74b905] dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON COLUMNS ,
[4d3bfd6d-d89a-487a-b5a9-348689f2db58] dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON ROWS
FROM [RegentCube] CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE
WITH
SET [e16a30d0-2174-4874-8dae-a5085a75a3e2] as NONEMPTY({[Measures].[终端销售数量], [Measures].[终端销售吊牌额]})
SET [d1876d2b-e50e-4547-85fe-5b8ed9d629de] as NONEMPTY( VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[区域] })}}) ) * VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[省份] })}}) ),{[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) MEMBER [Measures].[3d268ce0-664d-4092-b9cb-fece97175006] AS Count([e16a30d0-2174-4874-8dae-a5085a75a3e2]) MEMBER [Measures].[8d7fe8c1-f09f-410e-b9ba-eaab75a1fc3e] AS Count ([d1876d2b-e50e-4547-85fe-5b8ed9d629de])
SELECT { [Measures].[3d268ce0-664d-4092-b9cb-fece97175006] , [Measures].[8d7fe8c1-f09f-410e-b9ba-eaab75a1fc3e] } ON AXIS(0)
FROM [RegentCube]
WITH
SET [a69e818b-1183-4635-af2a-08199b74b905] as SUBSET({ NONEMPTY({[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) }, 0, 50)
SET [e16a30d0-2174-4874-8dae-a5085a75a3e2] as Distinct({Hierarchize({ Generate({[a69e818b-1183-4635-af2a-08199b74b905]}, Ascendants([a69e818b-1183-4635-af2a-08199b74b905].Current.item(0)))})})
SET [4d3bfd6d-d89a-487a-b5a9-348689f2db58] as SUBSET({ NONEMPTY( VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[区域] })}}) ) * VISUALTOTALS( ({{Drilldownlevel({ [出方渠道].[省份] })}}) ),{[Measures].[终端销售数量], [Measures].[终端销售吊牌额]}) }, 0, 50)
SET [d1876d2b-e50e-4547-85fe-5b8ed9d629de] as Distinct({Hierarchize({ Generate({[4d3bfd6d-d89a-487a-b5a9-348689f2db58]}, Ascendants([4d3bfd6d-d89a-487a-b5a9-348689f2db58].Current.item(0)) * Ascendants([4d3bfd6d-d89a-487a-b5a9-348689f2db58].Current.item(1)))})})
SELECT [a69e818b-1183-4635-af2a-08199b74b905] dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON COLUMNS ,
[4d3bfd6d-d89a-487a-b5a9-348689f2db58] dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME ON ROWS
FROM [RegentCube] CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE
