MDX分页查询

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