如何在MDX quaries中显示行标题名称 [英] How to show row header name in MDX quaries
本文介绍了如何在MDX quaries中显示行标题名称的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在MDX Quaries中显示行标题名称
我尝试过:
SELECT NON EMPTY {[Measures]。[Revenue]} ON Columns,
[Service]。[ServiceGroup]。[ServiceGroup] .members ON行
FROM [CCAnalyticsCube]
WHERE([DimDate]。[Year]。[All],[DimDate]。[Month]。[All],[DimDate]。[WeekOfYear]。[全部])
How to Show Row Header Name in MDX Quaries
What I have tried:
SELECT NON EMPTY { [Measures].[Revenue] } ON Columns ,
[Service].[ServiceGroup].[ServiceGroup].members ON Rows
FROM [CCAnalyticsCube]
WHERE ( [DimDate].[Year].[All], [DimDate].[Month].[All], [DimDate].[WeekOfYear].[All] )
推荐答案
从这里开始: SELECT Statement (MDX) [ ^ ]
如MSDN文档所述,您必须添加一个成员才能生成行标题。
有关详细信息,请检查此主题: MDX查询没有行标题...... [^ ]
Start here: SELECT Statement (MDX)[^]
As MSDN documentation states, you have to add a member to be able to produce "row-header".
For further details, please check this thread: No row headers for MDX query...[^]
这篇关于如何在MDX quaries中显示行标题名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文