Answer Posted / srikanth
Loop is one of the join path problem that arise when
designing the universe.While setting up joins between
tables,a closed path may occur between set of joins.This
scenario is called Loop.Because of this you will get
incorrect results in report.
You can avoid this problem by creating alias table or
Centext(define path for set of joins to follow)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what are the measure objects?
What Is Snow Flake Schema?
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
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the dense rank?
How to execute the plsql procedure from the report by clicking with mouse?
8. How much supervision have you typically received in your previous job?
what are the day to day activities of BO administrator ?
How many universes can be created in a project?
Can anybody tell me what are the tuning problems?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?