1 Reply Latest reply: Sep 25, 2012 7:31 PM by Nasar-Oracle RSS

    Need help in creating alias table, apart from using same table again.

    user12116294
      Hi All,

      I have one problem in which one fact has many wid's and these all fact wid's connect with the single dimension.

      As per me I can create alias of the dimension and join them with fact.

      Fact1
      x1-wid joins with xx1 wid of dimension1
      x2 wid joins with xx2 wid of dimension1
      x3 wid joins with xx3 wid of dimension1

      as per me we can we can create the alias of dimension 1 and join with them.

      But it will take time, is there any other way to achive it kindly suggest.


      Thanks