Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 64249 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
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
how to create metric universe ?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain when to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
how to create reports on screech?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
what is universe null
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Is there any other repository domains rather than universe, security, document?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What is the difference between the public object&schema object?
What is thumbnail?
What sort of existing documents should business analysts refer to when starting on a new project?
