Accessing TFS cube to obtain area hierarchy's unique name

I would like to obtain the unique name of a given area path.

I've seen this article of John开发者_JS百科 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ç

---

You can restrict an MDX SELECT query using the WHERE clause. Add the following to the end of your query

WHERE [Work Item].[Item Hierarchy].[Tailspin Toys].[Web Development]