SSAS-Info.com - Microsoft SQL Server Analysis Services (SSAS) 2005/2008 resource hub
SSAS Tools SqlSpec - documentation tool for Analysis Services 2005
SqlSpec - documentation tool for Analysis Services 2005
User Rating: / 7
PoorBest 
Saturday, 05 April 2008 03:03

SqlSpec will document these objects for any Analysis Server 2005 database:

  • database and server properties
  • data sources
  • data source views and associated tables and views
  • cubes and their related objects:
    • cube dimensions and their attributes
    • measure groups and measures
    • kpis
    • calculations
    • actions
    • perspectives
    • partitions
  • dimensions
  • mining structures and models
  • assemblies
  • roles
  • database permissions
  • dependencies between all objects above

You can see example of SSAS 2005 database documentation here.

You can read more about SqlSpec here.