why less number of records in loop?
why more number of records in traps?



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

Post New Answer

More Business Objects Interview Questions

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,


Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

1 Answers   CSC,


What is a bo repository?

0 Answers  


IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,


What is broad cast agent?

5 Answers  






In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,


is there any limit for rows and columns in cross tab

4 Answers  


WHO ARE THE USERS OF THE REPOSITORY?

6 Answers   AG Technologies,


Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  


How to open a universe with out using the Designer ??

2 Answers   IBM,


What is meant by ZABO and FC(full-client)?

2 Answers  


what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,


Categories