What is shortcut join?could give any one example?
Answers were Sorted based on User's Feedback
Answer / s.kumanan
By pass the intermediate tables and give the altenate path
between the two tables is called shortcut join.
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / v.sivakumar
To make it simple short cut joins are used to reduce the
joins in the Query which will increase the performance of
the query
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / vijay
Join provinding an alternative path between 2 tables ,by
passing intermediate table ,leading to the same
result.regardless of direction
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sourabh gosain
Short cut join is a join between 2 tables to improve query
performance. if one face table can be connected to other
fact table to retrieve data, but we are not able to join
that table due to looping problem, then we can connect them
through short cut join. that way join remains invisible for
integrity check. Hence data when selected from 2 tables
comes fast as there is no intermediate table to join them.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sweety
we can have more number of shortcut joins if we change the universe parameter shortcut behavior from successive to global
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhishek
hi all,
Basically the shortcut or smart join are special type of
join by which we can reduce the complexcity of report and
avoid loop like
T1 key1
T2 key2
T3 key3
then in universe there t2 is fac table and t1 an t2
are lookup table then if we want some data frm t3 table by
the foraigan key T1 to T3 then if we creat a simply join
then that is make a loop and aslo that join search the huge
fac table aslo so there is new smart or shortcut join by
which we can join t1 to t3 its show in dotted line in
univeres designer and does not create and loop
Is This Answer Correct ? | 4 Yes | 7 No |
Answer / ashish bhojane
We can have ONLY ONE shortcut join in an Universe.
Is This Answer Correct ? | 3 Yes | 6 No |
hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.
Is This Answer Correct ? | 1 Yes | 6 No |
Where will you find the address of repository in Business Objects?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
what is the difference between bo and cognos?
Tell me about a complicated object you have created?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
How to link one location universe to other location universe
What is the merge dimension?
who r the users in B.O.XIR2?
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??
What is #DATASYNC error how to remove it?
In a context can i get the data from two different factables by using the single data provider?