Getting list of users by giving team project name and iteration id.

Question

 

Hi, I need to get the list of the users who are all associated with the team project to show as a filter.

I have Iteration id and team project name to filter out.

---------------------------

WITH MEMBER [Measures].[ParameterCaption] AS '[Assigned To].[Person].CURRENTMEMBER.MEMBER_CAPTION'

MEMBER [Measures].[ParameterValue] AS '[Assigned To].[Person].CURRENTMEMBER.UNIQUENAME'

MEMBER [Measures].[ParameterLevel] AS '[Assigned To].[Person].CURRENTMEMBER.LEVEL.ORDINAL'

SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]}

ON COLUMNS ,

[Assigned To].[Person].ALLMEMBERS ON ROWS

FROM ( SELECT STRTOSET(@IterationID, CONSTRAINED) ON COLUMNS

FROM [Team System])

---------------------------------------

 

Above query shows all users,  but I am passing only Iteration.   How to pass team project also.

How to do the above in MDX or Relational Query.

 

 

Thanks in Advance.

Answer 1

Hi,

I have got the same question. Anybody for an answer?

Regards,

Louis