Skip to Content
0
Former Member
Nov 10, 2011 at 05:25 AM

Working of Alias

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