Answer Posted / venkatesh
Hi everybody,
whatever NareshKumar explained about the joins is right
except the Shortcut join.
4) Shortcut Joins
Join providing an alternative path between two tables,
bypassing intermediate tables, "leading to the same result,
regardless of direction". Optimizes query time by cutting
long join paths as short as possible.
In the above defination (which is mentioned in the inverted
commas)the result wont be same. It is different.
Example:
There is 4 tables
A,B,C,D
The join in between these 4 tables are like this.
A--B--C--D
Here if I drag A and D tables then I will get 6 rows for
example.
Now Make a shortcut join between A and D
Now if I drag A and D tables then I will get more than 6
rows.Why because
In first join the data is filtering from A to D like below
First A to B then B to C after that C to D.
But in Shortcut there is direct join A to D.Here the data
is not filtering.
Thanks,
Venky
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
how to create reports on screech?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What would you consider as your biggest achievement and why?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can we create universe with no cache??
What is package in BO
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
In banking domain how many Fact tables,Dimension table are present?
Differences between business objects and web intelligence reports?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
what is universe null
What is the profile and package?
Explain is there any other repository domains rather than universe, security, document?