1 Reply Latest reply: Jun 4, 2013 10:41 AM by Nasar-Oracle RSS

    How to reuse one dimension in the same awm cube

      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