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 |
How to hide the table s in webi?can any one tell me plzzzzzzzz
5.what is LOV? where it is store?
What are the Input and Output Context Operators.
What is Designer?
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
What is top business?
What is drill across ? can anybody explain me in detail?
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....
HOW MANY TABLES ARE EXISTED IN WEBI REPORT?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is the pivot option ? what is the need of it?
HOW TO HIDE Column in WEBI & DESKI?