Post reply

Need Help with Cube Documentation:

  • December 19, 2011 at 10:04 am

    #146273

    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

  • December 19, 2011 at 10:09 am

    #1423199

    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.

  • December 19, 2011 at 11:22 am

    #1423233

    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/

    Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com

  • December 19, 2011 at 11:25 am

    #1423237

    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