About
The SSAS document generator is a simple command line script that generates a Data Dictionary for an SSAS Cube. The Data Dictionary is output in HTML, with links between entities. You can modify the style of the HTML to suit your requirements.
Instructions
First, you need to add descriptions to the Measure Groups, Measures, Dimensions and Attributes in your Cube project. In your Visual Studio SSAS project, simply enter your descriptions into the description property of each dimension/”fact/”measure group” and measure/attribute you want to document:
Once your descriptions are set up, follow this procedure to generate the documentation:
- Register and Download the script (see below).
- Unzip the file.
- Edit the data_dictionary_cube.bat. Where the script refers to E:\DM\trunk\Cube\Cube.dwproj, change this to the path to the project file of your SSAS project. If your path contains spaces, make sure you wrap the path in double quotes. E.g. “E:\DM\trunk\Cube\Cube.dwproj”.
- Execute the data_dictionary_cube.bat file. The resulting Data_Dictionary_Cube.html contains the Cube documentation.
Change the output styling.
You can modify the style by editing the inline style in the Data_Dictionary_Cube_Msr_Part_A.xslt. You could change this to reference a style sheet, but you will also need to change the references to the style class elements in the XSLT.
Download
Please register below to download the SSAS Documentation Generator script: