Post reply

Multiple fact tables w/ different grains in same cube?

  • May 6, 2010 at 6:41 pm

    #222235

    Hello,

    I am trying to create a cube with two fact tables in it. One fact table has a higher grain than another one. Is this possible? The cube I create works fine with the measures derived from the higher level fact table but the lower level fact table creates measures that improperly aggregate everything. Does anyone have any suggestions to remedy this? What am I missing?

    Thanks!

  • May 6, 2010 at 7:03 pm

    #1163732

    After doing a little research I am thinking thinking that I need to use a fact dimension. http://technet.microsoft.com/en-us/library/ms167409.aspx

  • May 9, 2010 at 9:01 am

    #1164703

    Not what I think. Instead of that I suggest you take a close look of the standaard Adventure Works cube, especially at the measuregroups Sales Targets and Sales Orders. They have different granularities. In the UDM you can see how that's been designed.

    Regards,

    Cees

  • May 9, 2010 at 9:16 am

    #1164706

    Thank you cees van diermen. I will check it out. That sounds exactly like what I need to do.

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

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