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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what are the measure objects?
Can more than 1 metric be applied on an analytic in business objects?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What task is 98% of the required work of a business analyst?
What is a fantrap in business objects?
How to generate the report from excel sheet?
Explain how we drill up week to month?
When to use local filter and when to use global filter?
Explain about a task that really tested your analytical abilities?
In banking domain how many Fact tables,Dimension table are present?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Is there any other repository domains rather than universe, security, document?