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

What Is The Difference Between Oltp And Olap?

0 Answers   Informatica,

---

What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

Can we configure two instances of CMS pointing to two different CMS system databases?

0 Answers  

---

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers   Nucleus Software,

---

Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,

---

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

difference between xir2 and 6.5 version

4 Answers  

---

WHAT IS CARDINALITIES OF JOIN?

3 Answers  

---

What is the slice and dice?

3 Answers  

---

How do scheduling the report in BO XIR2? can you say what are they steps?

5 Answers  

---