what is the use of merge option in webi reports? explain
with example?
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 traffic lighting in business objects?
What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
What are the steps to be taken to schedule the report?
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
What is broad cast agent?
What task is 98% of the required work of a business analyst?
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
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
what is fantrap?
Can we create universe with no cache??
draw the architecture of bo