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.

If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers  

---

Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

5 Answers   Mind Tree,

---

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

---

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

---

What is the difference between user and versatile user?

0 Answers  

---

use scheduler to refresh report.....explain please.....

2 Answers  

---

Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski

1 Answers  

---

Shall we connect to the oltp systems directly .,

2 Answers   iNautix,

---

What is thin client And thick client..?

2 Answers  

---

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

---