metadata services for analysis services

Question

Hi,

   I was wondering if anyone can tell me what options do I have to browse metadata for a cube built on Analysis services 2005. We would not like to buy a new thrid aprty tool for this. Does sql server 2005/ analysis services 2005 have a inbuilt option to view the metadata?

Thanks in advance.

Answer 1

Try running an AMOBrowser sample applicaiton. You should be able to see all Analysis Services metadata.

Another point here is: In version 2005 Analysis Services metadata is in XML format and it is easily obtainable. Go to the SQL Management studio, right click on any object and you can create a script containing metadata definition of the object. You can parce the XML yourself and manipulate it the way you want.

Hope that helps.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

thank you so much for the information. But i dont see any place at microsoft where I download the amoBrowser. Can you point me where I can find the amoBrowser and its installation files?

thanks again.

Answer 3

AMOBrowser is part of the Samples you install with the product. You dont need to download it separately.

After installing the Samples you should be able to find it on your machine in  C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

i just saw that in one of the postings. Unfortulately i dont have those files. I installed the samples but I have the developer edition, maybe I shold have the enterprise edition for this? Do you think its right?

Answer 5

nevermind, i found it here,

http://msdn2.microsoft.com/en-us/library/ms160930.aspx

thanks again.

Answer 6

Hi

 

Maybe this code could help you:

 

http://www.codeplex.com/TSSASM

 

Thanks

 

Leandro