SEM200 - Business Warehouse for SEM

Course Version: 052

Duration: 5 days

Delivery Type

• Instructor-led Classroom

Audience

• Consultants
• Controllers
• Project team members

Prerequisites:

Essential

• Basic business knowledge: enterprise management,
• SEM010 Strategic Enterprise Management

Recommended

• SAPFIN mySAP ERP Financials

Goals

• Acquire the fundamentals of BW that are required for working with SEM.
• Develop application scenarios in BW-SEM
• Working with InfoCubes
• Extractions and retractions: BW-SEM SAP system
• Creating queries and their design options for modeling in SEM
• BW-SEM technical integration.
• Modeling basic structures of planning functions and Strategy Management, if they are necessary for the integration analysis.

Course Based on Software Release

• SEM 4.0
• BW 3.5
• ERP ECC 5.0

Content

• Fundamentals of BW and their link with SEM
• Definition of the different types of InfoCubes
• Key figure model and account model in BW
• Implementing scenarios for filling InfoCubes and data retention (current and planned).
• Extracting from SAP Profitability Analysis (CO-PA), Excel upload
• Creating queries and their design options for use in SEM
• Data retraction into SAP CO-PA
• Linking the BW structures with Strategy Management and Performance Measurement
• Developing a simple planning structure
• BW consolidation according to integration aspects

Notes

• This course is intended for participants with no or little knowledge of BW.