Skip to Content
Author's profile photo Tammy Powlas

Creating Multi-Source Universe with BW and SAP ERP

I finally created this, after listening to suggestions made by SAP’s Ingo Hilgefort

The use case is that you have data in BW you want to report on with data in SAP ERP (that is not loaded to BW).  A great use case would be long text.  That is not my use case here though…read on.

First, in the Information Design Tool, you create a multi-source universe after creating the two connections – one to ECC, and one to BW.


In the next step you select the two secure connections made (one to SAP ERP and other other to SAP BW):


A nice feature in the Information Design Tool is to assign colors to the different connections.


I decide to let green be SAP ERP connection, while orange is for BW.


I am joining an SAP ERP project field with a similar field (InfoObject) back in BW.  I make the connection but the “?” means it has a question about the cardinality.


I select a 1:1 cardinality.


The above shows the next step is creating the Business Layer.


At this point, I confess I obtained several “cartesion product” error messages.  My guess is I need to clean up the business layer a little more in the next round.

After publishing the business layer to the repository, I can now use SAP BusinessObjects Web Intelligence to report against my multi-source universe.


Add the fields to the Query Panel.



The above is a simple Web Intelligence report.  The date field come and the name of the person who changed the object come from ECC.  Total actuals and budget come from BW.

Note I tried to use the READ_TEXT function module (to read long text from ECC) to create a universe against SAP ERP – but because this function module was not remote-enabled, it would not work.  I tried several other things but they did not work.  Perhaps next time.

It is still a good use case if you want to report on something in SAP ERP that isn’t loaded to BW, and want to combine both for a report then the multi-source universe is the way to go.

If you want to learn more on this topic consider joining ASUG at SAP TechEd on October 21st for hands-on BI4.1 Against SAP ERP & BW

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Trond Erik Bones
      Trond Erik Bones

      Hi Tammy, thanks for nice guide ­čÖé

      When I try this and create a Foundation only the ECC/SRP connections are showing, and not the secure BW connection.

      Any ideas?

      Best regards
      Trond Erik

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Trond Erik - I recommend posting this as a question at - please share your version of BI4.x and BW and as many details as possible.  Thank you