how to create multidiemension data model in bw?
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:
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