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.

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,

---

How to change the order of prompts in universe?

3 Answers  

---

how to restrict null values in webi report?

2 Answers   InfoStep,

---

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  

---

How to create predefined filters in B.O.

2 Answers   TCS,

---

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

what is prompt? Cascading prompt? Syntax

5 Answers   TCS,

---

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers   Target,

---

What is a join? Explain different types of joins?

5 Answers  

---

Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 Answers  

---

What is meant by ZABO and FC(full-client)?

2 Answers  

---

what is incompactabulity error in sap bo

2 Answers  

---