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.