Working of Alias

57 Views

Hi All,

i am working on BOXI R2, i have already existed universe with one fact table and many dimensions. there is no loops its working properly. i got new requirement on same universe, added the new table then i got loop. i resolved it by alias.

Existed

Assume tables like Fact F, Dimensions D1 and D2

joins F-- ~~-D1 and F~~ --

D2

New Requirement

new table D3

joins D1--

D3 and D2--

D3

Loop is D3---- D1

F-- ~~-D2~~ -- ~~-D3, i made D3 as alias. i resolved the loop like D3Alias~~
D1
F
D2 -----D3

My question is, if i select the fields from D3 what r the joins are picked.

If I am not clear, i will explain with better example.

Thanks.