Hi, All.
I have serious problem with subject.
So, I want to extract cube' metadata from MSAS (dimensions, attributes, hierarchies etc.). I've tried XMLA, but it is too slow. Are there any ways to extract metadata with MDX for example, or with something else that can extract this data faster than XMLA (in my case it took about 10 minutes, I've used Discover method).
I've seen MDX' local cube copies methods but they're rather slow too (for tiny subcube of AdventureWorks it took about 30 seconds to create local copy).
Thanks for answers.
Hi and welcome to the forums. The preferrred way to retrieve the SSAS metadata is to use Analysis Services Management Objects (AMO) as I demoed in the book. In SSAS 2008, you can use also rowsets to obtain some of the metadata, as I demonstrated here. Note the performance of the metadata retrieval will depend on the size and complexity of the database itself, such as number of aggregations, objects, etc. There is an interesting thread going on on the SSAS discusion list about this which may give you some other ideas to explore.
Thanks a lot for your answer!