Answer Posted / gs2kumar@gmail.com
Short cut join also is a join to avoid the intermediate tables like if we have A,B,C tables joins will be A-->B-->C, here if we need the data from A and C table to join this two tables directly and to resolve the loop we can use shortcut join(A-->C).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What three things do you consider to be the most important factors for a manager?
U r project in which stage in implementation?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between custom hierarchy and report based hierarchy?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
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!!!
how to create metric universe ?
What is a fantrap in business objects?
(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.
What sort of existing documents should business analysts refer to when starting on a new project?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance