I have created a fact table in the warehouse say Prof_fact . In this fact table I do have 2 foreign keys (fk) say Rnd_fk and Bill_fk. These 2 fk can both be mapped to another dim table called Prov_dim.
so basically I want to map both 2 fk(s) in my cube to the same fact table. How do I do that given that I only have one Dimension Prov_dim?
Rnd_fk = Bill_fk= Prov_fk