BusinessObjects Board

What will be the best choice ALIAS or CONTEXT.

building semantic layer
#1

Hi Guys,

I have the following joins between the tables and it gave me 9 loops, i would really appreciate if you caould help me solve this.

i am working on a very big universe and a complex one too, what would you recommend Alias or Context for the said problem, and if so, how should i do it.

B.SEGMNT2_IDN = A.ACCOUNT_IDN
AND A.ACCOUNT_KEY >= I.AFF_ACCOUNT_LOW
AND A.ACCOUNT_KEY <= I.AFF_ACCOUNT_HIGH
AND B.SEGMNT3_IDN = C.CENTER_IDN
AND B.SEGMNT3_IDN <= I.AFF_CENTER_HIGH
AND B.SEGMNT5_IDN = M.MODALITY_IDN
AND C.CENTER_KEY >= I.AFF_CENTER_LOW
AND M.MODALITY_KEY = I.AFF_MODALITY

hope the above is clear,
your quick response will be highly appreciated.

wasy.

wasy.wasu :us: (BOB member since 2006-09-18)

#2

Hi, did you read our “sticky” at the top of this forum? If not, please do that. If the answer is not clear, please post your question in that topic rather than starting a new one, so we can keep all of our related discussions in one place.

Thanks. 8)

Dave Rathbun :us: (BOB member since 2002-06-06)