why less number of records in loop?
why more number of records in traps?
Answer / 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 |
what is local filter
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
Explain in detail about type 1?
what r the universe connection types?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
How many built-in objects are created in Business Objects repository?
whats the diff between break and section
What is sdlc in bo?
difference between web intelligence,crystal reports and desktop intelligents
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
What task is 98% of the required work of a business analyst?
what is the core universe and what is the active universe?