What are the difference between merge,auto merge and extended merge ?
Answer Posted / amardip
1. Merge : Merge is used to join two datasources in webi.it is like a inned join.It will fetch only matching records from two providers
2. Auto merge : If we checked this option from document properties , it will automatically merges the common dimension from two datasources in webi
3. extended merge : We need to select the document property to enable extended merge.It is like full outer join.It will bring all objects from two dataprovides in webi
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are the measure objects?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain is there any default username & pwd for bo designer & supervisor?
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)?
Can we create universe with no cache??
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 to create metric universe ?
Explain difference between zabo and webi?
Explain what is the difference between business requirement document and use case document.
What is the functional & architectural differences between business objects and web intelligence reports?
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 about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?