MDX query for Changeset assigned to WorkItem RRS feed

  • Question

  • I am new to MDX environment.

    I am using VSTFS Tfswarehouse db

    How to get Work Items assigned / not assigned to a Change set in TFS using cube.

    I used the below codes but unable to get the desired output.




    [Measures].[Code Churn Count]

    ) on Columns ,



    ([Changeset].[Changeset].[Changeset].ALLMEMBERS *

    [Checked In By].[Person].[Person].ALLMEMBERS *

    [Changeset].[Changeset ID].[Changeset ID].ALLMEMBERS *

    [Date].[Date].[Date].ALLMEMBERS * --*

    ([Work Item].[System_Id].[System_Id].ALLMEMBERS *

    [Work Item].[System_Title].[System_Title].ALLMEMBERS )






    ([Changeset].[Changeset].[Changeset] *

    [Checked In By].[Person].[Person] *

    [Changeset].[Changeset ID].[Changeset ID] *

    [Date].[Date].[Date] *

    IIF(ISEMPTY([Work Item].[System_Id].[System_Id]),0,[Work Item].[System_Id].[System_Id])*

    IIF(ISEMPTY([Work Item].[System_Title].[System_Title]),0,[Work Item].[System_Title].[System_Title])


    } ON Rows

    FROM [Team System]


    Saturday, July 12, 2008 12:27 AM


All replies


    Hello Prabh,


    You might also want to submit this question to the Analysis Services forum:







    Monday, July 14, 2008 9:39 PM
  • As Amanda has suggested, the Analysis Services forum usually has a few more MDX gurus in it, so you might try posting there.  However, I will mention that I don't completely understand what you're trying to accomplish.  I think you're working with a private cube, unless I'm mistaken, in which case it will be more difficult for people to follow you without a more thorough explanation of the logic in the cube and what exactly you are trying to get out of it.  It would probably help to be a little more generic in what your end goal is and what you've tried so far, perhaps with a psuedo-code example to aid in understanding.  As of now, I'm not sure what the end goal is, so it's hard for me to make a recommendation.


    Monday, July 14, 2008 10:56 PM
  • Thanks ben. As suggested i am posting the same to the Analysis Service forum.


    Tuesday, July 15, 2008 12:21 AM