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
How can you first report in Business Objects by using broadcast agent?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How to open a universe with out using the Designer ??
in sap bi we have wad, then why we go for sap bo
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Can Bo generates the Report from the cubical data Explain?
Explain which versions are used in the bo dashboard work?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain the data types present in bo and what happens if we implement view in the designer and report?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What is difference between custom hierarchy and report based hierarchy?
What is the difference between absolute and relative div positioning?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
