September 16, 2009 at 11:10 am
Hi,
I want to get a list of all the Dimension, Measures and calculations from a SSAS2005 cube. What would be an easy (or Hard) way to do this?
I have tried this so far:
Above forum is giving two ways. First way is to try SqlASDoc. This would not install on my computer because it requires Microsoft.AnalysisServices Version 10.0.0.0 to be installed in GAC. Please see attached image of the error. I couldn't figure out how to install the new version.
I tried second method. It requires an assembly to be installed on the server, and my server admin refuses to install anything on the server.
Please help..
------------
🙂
September 16, 2009 at 1:13 pm
Have you tried SqlSpec?
http://www.elsasoft.org/%5B/url%5D
Great tool and very affordable. Try it out and you can also look at the samples.
http://www.elsasoft.org/samples.htm
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 16, 2009 at 5:03 pm
You can create a simple code using VS. There is an API called AMO to connect directly to OLAP cube, and using this API you can list down all object in AS.
Try the sample in SQL Server built in sample.
September 17, 2009 at 4:39 am
Yeah, if you want to do this on your own you can utilize the AMO and take a look at the samples out on CodePlex that are setup. There is an AMO Browser tool that you can use and a few other samples in the Programmability section that you might find useful.
http://msftasprodsamples.codeplex.com/%5B/url%5D
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply