Home Forums Data Warehousing Strategies and Ideas What tool to document the data warehouse and/or cubes for our end user community? RE: What tool to document the data warehouse and/or cubes for our end user community?

  • December 5, 2013 at 6:17 am

    #1671033

    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 :laugh:)

    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