MDX 语句优化达人coming

2015-08-31 02:53:35 153 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

测试工程师玩转DeepSeek之Prompt 掌握这些提示词技巧，测试工程师可提升与DeepSeek的协作效率至少3倍。建议结合具体项目上下文进行二次优化，并建立团队内部的提示词知识共享库。✅ “为电商支付接口生成包含幂等性验证的测试用例，覆盖网络中断重试场景”❌ “帮我写测试用例” 阅读详情

不知道是数据切割问题还是在日期划分上有问题



 with member KeyMembers as [Dim Product].[Product Dev Cd III].currentmember.Properties('key')  

 select {([Measures].[Sales Amount]),([Measures].[Quantity]),([Measures].[ProductCount]),(KeyMembers)} 

 on 0 , Order( nonEmpty([Dim Product].[Product Dev Cd III].Members) ,Measures.[Sales Amount] , DESC )  

 on 1    from  ( select ({ ([Dim Product].[Product Dev Cd III].&[1304]) }) on 0  

  from  ( select ({ ([Dim Shop].[Shop Uni Cd].&[99991001010103]),([Dim Shop].[Shop Uni Cd].&[999910010102]),

  ([Dim Shop].[Shop Uni Cd].&[99991001010201]),([Dim Shop].[Shop Uni Cd].&[99991001010301]),

  ([Dim Shop].[Shop Uni Cd].&[99991001010401]),([Dim Shop].[Shop Uni Cd].&[999910010201]),

  ([Dim Shop].[Shop Uni Cd].&[999910010202]),([Dim Shop].[Shop Uni Cd].&[999910010302]),

  ([Dim Shop].[Shop Uni Cd].&[999910010303]),([Dim Shop].[Shop Uni Cd].&[999910010304]),

  ([Dim Shop].[Shop Uni Cd].&[999910010305]),([Dim Shop].[Shop Uni Cd].&[999910010306]),

  ([Dim Shop].[Shop Uni Cd].&[999910010307]),([Dim Shop].[Shop Uni Cd].&[999910010308]),

  ([Dim Shop].[Shop Uni Cd].&[999910010401]),([Dim Shop].[Shop Uni Cd].&[999910010402]),

  ([Dim Shop].[Shop Uni Cd].&[9999100105]),([Dim Shop].[Shop Uni Cd].&[9999100106]),

  ([Dim Shop].[Shop Uni Cd].&[9999100108]),([Dim Shop].[Shop Uni Cd].&[9999100109]),

  ([Dim Shop].[Shop Uni Cd].&[9999100301]),([Dim Shop].[Shop Uni Cd].&[9999100401]),

  ([Dim Shop].[Shop Uni Cd].&[9999100501]),([Dim Shop].[Shop Uni Cd].&[9999100701]),

  ([Dim Shop].[Shop Uni Cd].&[9999300201]),([Dim Shop].[Shop Uni Cd].&[9999300301]),

  ([Dim Shop].[Shop Uni Cd].&[9999300601]) }) on 0   

  from  ( select ({ ([Dim Product].[Product Area Cd].&[001])  }) on 0 from  [SMBIDBCUBE]   )    )    )

    where {(( [Dim Date Summary].[Date Key].[20150701]) : ([Dim Date Summary].[Date Key].[20150816])) }

上述语句是可以执行的，但是把日期改成20150731 查询出来的就是空数据
下面精简了查询条件，就可以查询出来数据。。很纳闷了



 with member KeyMembers as [Dim Product].[Product Dev Cd III].currentmember.Properties('key')  

 select {([Measures].[Sales Amount]),([Measures].[Quantity]),([Measures].[ProductCount]),(KeyMembers)} 

 on 0 , Order( nonEmpty([Dim Product].[Product Dev Cd III].Members) ,Measures.[Sales Amount] , DESC )  

 on 1    from  ( select ({ ([Dim Product].[Product Dev Cd III].&[1304]) }) on 0  

  from  ( select ({ ([Dim Shop].[Shop Uni Cd].&[99991001010103]) }) on 0   

  from    ( select ({ ([Dim Product].[Product Area Cd].&[001])  }) on 0 from  [SMBIDBCUBE] )) )

    where {(( [Dim Date Summary].[Date Key].[20150731]) : ([Dim Date Summary].[Date Key].[20150816])) }

...全文