Prerequisites
To apply for the SAP BPC Training, you need to either:
- Should have basic computer knowledge
- Proficiency in using operating systems like Windows.
- An aspirant should have basic skills in database concepts and SQL.
- Basic programming skills (depending upon the course).
- Aspirants should have good knowledge of SAP software and its various modules.
Module 1: Introduction to SAP BPC
- Overview of SAP BPC
- Defining the Strategy and Road Map
- Exploring the Version history MS 5.1/7.0 & NW 7.0/7.5
- Overview of SAP BPC 10.1 Classic and Unified
- Understanding the modelling aspects in BPC
- Exploring the architecture and terminology(MS 5.1/7.0 & NW7.0/7.5)
Module 2: Environment Setup
- Creating and setup of Environment
- Crating dimensions
- properties & maintaining members(Dimension Management)
- Creating Model & assigning dimensions to Model
Module 3: Data Manager Packages
- Define the DM Package?
- Using standard DM packages
- Customizing standard DM Packages
- Creating DM Packages & Assigning them to the BI Process Chains
Module 4: Security
- Understanding the Security setup
- Exploring the task profile
- Member access profile
- Understanding the users and teams
Module 5: Loading of transaction data
- Understanding the loading transaction data using flat file
- Exploring the loading transaction data from NW BI info cube
- Creating a transformation file & Conversion file
- Using standard data manager packages
- Explain the optimization options
Module 6: Reporting
- Operating with BPC for excel for reporting
- Developing reports using several cell based EPM Functions
- Creating the buttons and assigning macros
- Advanced formatting options using properties
- Exploring the building Complex reports
- Sample Income Statements
- Balance sheet & Trial Balance
- Demonstrate building report reading data from multiple Model’s using EPM
Module 7: BPC for web
- Live Reports
- Publishing
- Distribution and collection wizard
Module 8: Audit reports
- Exploring the BPC Audit
- System landscape and transports
Module 9: Consolidation and planning
- Details of Ownership and Rate Application
- Understanding the Journal Entries
- Understanding the Balance Carry Forward
- Currency Conversion
- Inter-Company Elimination & Matching
- Process Overview
- Exploring the tasks involved in the planning
Module 10: Script logic
- Introduction to script logic
- Defining the Worksheet Logic
- Introduction to Business Rules
Module 11: Conclusion
- Summarize all the points discussed.
