documenting SSAS project

Hi

Is there an easy way of documenting a SSAS project i.e. producing a document that describes all the cubes its measure and related dimesions?

Thanks

Gary

Hi Gary,

Here's a SQL Server 2005 BI documentation tool which I've come across:

http://www.bidocumenter.com/Public/Default.aspx

>>

With BI Documenter you can...

Generate complete SQL documentation at the push of a button

Document SQL Server, Analysis Services, Integration Services and Reporting Services in the same documentation set

Capture metadata snapshots for historical analysis

Output HTML Help (*.chm) or plain HTML

Use either a graphical wizard or command line interface

Document SQL Server 2005!

Tell your own story using the built-in diagramming tool

>>

|||

I have tried the same product as Deepak describes. The product will help but the output is not suitable for business people nore end users.

It is a product that will help developers to consolidate information of their own work.

The missing part is graphical presentation of dimensions,measures and calculations that end users understand.

You will have to do this on your own.

I suggest that you buy a copy of "Microsoft Data Warehouse Tooolkit" .

HTH

Thomas Ivarsson

|||

Thanks for the suggestions. software looks pretty good.

Thomas - why do you suggest the book?

Thanks

Gary

|||

This book have several good examples of how to document your solution, from ETL to the Cubes. They can be understood by business users not only it-staff people.

HTH

Thomas

|||

Thanks alot

Will look into it.

G