Data warehouse schema top down design guidelines?


  • Im starting with a top down approach, because I am starting from scratch with no OLAP DB. 

    Say your starting with a new cube, and you are definining what it is you want to measure.

    When you start with designing a new cube, will the number of measure groups result in the same number of fact tables?

    What guidelines do you use to determine if a cube should have multiple measure groups? 

    • Edited by shiftbit Wednesday, September 25, 2013 8:01 PM asdf
    Wednesday, September 25, 2013 8:00 PM