shortcut join

[Former Member]

Hi

I need to use short cut join in order imorove the performance of the webi report i am using boxir2 version.In report objects coming from more than 2 classes.is it possible to use short cut join in this situation.

Thanks.

[Former Member]

Hope the below link will help you out:

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10ab51df-7964-2b10-7692-93e4dce39277

http://www.dagira.com/2010/05/27/everything-about-shortcut-joins/3/

[Former Member]

see thi link:

[http://www.bidw.org/business-objects/universe-design/shortcut-join-and-its-use-in-business-objects-universe/]

[http://www.infosol.com/bi/techtips/bo_tt9.html]

Thank you

Praveen

[Former Member]

Hi,

We can use shortcut Join in the universe level only. We can't create a shortcut join in Web I.

shortcut join :it is direct join between source and destination.

Table1 joined to

Table2 which is joined to

Table3

if you select a field in tables 1 and 3 then your sql will contain 2joins.

say you have a primary / foriegn key between table 1 and 3, then you could create a shortcut join between the two tables so if the above is selected then your sql will only contain 1 join.

example :country>region.city

we can coneect country and city using shortcut join.

Some of the tips :

http://www.infosol.com/bi/techtips/bott9.html_

All the Best,

Madhu...

[Former Member]

Hi,

Yes, it is possible.

short cut joins are used to improve the query performance at universe level.

Suppose if we have 4 tables A,B,C and D

A->B>C>D and there is a chance to link A->D but we should not link (causes loop) and we need data from the tables A and D then it will get the data in the path A->B>C-->D , it consumes lot of time and resources.

In this case instead of linking A---->D using normal join we should link A and D by using short cut join and this will not create any loop and get the data in the path

A--->D, it consumes less time and resources.

[Former Member]

Hi

I understood the behaviour of shortcut join.can u peoplle pls clarufy me is it possible to apply short sut join when i am going to use objects that r coming from more than 2 classes

Thanks,

[Former Member]

Yes you can create, But there should be some relation like primary foregin key relation between them. I am not sure about your database structre. You can discuss with database admin about the relation and how you would like to join them.