访问TFS立方体以获取区域层次结构的唯一名称
我想获取给定区域路径的唯一名称。
我看过 John Socha 的这篇文章: http: //blogs.socha.com/2009/10/customizing-report-parameters-for-team.html。我想做的是在一个查询中完成约翰正在手动执行的操作。
我有一种“通用”查询来获取给定区域层次结构级别的所有值。查询是这样的:
WITH
MEMBER [Measures].[ParameterValue] AS [Work Item].[Area Hierarchy].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS [Work Item].[Area Hierarchy].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterValue],
[Measures].[ParameterLevel]
} ON COLUMNS,
NON EMPTY { ([Work Item].[Area Hierarchy].[Area1].ALLMEMBERS ) }
ON ROWS
FROM [Team System]
通过这个查询,我获得这些值:
因此,给定一个区域路径(如 \Tailspin Toys\Web Development)可能会获得该区域的唯一名称在 TFS 立方体中?
非常感谢!
最好的问候,
维森斯
I would like to obtain the unique name of a given area path.
I've seen this article of John Socha: http://blogs.socha.com/2009/10/customizing-report-parameters-for-team.html. What I would like to do is to do in one query what John is doing manually.
I have a kind of "generic" query to obtain all the values of given area hierarchy level. The query is this:
WITH
MEMBER [Measures].[ParameterValue] AS [Work Item].[Area Hierarchy].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS [Work Item].[Area Hierarchy].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterValue],
[Measures].[ParameterLevel]
} ON COLUMNS,
NON EMPTY { ([Work Item].[Area Hierarchy].[Area1].ALLMEMBERS ) }
ON ROWS
FROM [Team System]
With this query I obtain these values:
So, it is possible that given an area path like \Tailspin Toys\Web Development obtain the unique name of the area in the TFS cube?
Thank you very much!
Best regards,
Vicenç
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
![扫码二维码加入Web技术交流群](/public/img/jiaqun_03.jpg)
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您可以使用 WHERE 子句限制 MDX SELECT 查询。将以下内容添加到查询末尾
You can restrict an MDX SELECT query using the WHERE clause. Add the following to the end of your query