How to query list of hierarchies

[Database Administrator]

I want to query SSAS2005 to return a list of hierarchies for a given dimension.

Is there an MDX or XMLA statment to do this for me?
--
JimL

[Database Administrator]

You can use XMLA to return an MDSCHEMA_HIERARCHIES Rowset:

http://msdn.microsoft.com/en-us/library/ms126062.aspx
>>
SQL Server 2008 Books Online (October 2008)
MDSCHEMA_HIERARCHIES Rowset

Describes each hierarchy within a particular dimension.
...
>>


For example, this Discover query returns all 5 user-defined hierarchies
of the Adventure Works Product dimension:


MDSCHEMA_HIERARCHIES


Adventure Works DW
Adventure Works
[Product]
1




Adventure Works DW
Tabular





- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***