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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a universe with out using the Designer ??

6603


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4318


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1570


How we drill up week to month?

617


can anybody tell me about complicated object you have created

2751






how to create reports on screech?

2074


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1619


Explain when we use aggregate awareness function in designer?

582


Can more than 1 metric be applied on an analytic in business objects?

1652


what is universe null

1986


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1616


Explain difference between zabo and webi?

649


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3279


Explain what are the steps to do to use alerts in bo?

609


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

506