locked
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.

     

    Select

    NONEMPTY (

    [Measures].[Code Churn Count]

    ) on Columns ,

    {

    NONEMPTY

    ([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 )

    )

    }

    +

    {

    NONEMPTY

    ([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]

    WHERE([Filename].[Parent_ID].&[39233])

    Saturday, July 12, 2008 12:27 AM

Answers

All replies

  •  

    Hello Prabh,

     

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

     

    http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=83&SiteID=17

     

    Regards,

    Amanda

     

    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