Showing results for 
Search instead for 
Did you mean: 

sap bw

Former Member
0 Kudos

hi experts

how to create multidiemension data model in bw?

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos


this would be the document that you need to go through.

/docs/DOC-8189#section2 [original link is broken]

Multi-Dimensional Modeling with SAP NetWeaver BI

Modeling the Data Warehouse Layer with BI


Message was edited by:

Arun Varadarajan

Former Member
0 Kudos


following are few steps to creat muitidimensional model in bw,

1. Focus on the structure of information

Develop a complete understanding of the underlying business processes. Create an Entity Relationship

Model (ERM) of the business process

The ERM as a function of the information

2. Focus on analytical needs - Overcome model complexity

Create a valid data model. Translate the ERM to the Multi-Dimensional Model (MDM) / Star schema

The MDM as a function of the analytical processing

3. Build the solution as a part of an integrated data warehouse

The Star schema on the BI stage are the InfoCubes. Translate the MDM / Star schema to one or more