why less number of records in loop?
why more number of records in traps?
Answer Posted / manveer
More no of records in trap because:
For example:
A >- B -< C
( Employees >-- Showroom --< Salary)
- Each showroom has many employees
- Each showroom has many annual salary figures
The number of employee records should not impact the total salary on the report.
If a query is written that spanned all three of those tables the data from table A and C, there would be duplicated and the measure values would be exaggerated. For example,
- X rows on the left
- Y rows on the right
- X * Y rows in the combined set
Less no of records in loop as there is an extra join in a loop, that means one more restriction to the data. That extra join filter out the data and restrict the no of rows retrieved
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between condition & filter?
Explain in detail about type 2(scd),
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Give some information on report bursting?
how to prepare the documentation in business objects and where to get the requirement?
what are the day to day activities of BO administrator ?
What is the difference between business requirement document and use case document.
Explain is there any other repository domains rather than universe, security, document?
What is the functional & architectural differences between business objects and web intelligence reports?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is package in BO
Explain when to use local filter and when to use global filter?
what is the difference b/w the refresh and buffered data?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is Indexing? how did u implement indexing?