Join Issues

building semantic layer
1

Hi Everybody,

                     I have one date key in one dimension and cusomer_origin_datekey,customer_dest_datekey,carrier_origin_datekey,carrier_destination_Datekey these 4 keys in the fact table i have to join the date key with these 4 keys,But if i join i am getting so many loops.

So please any body tell me solution how to solve this issue.

Thanks

Nalin :india: (BOB member since 2008-07-18)

2

you should alias your date table (4 times) and join the aliases to the FACT table.

Also check out the forum FAQ

dessa :madagascar: (BOB member since 2004-01-29)