How to find Data Models for SAP BW InfoCubes

This is the third in a series of data models drawn from the various ERP and CRM systems for which Safyr delivers rapid, accurate and usable metadata.

Previously on this blog we’ve produced a Bill of Materials model from a SAP system and an Accounts Payable model from a JDEdwards EnterpriseOne 9.1 system.

SAP BW InfoCubes are complex and often difficult to understand at the data model level without specialist knowledge.

This model is a bit different. It demonstrates how Safyr can find data models for SAP BW. We show a representation of a Cube from a SAP BW system.

In the terminology of SAP it’s an InfoCube, and this one is the ‘Demo’ cube that comes pre-packaged with the SAP BW system, and as its name implies, is for demonstration purposes.  Finding the data model behind an SAP BW InfoCube is often seen as a challenge if you are not familiar with the structure.

The model was constructed by reverse engineering a BW system into Safyr, and then choosing the Demo cube as the basis for making a model.  Safyr for BW makes it easy to select all the relevant ‘component’ tables of a Cube to be included in the model.

The whole process of choosing a Cube and exporting to our own ER diagrammer visualisation tool or to a modelling environment takes about 5 minutes. It’s available below in PowerDesigner and ERwin formats. I can make it available in other formats for anyone that doesn’t have these tools – just drop me a message via the comments box stating your desired format and I’ll see what I can do.

Here is the legal bit. In no event will Silwood Technology Ltd be liable for any indirect, special or consequential loss arising out of or in any way relating to the use or performance or the use or misuse of the information presented in this model.

Here is the link to the download of themodel in PowerDesigner format: PowerDesigner Cube Model

Here is the link to the download of the ERwin model: ERwin Cube Model

I hope they are useful, please let me know what you think.

Nick Porter

Technology Director