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
Explain difference between zabo and webi?
any difficulitis have you phase while creating bo reports and how did u solve it
What is the difference between slice and dice and cross tab report?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain the difference between detect alias and detect context?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What Is Snow Flake Schema?
is it possible to export the webi reports to crystal reports?with out using businessview?
Can we Save (save as) WEBI Doc as DESKI?
When we use aggregate awareness function in designer?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How to restrict password to a user while sending a document in .pdf format