what is the use of merge option in webi reports? explain
with example?
- 2 Answers
- 11410 Views
- TCS, I also Faced
- E-Mail Answers
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
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
U r project in which stage in implementation?
Can anybody tell me what are the tuning problems?
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?
Difference between b.o 5.1 and 6.1b?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
is it possible to export the webi reports to crystal reports?with out using businessview?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how to create metric universe ?
Explain about a tricky situation for which you found a very simple solution?
Explain how to schedule the report in b.o?
What we need to discuss with designer before starting the universe designing.
What is a bo repository?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
