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 are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---

can anybody tell me about issues faced while creating reports

3 Answers   Accenture,

---

I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?

3 Answers   BirlaSoft,

---

Why do we need metrics and sets?

1 Answers  

---

can BO generate reports with out CUBICAL data to repository?

4 Answers  

---

What are the security level used in BO?

6 Answers   Oracle,

---

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

---

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 Answers  

---

Can i merge two dataproviders if they do not have common column?

3 Answers  

---

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

---

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

0 Answers  

---

what is diff between webi,deski,infoview

2 Answers  

---