Answer Posted / anu
A shortcut join is a join that provides alternate path
between two tables.Shortcut joins improve the performance
of a query by not taking into account intermediate tables,
and so shortening a normally longer join.
A common use of shortcut joins is to link a shared lookup
table to another table further along a join path. The join
path comprises several different tables in the same
context. In such a case, the shortcut join is only
effective when the value being looked up has been
denormalized to lower levels in a hierarchy of tables, so
the same value exists at all the levels being joined.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
how to create metric universe ?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain in detail about type 2(scd),
How would you format some text using css to be verdana and bold?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Difference between b.o 5.1 and 6.1b?
Is there any other repository domains rather than universe, security, document?
(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.
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is the functional & architectural differences between business objects and web intelligence reports?
What is package in BO
Explain the data types present in bo and what happens if we implement view in the designer and report?
How we drill up week to month?