Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of merge option in webi reports? explain
with example?
- 2 Answers
- 12194 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
8. How much supervision have you typically received in your previous job?
Explain how we drill up week to month?
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...
Explain what task is 98% of the required work of a business analyst?
Explain what would you consider as your biggest achievement and why?
What is the difference between slice and dice and cross tab report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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?
Can you please send me the migration related issues .
Explain when to use local filter and when to use global filter?
(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.
How to create Index to the table in the universe designer and how it improves the Query performence
What is the difference between absolute and relative div positioning?
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.
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
