• 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
  • 相关阅读:
    生成测试报告unittest、HTMLTestRunner(pytest、allure)
    接口自动化上传视频(python)
    Android手机测试环境搭建
    jmeter性能测试监控
    jmeter多机联合负载
    jenkins+ant+jmeter接口自动化的持续集成
    jmeter+jenkins 配置过程(很详细)
    XSS攻击测试代码
    web安全测试之 xss攻击
    互联网公司--高级测试工程师面试经验分享
  • 原文地址:https://www.cnblogs.com/ycdx2001/p/4115050.html
Copyright © 2020-2023  润新知