Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSAS - how to get a list of all dims, measures

Author  Topic 

dhw
Constraint Violating Yak Guru

332 Posts

Posted - 2009-11-03 : 12:35:53
Hi -
I have started to work with several different SSAS servers and we're considering consolidating some of the SSAS Cubes/Databases.

Is there any tool or proc that would allow me to list out all the various measures and dimensions from each cube/db?

thanks
- will

dhw
Constraint Violating Yak Guru

332 Posts

Posted - 2009-11-03 : 15:15:29
I found a solution here:
http://www.codeplex.com/wikipage?ProjectName=ASStoredProcedures&title=XmlaDiscover&referringTitle=Home

Go to Top of Page
   

- Advertisement -