Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 63753 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / vidya
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose
in a loop.
•BO prompts the user to indicate the correct perspective
(relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an
alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to
it
| Is This Answer Correct ? | 66 Yes | 4 No |
Post New Answer View All Answers
Explain when to use local filter and when to use global filter?
(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.
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 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?
what is universe null
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 sort of existing documents should business analysts refer to when starting on a new project?
What would you consider as your biggest achievement and why?
Explain how we drill up week to month?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
how get the grand total in master-detail report?
How can you first report in Business Objects by using broadcast agent?
What is a fantrap in business objects?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
