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
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to create Index to the table in the universe designer and how it improves the Query performence
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
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)?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain in detail about type 2(scd),
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
is it possible to export the webi reports to crystal reports?with out using businessview?
How to restrict password to a user while sending a document in .pdf format
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Give some information on report bursting?
What are the steps to do to use alerts in bo?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
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??