SHORTCUT JOIN

building semantic layer
1

Hi experts,

I have the following table structure

                    A<........B.........>C

if i join A and C using a short cut join is it going to be a many to many relation between A and C and if so is it a problem. if its a problem how to overcome it.

thanks,
bharad[/img]

kbharadbo (BOB member since 2009-05-19)

2

Are the joins from B to C and B to A one-to-many with B being on the one side? If so, then you can’t build a shortcut as it would result in a many-to-many relationship.

As to how to fix it, there really isn’t a fix. You can’t make up a relationship that doesn’t exist.

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

3

Dave thank you very much!

Dave I have the following situation.

I have a 3NF model on which i have to build some reports on. At the most the join complexity is as shown above. Do you think building a universe and reporting off of it would result in poor performance of reports. There are a lot of tables in the model but i use only a few for the reporting though.

kbharadbo (BOB member since 2009-05-19)

4

Bydefining alias and context you can overcome this problem.

Rakesh_K :india: (BOB member since 2007-12-11)