locked
how to write a design documentation? RRS feed

  • Question

  • hi all,

    any advices on how to write a technical design documentation for the SSAS cube?

    i've no idea what to include in the documentation.

    if there is a template, it would be much better.

    Thanks


    Andrew
    BI, Data Mining, Analytical CRM
    Tuesday, April 26, 2011 2:51 PM

Answers

  • Your documentation can include

    Bus Metrics: relation between measures and dimensions

    Info on Dimenson: This include description of dimension, des about attributes of dimension, any hierarchy information

    Measure: Description of Measures, the measure group it belongs and aggregation type of the measure.

    Calculation: Info on the calculation and brief desc about the formula.

    Cubes: You can also have information about the cube itself and about the perpectives if you have any.

    If you permissions/role specific setting, then you can include that too in the security section/

    Additionally for each of the dimension and measure you can detail information about the source table or dsv or named queries

    I think this covers most of SSAS information.

     


    vinu
    • Proposed as answer by Vinuthan Wednesday, April 27, 2011 7:23 PM
    • Marked as answer by Andrew Goodnight Friday, April 29, 2011 5:06 AM
    Tuesday, April 26, 2011 3:19 PM
  • hi all,

    1. u could have a look at this tool.

    SqlASDoc, the Analysis Services Documenter

     

    2. actually, i hope to get a fine-structured and well-formated documentation.

     

     

     

     


    Andrew
    BI, Data Mining, Analytical CRM
    • Proposed as answer by Vinuthan Wednesday, April 27, 2011 7:23 PM
    • Marked as answer by Andrew Goodnight Friday, April 29, 2011 5:06 AM
    Wednesday, April 27, 2011 6:44 AM

All replies

  • Your documentation can include

    Bus Metrics: relation between measures and dimensions

    Info on Dimenson: This include description of dimension, des about attributes of dimension, any hierarchy information

    Measure: Description of Measures, the measure group it belongs and aggregation type of the measure.

    Calculation: Info on the calculation and brief desc about the formula.

    Cubes: You can also have information about the cube itself and about the perpectives if you have any.

    If you permissions/role specific setting, then you can include that too in the security section/

    Additionally for each of the dimension and measure you can detail information about the source table or dsv or named queries

    I think this covers most of SSAS information.

     


    vinu
    • Proposed as answer by Vinuthan Wednesday, April 27, 2011 7:23 PM
    • Marked as answer by Andrew Goodnight Friday, April 29, 2011 5:06 AM
    Tuesday, April 26, 2011 3:19 PM
  • hi all,

    1. u could have a look at this tool.

    SqlASDoc, the Analysis Services Documenter

     

    2. actually, i hope to get a fine-structured and well-formated documentation.

     

     

     

     


    Andrew
    BI, Data Mining, Analytical CRM
    • Proposed as answer by Vinuthan Wednesday, April 27, 2011 7:23 PM
    • Marked as answer by Andrew Goodnight Friday, April 29, 2011 5:06 AM
    Wednesday, April 27, 2011 6:44 AM