CODEWITHSUNDEEP
mdx
Skoraaaa
Skoraaaa

Reputation: 41

Work Item Tree Hierarchy

I have a mdx query to the TFS OLAP like this:

SELECT 
[Work Item Tree].[Work Item Tree Hierarchy].&[269]
ON ROWS,
{[Measures].[Work Item Count],
[Measures].[Microsoft_VSTS_Scheduling_OriginalEstimate],
 [Measures].[Microsoft_VSTS_Scheduling_RemainingWork]} ON COLUMNS
FROM
[Team System]
WHERE
([Work Item Link Type].[Link Name].&[Parent], [Work Item].[System_WorkItemType].&[Task])

It works pretty well, but I need as result of this query not only the measures value from the tree hierarchy, but as well for the connected work item. Something like this:

WITH MEMBER [Measures].[OriginalEstimate] AS
(STRTOMEMBER("[Work Item].[System_Id].[" + [Work Item Tree].[Work Item Tree Hierarchy].Properties( "System_Id" )+"]"), [Measures].[Microsoft_VSTS_Scheduling_OriginalEstimate])

SELECT 
[Work Item Tree].[Work Item Tree Hierarchy].&[269]
ON ROWS,

{[Measures].[OriginalEstimate], [Measures].[Work Item Count],
 [Measures].[Microsoft_VSTS_Scheduling_OriginalEstimate],
 [Measures].[Microsoft_VSTS_Scheduling_RemainingWork]} ON COLUMNS
FROM
[Team System]
WHERE
([Work Item Link Type].[Link Name].&[Parent], [Work Item].[System_WorkItemType].&[Task])

But it won't work.

Can you this issue?

Thanks in advance.

Upvotes: 4

Views: 711

Answers (1)

sen77
sen77

Reputation: 151

[Work Item Tree].[Work Item Tree Hierarchy].currentmember.Properties( "System_Id" )

Upvotes: 1

Related Questions