要连接具有相同层次结构的2个mdx查询 [英] To join 2 mdx queries with same hierarchy
本文介绍了要连接具有相同层次结构的2个mdx查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有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屋!
查看全文