title: Business Objects WEBI 3 universes in one report
body: <p>this is bugging me since yesterday and I cannot work it out, hope you can help:</p>
  
  <p>I have a report in Business Objects (I use WEBI interface) which has data being pulled from 3 different universes: universes 1 and 2 have sold qty information per customer number, universe 3 query is just a list of customer numbers and their relevant region. All 3 universes have same customer numbers therefore i merged on that field.
  The first task which i have been able to achieve is: i created a table that checks if there is sold qty for a particular customer in universe 1 then this qty is shown for this customer, if not, show qty for this customer from universe 2.</p>
  
  <p>What i am struggling with is: i need to add the customer region field from the third universe into the same report looking up the customer number and returning the customer region field, however the problem is - there ARE some customer numbers that are missing from the third universe and on adding that field i lose this sold qty entries for this customer from the table completely. However i would like to still see them in a report with "Null" values for the region.</p>
  
  <p>I have searched for a similar solution in different sources across internet, however i couldn't find anything similar(having 3 universes in same report) as all solutions offered cover only 2 universes, which i could have replicated myself if needed.</p>
  
  <p>Is this achievable?</p>