Need Help with Cube Documentation:

  • Hi,

    What all can we include in SSAS Cube Design documentation

    I have included the data model,facts,dimensions,surrogate keys,Hierarchies and levels within hierarchies.

    Reports that we can pull from the cube,Proactive caching.

    What else can we include.

    I'm confused.Please help me out.

    Thanks in Advance,

    Samyuktha

  • I would add just one more thing: considerations regarding slowly changing dimensions. Which of our dims are going to change, and what are we going tyo do about it?

    This is rather important if your cubes are going to be partitioned.

  • roles & security

    calculated measures (i typically include a copy of the MDXScript as well)

    Also, you may find this interesting...

    http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/

  • Thanks a lot for your suggestions.

    But,this is the Initial phase of design document.

    Please suggest by taking this into consideration.

    I just have a data model and some report specs which we call pull from the cube later on and from this data I need to design the document

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply