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
any difficulitis have you phase while creating bo reports and how did u solve it
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain is there any default username & pwd for bo designer & supervisor?
Explain what are the steps to do to use alerts in bo?
Explain what are the measure objects?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Which versions are used in the bo dashboard work?
how get the grand total in master-detail report?
Explain about a task that really tested your analytical abilities?
Explain in detail about type 1?
What task is 98% of the required work of a business analyst?
is it possible to export the webi reports to crystal reports?with out using businessview?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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 is xcelsius architecture?