Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 63765 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
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What Is The Difference Between Oltp And Olap?
What is the difference between user and versatile user?
Explain what would you consider as your biggest achievement and why?
What are the steps to be taken to schedule the report?
Explain how many universes can be created in a project?
Can we Save (save as) WEBI Doc as DESKI?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What we need to discuss with designer before starting the universe designing.
what is universe null
What is the difference in creating filters in designer and business objects?
What is object stores?
Can Bo generates the Report from the cubical data Explain?
When we use aggregate awareness function in designer?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
