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
Did you face any problems while creating reports? Name? Solutions?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain about a tricky situation for which you found a very simple solution?
What task is 98% of the required work of a business analyst?
What is thumbnail?
What is the profile and package?
Explain what would you consider as your biggest achievement and why?
Explain which versions are used in the bo dashboard work?
Explain the data types present in bo and what happens if we implement view in the designer and report?
When we use aggregate awareness function in designer?
Explain when to use local filter and when to use global filter?
Can we Save (save as) WEBI Doc as DESKI?
How to open a universe with out using the Designer ??
Which versions are used in the bo dashboard work?