When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
Answer Posted / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
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.
Explain the difference between detect alias and detect context?
Explain when to use local filter and when to use global filter?
What is report template in b.o?
What are the steps to do to use alerts in bo?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Can Bo generates the Report from the cubical data Explain?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How can you first report in Business Objects by using broadcast agent?
What is Indexing? how did u implement indexing?
how to create metric universe ?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
what is the difference b/w the refresh and buffered data?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?