Skip to Content

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.

/wp-content/uploads/2013/09/1df_271779.jpg

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

/wp-content/uploads/2013/09/2twoconnections_271780.jpg

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

/wp-content/uploads/2013/09/3colors_271808.jpg

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

/wp-content/uploads/2013/09/4colorsfact_271809.jpg

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.

/wp-content/uploads/2013/09/5cardinality_271810.jpg

I select a 1:1 cardinality.

/wp-content/uploads/2013/09/6businesslayer_271811.jpg

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

/wp-content/uploads/2013/09/7businesslayerquery_271812.jpg

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.

/wp-content/uploads/2013/09/8universewebi_271813.jpg

Add the fields to the Query Panel.

9QUERYPANEL.jpg

/wp-content/uploads/2013/09/10webi_271815.jpg

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

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

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

    (0) 
  2. Tammy Powlas Post author

    Hi Trond Erik – I recommend posting this as a question at answers.sap.com – please share your version of BI4.x and BW and as many details as possible. ┬áThank you

    (0) 

Leave a Reply