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 traffic lighting in business objects?

1 Answers  


What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?

1 Answers   HCL,


WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  


What are the steps to be taken to schedule the report?

1 Answers  


I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers  


What is broad cast agent?

5 Answers  


What task is 98% of the required work of a business analyst?

1 Answers  


can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,


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,


what is fantrap?

2 Answers  


Can we create universe with no cache??

1 Answers  


draw the architecture of bo

0 Answers   IBM,


Categories