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.
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.