Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Did you face any problems while creating reports? Name? Solutions?

3640


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

959


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

2215


Explain about a tricky situation for which you found a very simple solution?

935


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

981


What is thumbnail?

917


What is the profile and package?

2247


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

922


Explain which versions are used in the bo dashboard work?

1038


Explain the data types present in bo and what happens if we implement view in the designer and report?

957


When we use aggregate awareness function in designer?

907


Explain when to use local filter and when to use global filter?

1301


Can we Save (save as) WEBI Doc as DESKI?

8030


How to open a universe with out using the Designer ??

7449


Which versions are used in the bo dashboard work?

980