Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

SqlSpec

with 10 comments

I’ve just come across SqlSpec from Elasoft (http://www.elsasoft.org/) a tool that can create documentation for Analysis Services databases. You can see some sample output here:
http://www.elsasoft.org/samples.htm

I’ve downloaded it and given it a quick try, and it seems to do the job pretty well. This is the second documentation tool for SSAS that I’m aware of, the other being BI Documenter. Which one is better? Well I guess it depends on what you want to do since the two tools support different data sources and have slightly different features (http://www.elsasoft.org/compare.htm vs http://www.bidocumenter.com/Public/Features.aspx). You can see sample output for BI Documenter here:
http://www.bidocumenter.com/Public/SampleOutput.aspx

You pays your money, you takes your choice…

Written by Chris Webb

May 15, 2008 at 9:42 pm

Posted in Analysis Services

10 Responses

Subscribe to comments with RSS.

  1. Chris,
     
    There is one more documentation tool that works with SSAS : xSQL documenter. I just found about them 2 or 3 days ago.
    There is also free SqlASDoc. It is not as powerful, but it is free.
    And BIDS Helper also can generate out some documentation – some of it is very useful and not available in commercial documentators.
    I do not know which one is better…
     
    Vidas Matelis
     
    Vidas Matelis
     

    Vidas

    May 15, 2008 at 11:10 pm

  2. I have used BI Documenter a few times and it isn\’t too bad.  It covers SSIS and SSRS also.  I didn\’t realize that SqlSpec did SSAS also.  I had demoed their product awhile back and I really liked the dependancy graphs.  I see that it does this for SSAS also, so that is really nice.  It is really helpful to be able to show the business users how everything is related and what could potentially be impacted if a change is made.  They also provide free licenses for database community contributors and MVPs along with some non-profit organizations.  I will have to check out the other two that Vidas mentioned, haven\’t heard of them yet.

    Dan

    May 16, 2008 at 7:01 pm

  3. Hmm, I just looked at the website for xSQL documenter and it looks like the same product as SqlSpec. Perhaps its licensed by different companies in different parts of the world?
     
     

    Chris

    May 19, 2008 at 11:15 am

  4. I also tried out XSQL Documentor and it works great.

    Frank

    May 19, 2008 at 7:26 pm

  5. Chris,
     
    You are totaly right. This is the same product. SQLSpec is original one and they have a licence agreement with xSQL. I just got reply about this from SQLSpec.

    Vidas

    May 19, 2008 at 9:45 pm

  6. Just confirming that xSQL Documentor is OEM\’ed from Elsasoft.  I am the author of SqlSpec btw.  :)

    Jesse

    May 19, 2008 at 9:59 pm

  7. There are other tools as well. Less advanced (but far less expensive :-) ) is Analysis Services Documenter (http://www.ssas-info.com/analysis-services-tools/21-tools/290-sqlasdoc-the-analysis-services-documenter) for instance.
     

    Nico

    May 21, 2008 at 3:12 pm

  8. I checked out sqlSpec and liked it except for the lack of documentation on calculated members – all it had was a dump of the calc script which is not very good for most end users.  I say had because after exchanging a few e-mail the developer (Jesse) has added a feature to a beta version that allows you to embed XML comments in the calc script.  The tool parses the script and picks up comments associated with calculated measures and places them in a table on the mdxScript page and in a table on the page for the associated measure group.  Since the latter is the most common function it allows users to just go to the measure group page and see the definitions of the associated calculated measures.  My thanks to Jesse for this welcome addition.

    Unknown

    June 27, 2008 at 6:57 pm

  9. Also check out this http://www.sqldocumentor.com/sql_server.pdfYou can find more information at http://www.sqldocumentor.com/

    Unknown

    December 5, 2008 at 3:48 pm

  10. Just tried sqlSpec beta 2008 it has a useful addition where for a cube it will give you the table dependencies. Before you needed to navigate from cube – dimension/measure group – table however now you get a list of tables directly from the cube. Useful when you need to tidy up any mart leftovers

    John Shiangoli

    November 8, 2012 at 2:06 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,302 other followers

%d bloggers like this: