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 |
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?
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
What is a bo repository?
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
What is broad cast agent?
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
is there any limit for rows and columns in cross tab
WHO ARE THE USERS OF THE REPOSITORY?
Have you worked with multiple data sources? If yes. How do you link them?
How to open a universe with out using the Designer ??
What is meant by ZABO and FC(full-client)?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,