This discussion is archived
1 Reply Latest reply: Sep 25, 2012 5:31 PM by Nasar RSS

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

user12116294 Journeyer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points