what is the use of merge option in webi reports? explain
with example?
- 2 Answers
- 11203 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is main functional differences between BO and COGNOs?
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
5.what is slowly changing dimension ?
How to link two different universes ?
why less number of records in loop? why more number of records in traps?
How to create Universe using Flat file in BO6.0
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
why we are using derived tables ?how it will help?
Teradata 
