Post reply

combining 2 fact tables in a cube

  • August 11, 2008 at 9:11 pm

    #189192

    Hi,

    I have 2 fact tables where it has all key ID in common and all 3 dimensions are same ..can some one help me how to implement that.

    thanks

    kinnera

  • August 11, 2008 at 9:48 pm

    #856469

    the design is not very clear to me from the statement. however, joining the fact tables into one can be an approach

  • August 12, 2008 at 7:13 am

    #856654

    Hi ,

    there are two measure groups with same MODELID and same level of granularity with time,and other 2 dimensions...how to combine them into one fact table...

    thanks

    kinnera

  • August 12, 2008 at 1:11 pm

    #856989

    the approach i would take would be in the DSV, create a named query that combines the two fact tables together. then, you can bring in the named query into the cube.

    hth

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

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