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 what sort of existing documents should business analysts refer to when starting on a new project?
Explain how many universes can be created in a project?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
can anybody tell me about complicated object you have created
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
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)?
what are the tables used in health care domain project and columns used in report?
What is the difference between business requirement document and use case document.
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain about a time when you discovered a more efficient way to do a work task?
Explain when to use local filter and when to use global filter?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What three things do you consider to be the most important factors for a manager?
Explain the difference between union and group?