When we are going for Shortcut join and why.
Answer Posted / pvraobo@gmail.com
Shortcut join is a join that provides an alternative path between two tables.shortcut join improve the performance of a query by not taking into account intermediate tables.
Note:This is only used per improving the report performance.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain about a time when you discovered a more efficient way to do a work task?
What is the difference between user and versatile user?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is a fantrap in business objects?
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...
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is the dense rank?
What is the difference between the public object&schema object?
in sap bi we have wad, then why we go for sap bo
Explain is there any other repository domains rather than universe, security, document?
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!!!
What sort of existing documents should business analysts refer to when starting on a new project?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN