SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What tool to document the data warehouse and/or cubes for our end user community?


What tool to document the data warehouse and/or cubes for our end user community?

Author
Message
Eric Mamet
Eric  Mamet
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6163 Visits: 955
Dear all,

Like many, we built a data warehouse (datamart?) and a set of cubes and we'd like our users to be able to query the database themselves through some tool like SSRS or PowerPivot as well as querying the cubes through Excel Pivot tables.

Obviously, we need to make clear what our database/cubes contain and the exact meaning of each field, etc...

In your experience, what tool (free is better!) would you recommend for doing this?

I was wondering about using a WIKI because it would make it easier to have this maintained by a group of users... rather than just me!


Thanks for your help


Eric Unsure
twin.devil
twin.devil
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12266 Visits: 2898
just to get an idea. that you are looking for Alternative of SSAS. Am i right ?
Eric Mamet
Eric  Mamet
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6163 Visits: 955
Not really, more a complement.
It's mainly documentation we are trying to produce so that our users can use the data available.

There are things in our datamart we don't expose through SSAS and queries across dimensions and/or facts not covered by our cubes.

Powerpivot is indeed an alternative to SSAS but our main OLAP reporting will remain SSAS (multidimensional)
Rob Taylor
Rob Taylor
SSCrazy Eights
SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)SSCrazy Eights (8K reputation)

Group: General Forum Members
Points: 8026 Visits: 1664
Eric Mamet (12/5/2013)
Like many, we built a data warehouse (datamart?) and a set of cubes and we'd like our users to be able to query the database themselves through some tool like SSRS or PowerPivot as well as querying the cubes through Excel Pivot tables.

Obviously, we need to make clear what our database/cubes contain and the exact meaning of each field, etc...

In your experience, what tool (free is better!) would you recommend for doing this?

I was wondering about using a WIKI because it would make it easier to have this maintained by a group of users... rather than just me!

I've used a Wiki in one environment and Excel at another job and wasn't really satisfied with either. The biggest problem was keeping these manual solutions up to date (probably a failing of mine :laughSmile

I'm looking for a better way to document our BI stack as well; I'm going to take a look at Pragmatic Works BI Documenter http://pragmaticworks.com/Products/BI-Documenter.aspx. It's not free, but the price doesn't seem to bad (starting at $595).

My two cents,
Rob
Eric Mamet
Eric  Mamet
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6163 Visits: 955
Could Master Data Management help?

I know that's not really the main purpose of that tool but isn't there a documentation aspect to it?
Scott Murray-240410
Scott Murray-240410
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2381 Visits: 3152
A little self promotion, but take a look at this MSSQL Tip which uses a linked server and some SSAS DMVs.

Scott

http://www.mssqltips.com/sqlservertip/2603/build-a-sql-server-analysis-services-data-dictionary/
Eric Mamet
Eric  Mamet
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6163 Visits: 955
Scott,


Thanks for that. It's really interesting and I will certainly "pinch" the idea for some project but it may not answer exactly my current problem.

The documentation I am looking for should cover both the Datamart(s) and OLAP levels as well as (if possible) help some avanced users build their own queries.
Although we don't know yet which tool the users would use for querying, I need to try and explain how they should join tables/views, etc.
Ideally, sprinkling a few pictures in the middle to make the relationships more intuitive.

Maybe a mixture of Visio/Excel/Sharepoint would work...



Many Thanks


Eric ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search