Post reply

One Dimension table, multiple foreign keys to Fact Table

  • March 22, 2010 at 9:05 am

    #386555

    Hello,

    My fact table contains the columns "key_1_id" and "key_2_id".

    My dimension table contains the primary key column "key_id" and the "key_name" column.

    In my cube, I want to have a dimension like this" "key_1_name_key_2_name" by joining the fact table columns "key_1_id" and "key_2_id" to the single primary key column in the dimension table "key_id" column.

    How can I get this "key_1_name_key_2_name" done?.

    Thanks.

  • March 23, 2010 at 7:41 am

    #1138220

    Hello gurus,

    Can someone provide some insight on this?.

    thanks.

  • March 29, 2010 at 12:54 pm

    #1141651

    Is it feasible from a performance standpoint to build a view that concatenates the columns together, then join the Fact table to the view? I can't think of a way to get the compound key handled other than that...


    Rick Todd

  • March 30, 2010 at 9:46 am

    #1142379

    If this is in the construction phase, I would go back to the source and do it there, and then bring it into the cube.

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

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