Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain 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)?
Explain in detail about type 1?
Explain what would you consider as your biggest achievement and why?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
what are the tables used in health care domain project and columns used in report?
What is the profile and package?
in sap bi we have wad, then why we go for sap bo
Explain is there any default username & pwd for bo designer & supervisor?
how get the grand total in master-detail report?
how to prepare the documentation in business objects and where to get the requirement?
Explain about alerts in bos, under what situation we need to use alerts?
