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
What is the profile and package?
What is the difference between datawarehousing and businessintelligence?
Explain is there any default username & pwd for bo designer & supervisor?
Explain about a tricky situation for which you found a very simple solution?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
When to use local filter and when to use global filter?
Explain what three things do you consider to be the most important factors for a manager?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can anybody tell me what are the tuning problems?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is Indexing? how did u implement indexing?
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?