what is the use of merge option in webi reports? explain
with example?

Answers were Sorted based on User's Feedback



what is the use of merge option in webi reports? explain with example?..

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.

Is This Answer Correct ?    13 Yes 0 No

what is the use of merge option in webi reports? explain with example?..

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.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Business Objects Interview Questions

what is optional prompt in boxi r2

4 Answers   Mind Tree,


how to create metric universe ?

0 Answers   TCS,


in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,


How to make alternative rows red and green in WebI Report?

3 Answers   Accenture, Mphasis,


what is drill down?

5 Answers   TCS,






HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  


1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,


Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,


What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,


How to schedule the report in b.o?

0 Answers  


WHAT IS SAP BO AND BO?

1 Answers  


What are @FUNCTION?

4 Answers  


Categories