2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 60393 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / rahul tandon
Loop is a situation in the BO universe design process. A
circular path of joins is formed between the tables. The
SQL queries are not able to interpret the joins; this
results in the wrong results from the queries; often less
records are retrieved than the actual number of records.
A loop situation can be resolved by Aliases and Contexts.
Make sure to break the joins(circular path) by aliasing the
table(dimension table) which has 1n's coming out of it from
both the end. The path then gets broken and ends as two
different path, one ending at the original dimension table
and the other at the aliased table(of that dimension). Both
of the paths now convey a differnt business case scenario
and depending upon the scenario a particlar path(query has
to be fired).
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is top business?
how to prepare the documentation in business objects and where to get the requirement?
any difficulitis have you phase while creating bo reports and how did u solve it
When to use local filter and when to use global filter?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the dense rank?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain what would you consider as your biggest achievement and why?
Explain about alerts in bos, under what situation we need to use alerts?
Difference between b.o 5.1 and 6.1b?
Can we Save (save as) WEBI Doc as DESKI?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain about a time when you discovered a more efficient way to do a work task?
Is there any other repository domains rather than universe, security, document?
