2.What is loop? How resolve the loop?explain it?
Answer Posted / stalin
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
1.Aliasing
2.Context
3.Short cut join
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
Short cut join will also resolve the loops
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datawarehousing and businessintelligence?
What is aggregate table and aggregate fact table ... Any examples of both?
what will be the contents for a functional requirements specifications
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
how to prepare the documentation in business objects and where to get the requirement?
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 if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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 package in BO
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
How can you first report in Business Objects by using broadcast agent?
What is the difference between slice and dice and cross tab report?
In banking domain how many Fact tables,Dimension table are present?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain how we drill up week to month?