{"id":911,"date":"2015-09-16T19:19:41","date_gmt":"2015-09-17T01:19:41","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=911"},"modified":"2019-04-15T22:19:09","modified_gmt":"2019-04-16T04:19:09","slug":"how-to-merge-data-from-multiple-data-providers-in-webintelligence-webi","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/how-to-merge-data-from-multiple-data-providers-in-webintelligence-webi\/","title":{"rendered":"How to Merge Data from Multiple Data Providers in WEBIntelligence (webi)"},"content":{"rendered":"

Data Synchronization in Context<\/strong><\/p>\n

Reporters are often asked to put together silo data sources eg Name and department with business data like number of sales this month.\u00a0 We develop queries\/ Data providers (DP) per data source and put them in a report. The universe tool “Universe Design Tool” A.K.A “designer” classic would only connect to one data source.\u00a0 The “Information Design Tool” will now allow multiple connections and overcome this previous limitation.<\/p>\n

At the report level will now contain all the data in one place using multiple data providers, these DP often sourcing data from multiple universes.\u00a0 There are 3 ways to do Data Synchronization<\/strong>, ie putting the data together in the context using a webi report.<\/p>\n

    \n
  1. Full outer Join – seeing data from both DP’s<\/li>\n
  2. Left outer Join – mainly data from the left DP<\/li>\n
  3. Right outer Join – mainly data from the right DP<\/li>\n<\/ol>\n

    Merge Dimension<\/strong> Concept is based on the common dimension in each data provider that relates the 2 or more data sets.\u00a0 It is this merged Dimension that will bring the data sets together acting like a foreign key.<\/p>\n

    Follow these steps if editing a report that already contains the Data providers in bi4.<\/p>\n

    STEP1: Press “Design” button >> “Data Access” tab<\/p>\n

    STEP2: Under “Data Objects” >> press “Merge” >> select 2 or more dimensions that relate the data sets together from modal form. >> OK<\/p>\n

    OR in the dimension Panel >> Right-click on objects that relates the 2 data sets, and select Merge<\/p>\n

    \"mergeddimension1\"<\/a>\"mergeddimension2\"<\/a><\/p>\n

     <\/p>\n

     <\/p>\n

    STEP3: Create variables of type “detail” and click the button on Associated Dimension box and ensure you select the dimension under the “Merged Dimension” section created in step2<\/p>\n

    \"mergeddimension3\"<\/a>\"mergeddimension4\"<\/a><\/p>\n

    STEP4: Add all objects to the report form Data provider 1 plus the detail variables built form Data provider 2.\"mergeddimension5\"<\/a><\/p>\n

    Repeat STEPS1 -STEPS4 for as many variables that you need to merge in the report.<\/p>\n

    PS<\/p>\n

    All details objects are expected to have a one to one relationship with the merged dimension.\u00a0 This is the definition of a detailed object.<\/p>\n

     <\/p>\n

    Stephen Choo Quan<\/p>\n

    Thanks for reading \u2764<\/strong><\/p>\n

    \n

    Follow me\u00a0On:\u00a0Instagram<\/a>\u00a0|\u00a0Facebook<\/a>\u00a0| Linked in<\/a><\/strong><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Data Synchronization in Context Reporters are often asked to put together silo data sources eg Name and department with business data like number of sales this month.\u00a0 We develop queries\/ Data providers (DP) per data source and put them in a report. The universe tool “Universe Design Tool” A.K.A “designer” classic would only connect to […]<\/p>\n","protected":false},"author":2,"featured_media":1891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[10,34,35],"class_list":["post-911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-business-objects","tag-business-intelligence","tag-webi","tag-webintelligence"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2015\/09\/mergedDimension3.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=911"}],"version-history":[{"count":5,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"predecessor-version":[{"id":5495,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/911\/revisions\/5495"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/1891"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}