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
- 3481 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 top business?
How to generate the report from excel sheet?
Explain what is the difference between slice and dice and cross tab report?
Can we create universe with no cache??
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?
can anybody tell me about complicated object you have created
Can anybody tell me what are the tuning problems?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is the difference between slice and dice and cross tab report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what are the steps to be taken to schedule the report?
Can we Save (save as) WEBI Doc as DESKI?
Did you face any problems while creating reports? Name? Solutions?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Can Bo generates the Report from the cubical data Explain?
