One Dimension table, multiple foreign keys to Fact Table

• ganeshmuthuvelu

  SSCrazy

  Points: 2177

  More actions

  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.

• ganeshmuthuvelu

  SSCrazy

  Points: 2177

  More actions

  March 23, 2010 at 7:41 am

  #1138220

  Hello gurus,

  Can someone provide some insight on this?.

  thanks.

• Rick Todd

  Hall of Fame

  Points: 3302

  More actions

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  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.