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 |
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
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
how to restrict null values in webi report?
How were the reports scheduled and how to resolve unexecuted documents?
What is the degenerated Objects?
How do u get requirement from the client? in what format?
What is the drill up , drill down, drill by , drill trough ?
What are the different types of Filters available in BUSINESS OBJECTS?
in sap bi we have wad, then why we go for sap bo
how can i add two different reports in the same document?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
what is difference between global filter an query filter in web intelligence?