Home Forums Data Warehousing Analysis Services Cube Designs - how many, how do you deal with size and timeframe? RE: Cube Designs - how many, how do you deal with size and timeframe?

  • I think what you need to take a look at is measure group partitions and storage modes. There are many articles out there that cover this subject, this is a good place to start: https://technet.microsoft.com/en-us/library/cc966527.aspx

    It sounds like you have done quite a bit of analysis already so generally speaking you match the design of the above with what sort of queries will be thrown at the cube.


    I'm on LinkedIn