what is the use of merge option in webi reports? explain
with example?
- 2 Answers
- 11231 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 |
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
Explain when to use local filter and when to use global filter?
in xir2 how to send reports to end user
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what is the difference between business requirement document and use case document.
what r the advantages of creating the universe?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
Example of how the fantraps and chasm traps works?
Teradata 
