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


Please Help Members By Posting Answers For Below Questions

Explain what are the measure objects?

549


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...

1723


Explain how to execute the plsql procedure from the report by clicking with mouse?

598


Explain is there any default username & pwd for bo designer & supervisor?

593


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)?

575






Can we create universe with no cache??

1956


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?

545


how to create metric universe ?

1895


Explain difference between zabo and webi?

651


Explain what is the difference between business requirement document and use case document.

577


What is the functional & architectural differences between business objects and web intelligence reports?

554


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...

1623


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

681


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

598