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
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Difference between b.o 5.1 and 6.1b?
What are the steps to be taken to schedule the report?
What is the dense rank?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is top business?
how to create reports on screech?
what will be the contents for a functional requirements specifications
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 how to execute the plsql procedure from the report by clicking with mouse?
Can anybody tell me what are the tuning problems?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What three things do you consider to be the most important factors for a manager?
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)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
