Hi,

I am trying to build documentation on SSAS 2005. I was not able to find any
documentation tools right now in the market so I am trying to build
something quickly myself.
First, from SQL management studio I created XMLA script to create Analysis
Services database. I saved this script into file and loaded into SQL Server
XML type field. I am trying to query now this field and was wondering if
anyone already did this and have some script examples. Example, how do you
get list of cubes, dimensions, perspectives etc? Dimensions by the
measuregroup used? Dimensions by perspective used? ETC...

I am trying to use OPENXML method in SQL Server and I cannot make it work as
I would expect, so any help would be highly appreciated.

Are there any better ways to do this? I am mostly DBA and would like to do
this without writing anyhing in VB.NET or C#.NET.

Thanks in advance

search the metadata sample application on the MS web site.
this tool extract your cube information and save it in a table. (and SSIS
packages metadata too)


"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Hello,

I ' d consider AMO might be better option to manage/display AS objects. You
could check amobroswer sample for some information. Also, the following
link is for your reference:

http://msdn.microsoft.com/msdnmag/is...O/default.aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


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

Hi Jeje,

Thanks for this info. I believe you mean
"SQL Server 2005 Business Intelligence Metadata Samples Toolkit"
I did install it and played with it. But this kit is used more for
dependency viewing and not structure reporting. 5 tables that data is
extracted into has just basic info. I know I could start with this and
develop something, but I was hopping that many more people have same problem
and there should be something in the market to address this.
I need simple documentation that based on Analysis SErvices database I would
print and give it to clients.
Something like OlapScribe in Analysis Services 2000.


Thanks


"Jeje" <willgart (AT) hotmail (DOT) com> wrote

There is SQL documentation tool called BI Documenter -
http://www.bidocumenter.com which i think does exactly what you are asking
for.

BI Documenter can document your Analysis Services (SSAS) databases as well
your SQL databases (all the same document too).

Hope this helps you.

Richard.

"Vimas" wrote: