要连接具有相同层次结构的2个mdx查询 [英] To join 2 mdx queries with same hierarchy

问题描述

我有2个mdx查询，如下:

I have 2 mdx queries as:

SELECT 
NON EMPTY { [Measures].[Sum of Sales_Value_USD], [Measures].[Sum of Sales_Value_USD Late] } ON COLUMNS, 
NON EMPTY { ([DateDimension].[DATE_QUARTER].[DATE_QUARTER].ALLMEMBERS ) } ON ROWS
FROM [Model]
where
( [DateDimension].[CurrentQuarter].&[Yes], { [ProductLine].[ProductHierarchy]
.[Product_Level5].&[PP100 - Electric Solutions], [ProductLine].[ProductHierarchy].[Product_Level5].&[PP200 - Gas Solutions], [ProductLine].[ProductHierarchy]
.[Product_Level5].&[PP300 - Water Solutions] } , { [SalesHistory].[Status].&[BACKLOG]
, [SalesHistory].[Status].&[HISTORY] } ) 



SELECT 
NON EMPTY { [Measures].[Sum of Sales_Value_USD], [Measures].[Sum of Sales_Value_USD Late] } ON COLUMNS, 
NON EMPTY { ([DateDimension].[DATE_QUARTER].[DATE_QUARTER].ALLMEMBERS ) } ON ROWS 
FROM [Model]
where 
( [DateDimension].[NextQuarter].&[Yes] , { [ProductLine].[ProductHierarchy].[Product_Level5].&[PP100 - Electric Solutions], [ProductLine].[ProductHierarchy]
.[Product_Level5].&[PP200 - Gas Solutions], [ProductLine].[ProductHierarchy]
.[Product_Level5].&[PP300 - Water Solutions] },{ [SalesHistory].[Status].&[BACKLOG]
, [SalesHistory].[Status].&[HISTORY] } )

我需要将它们合并为1个结果集.请帮助我实现此目标... 我是MDX的新手，没有足够的信息.

I need to combine them into 1 result set..Please help me in achieving this objective... I am very new to MDX and does not have enough information.

谢谢

推荐答案

由于[DateDimension].[NextQuarter].& [Yes]和[DateDimension].[CurrentQuarter].&[Yes]是不同的层次结构，您不能简单地合并结果.

Since [DateDimension].[NextQuarter].&[Yes] and [DateDimension].[CurrentQuarter].&[Yes] are not the same hierarchies, you can not simply combine the results.

但是您可以创建新的计算成员，以将所有度量提取到一个MDX中.

But you can create new calculated members to have all measures extracted in one MDX.

WITH MEMBER [Measures].[Sum of Sales_Value_USD CurrentQuarter] AS
    ([DateDimension].[CurrentQuarter].&[Yes], [Measures].[Sum of Sales_Value_USD])

MEMBER [Measures].[Sum of Sales_Value_USD Late CurrentQuarter] AS
    ([DateDimension].[CurrentQuarter].&[Yes], [Measures].[Sum of Sales_Value_USD Late])

MEMBER [Measures].[Sum of Sales_Value_USD NextQuarter] AS
    ([DateDimension].[NextQuarter].&[Yes], [Measures].[Sum of Sales_Value_USD])

MEMBER [Measures].[Sum of Sales_Value_USD Late NextQuarter] AS
    ([DateDimension].[NextQuarter].&[Yes], [Measures].[Sum of Sales_Value_USD Late])

SELECT 
NON EMPTY{ 
    [Measures].[Sum of Sales_Value_USD CurrentQuarter], 
    [Measures].[Sum of Sales_Value_USD Late CurrentQuarter]，
    [Measures].[Sum of Sales_Value_USD NextQuarter],
    [Measures].[Sum of Sales_Value_USD Late NextQuarter]
 } ON COLUMNS, 
NON EMPTY { ([DateDimension].[DATE_QUARTER].[DATE_QUARTER].ALLMEMBERS ) } ON ROWS 
FROM [Model]
where
({[ProductLine].[ProductHierarchy].[Product_Level5].&[PP100 - Electric Solutions], 
  [ProductLine].[ProductHierarchy].[Product_Level5].&[PP200 - Gas Solutions], 
  [ProductLine].[ProductHierarchy].[Product_Level5].&[PP300 - Water Solutions] } , 
 {[SalesHistory].[Status].&[BACKLOG], [SalesHistory].[Status].&[HISTORY] } ) 

这篇关于要连接具有相同层次结构的2个mdx查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！