Interested to Buy Any Domain ? << Click Here >> for more details...
why less number of records in loop?
why more number of records in traps?
- 1 Answers
- 3356 Views
- Wipro, I also Faced
- E-Mail Answers
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 profile and package?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain is there any default username & pwd for bo designer & supervisor?
What is the difference between datawarehousing and businessintelligence?
Can more than 1 metric be applied on an analytic in business objects?
Explain what task is 98% of the required work of a business analyst?
What is a bo repository?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
what are the day to day activities of BO administrator ?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What is the difference between slice and dice and cross tab report?
in sap bi we have wad, then why we go for sap bo
What is object stores?
What is the functional & architectural differences between business objects and web intelligence reports?
What are the steps to do to use alerts in bo?
