1 Reply Latest reply on Jun 4, 2013 3:41 PM by nasar.ali-khan at -Oracle

    How to reuse one dimension in the same awm cube

    1001997
      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

      Thanks