Answer / sathish arichandran

Merge option used for fetching more than one data providers
information into single report or block.

For example, employee information is available in different
database like some of the information in oracle and some of
information in sql server. But you need all these info into
single report. In that time merge dimension option is used
to achieve this task.

You need to create two universe(data provider) for each data
source and then u can merge the two data provider with
common dimension field. One thing important is u can merge
only the dimension object not measure object

In dimension object should be in same data type in both data
source. ex emp no should be number or varchar. mismatched
data type will give error.

Answer / simha

we can use merge option in webi, as like syncronization in 6.5
EX: if u open one Dp & generates the report after u select
another Dp u can link with in 2Dps same containg objects
like In 1st DP(Year,Q,Country,revenue),In 2nd
DP(Year,Q,quantity sold). --> Click Merge Option -->
automatically merge same type of dia objects.It is generated
in one report.

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---

limitaions of cross tab ?

1 Answers  

---

Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier

2 Answers  

---

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

---

When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,

---

what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  

---

How to sheduling the report ? What is the need of it?

2 Answers   Infotech,

---

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,

---

Draw the architecture of traps?

3 Answers   Wipro,

---

what is projection function in SAP BO

1 Answers   Cap Gemini,

---