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 is the difference between the public object&schema object?

0 Answers  

---

Report have 10000 records,how to restrict the end user to 1000 Records?

6 Answers  

---

Explain what are the measure objects?

0 Answers  

---

How can we acheive Correlated sub-query in Designer?

2 Answers   Infosys, TCCX, Wells Fargo,

---

Explain how to schedule the report in b.o?

0 Answers  

---

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

What is the difference between datawarehousing and businessintelligence?

0 Answers  

---

why we use aggregation in lower level

1 Answers   TCS,

---

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,

---

What is the difference between slice and dice and cross tab report?

0 Answers  

---

What services the broadcast agent offers on the server side?

2 Answers   TCS,

---

How many ways you can restrict data in business objects?

5 Answers   TCS,

---