SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Reporting and Planning

Course Outline

Course Content

• Overview of SAP Business Planning and Consolidation Version 11.0
     -Introducing SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA
     -BPC Modeling
• Reporting and Planning with the Web Client
     -Navigating in the Web Interface
     -Using Business Process Flows
• Reporting with the EPM Add-In
     -Introducing the EPM Add-In
     -Creating Ad Hoc Reports in the EPM Add-in with Member Recognition and the EPM Pane
     -Connecting and Configuring the Microsoft Excel Interface of the EPM Add-In
     -Using the EPM Report Editor
     -Using the Member Selector
     -Using the Account Types and the Measures Dimension
     -Linking Reports
     -Generating Worksheets
     -Creating Microsoft Office PowerPoint and Word Reports with the EPM Add-in
• Advanced Reporting with the EPM Add-In for Microsoft Office Excel
     -Formatting Reports with the EPM Formatting Sheet
     -Advanced Formatting
     -Using Local Members
     -Reporting on Multiple Sources
     -Creating Butterfly Reports
     -Analyzing Data with Time-Dependent Hierarchies
     -Using EPM Functions
     -Using Advanced EPM Functions
     -Using the Drill-Through Feature
     -Publishing Workbooks
• Planning with the EPM Add-In for Microsoft Office Excel
     -Explaining the Prerequisites for Input Forms
     -Using Built-in Planning Functions: Disaggregation, Spread, Trend, and Weight
     -Positioning and Using Comments in the EPM Add-In
     -Working with Comments in Web Input Forms
     -Managing Comment Data
• Advanced Planning with the EPM Add-In for Microsoft Office Excel
     -Using the EPMOlapMember for Rolling Forecast Input Forms
     -Executing VBA and API Functions
     -Configuring Distribution and Collection
• Use SAP Analysis for Microsoft Office for BPC and Best Practices
     -Using Delivered Reports
     -Options for Reporting BPC Standard Data
     -Creating Reports Using Best Practices in a End to End scenario