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.