same key at Fact table link diff dimension table ?

Let said a senario with this situation:

Fact table contain 2 type data.1 st type is the company data and 2 nd is an individual data. In the fact table have a column called GenderID.

Company data have to use GenderID key link to CompanyGender dimension table and individual data also use GenderID key to link Gender dimension table as well.

p/s:In the fact table have the CategorID to identified either is company data or individual data.

May I know how to handle this situation in the designing cube and linking between fact table to dimension table in cube as well?

Thanks advance for helpng.

I got same situation. Do you get solution?

Thanks

Lets see if I undersand the question...you have two dimension FKs in your fact table that need to link to the same dimension table "CompanyGender"??? This is a typical scenario in which is handled by creating a "View" from the CompanyGender Table then linking it that way, this is common for "Time" dimensions where the fact table has many date columns.

Raulie