MDX合并两个结果集实现inner join的效果
0
现在需要对一个销售的cube进行按区域按产品名字的mdx查询，显示出每个产品，在不同区域的销售额，现在问题是：希望返回的结果集的行不仅包含产品名称同时希望也显示出该产品的价格和供应商，具体显示效果如下：
请大牛们不吝赐教
请大牛们不吝赐教
没有找到相关结果
重要提示：提问者不能发表回复，可以通过评论与回答者沟通，沟通后可以通过编辑功能完善问题描述，以便后续其他人能够更容易理解问题.
5 个回复
felixwon 2014-06-19 回答
赞同来自: 梁勇
member [Measures].[Last Order Price] AS [Dim Product].[Product Key].CurrentMember.Properties("Last Order Price")
select {
[Measures].[Last Order Price],
[Measures].[Supplier],
[Measures].[Order Quantity]
} ON COLUMNS,
non empty {
[Dim Product].[Product Key].Members * [Dim Territory].[State].Members
} on rows
FROM salesCube
felixwon 2014-06-19 回答
赞同来自:
Member [Measures].[Last Order Price] as [Dim Product].[Product].Properties("Last Order Price")
AndrewMelb 2014-06-19 回答
赞同来自:
with member [Measures].[Supplier] AS [Dim Product].[Product key].CurrentMember.Properties("Supplier")
member [Measures].[Last Order Price] AS [Dim Product].[Product Key].CurrentMember.Properties("Last Order Price")
select {
[Measures].[Last Order Price],
[Measures].[Supplier]
} ON COLUMNS,
non empty {
[Dim Product].[Product Key].AllMembers
} ON ROWS
FROM salesCube
----------------------------------------------------------------------------------------------------------
SELECT {
([Dim Territory].[State].&[VIC]),
([Dim Territory].[State].&[NSW]),
([Dim Territory].[State].&[QLD]),
([Dim Territory].[State].&[SA]),
([Dim Territory].[State].&[WA]),
([Dim Territory].[State])
}
on columns,
non empty {
[Dim Product].[Product Key].Members
} on rows
FROM salesCube
where { [Measures].[Order Quantity] }
heaven - 微软BI架构、SSRS高级开发 2014-06-19 回答
赞同来自:
with member [Measures].[Supplier] AS [Dim Product].[Product key].CurrentMember.Properties("Supplier")
member [Measures].[Last Order Price] AS [Dim Product].[Product Key].CurrentMember.Properties("Last Order Price")
select {
[Measures].[Last Order Price],
[Measures].[Supplier],[Measures].[Order Quantity]
} ON COLUMNS,
non empty {
{
([Dim Territory].[State].&[VIC]),
([Dim Territory].[State].&[NSW]),
([Dim Territory].[State].&[QLD]),
([Dim Territory].[State].&[SA]),
([Dim Territory].[State].&[WA]),
([Dim Territory].[State])
} ,[Dim Product].[Product Key].AllMembers
} ON ROWS
FROM salesCube
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2015-01-12 回答
赞同来自:
with member [Measures].[Supplier] AS
[Dim Product].[Product key].CurrentMember.Properties("Supplier")
member [Measures].[Last Order Price] AS
[Dim Product].[Product Key].CurrentMember.Properties("Last Order Price")
select {
[Measures].[Last Order Price],
[Measures].[Supplier],[Measures].[Order Quantity]
} ON COLUMNS,
non empty {
{
([Dim Territory].[State].&[VIC]),
([Dim Territory].[State].&[NSW]),
([Dim Territory].[State].&[QLD]),
([Dim Territory].[State].&[SA]),
([Dim Territory].[State].&[WA]),
([Dim Territory].[State])
}
*
{[Dim Product].[Product Key].AllMembers}
} ON ROWS
FROM salesCube