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
- 3425 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
Explain how we drill up week to month?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain how many universes can be created in a project?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
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 are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain the difference between detect alias and detect context?
What is object stores?
Can more than 1 metric be applied on an analytic in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain what would you consider as your biggest achievement and why?
What is the difference between the public object&schema object?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
