What is shortcut join?could give any one example?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between datawarehousing and businessintelligence?

633


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

612


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

550


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

643


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1586






Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

828


Explain what sort of existing documents should business analysts refer to when starting on a new project?

614


Explain what would you consider as your biggest achievement and why?

588


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

612


What Is Snow Flake Schema?

680


Explain about a task that really tested your analytical abilities?

770


What task is 98% of the required work of a business analyst?

595


When we use aggregate awareness function in designer?

564


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

587


How were the reports scheduled and how to resolve unexecuted documents?

2232