Interested to Buy Any Domain ? << Click Here >> for more details...
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
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain about a tricky situation for which you found a very simple solution?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the join problems comes appart from loop,chasm & fan Traps
Can Bo generates the Report from the cubical data Explain?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is report template in b.o?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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)?
What is the difference between condition & filter?
Explain when to use local filter and when to use global filter?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is package in BO
any difficulitis have you phase while creating bo reports and how did u solve it
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
