26 de Junho de 2017 a 30 de Junho de 2017

SAP Business Planning and Consolidation: Reporting and Planning

SAP Portugal

  • Localidade Lisboa - Porto Salvo
  • Contacto Website
  • Horário Laboral
  • Duração 35h
  • Tipo Presencial / Certificado
  • Preço €3 600

Course announcements

  • Participants of this class will learn all of the key reporting skills and some planning skills that apply to both the SAP Business Planning and Consolidation, version for SAP NetWeaver and version for the Microsoft platform. In the EPM add-in you will learn how to use the report editor, local members, and formatting. You will learn advanced reporting skills that include VBA, and advanced EPM functions. Learn how to work with comments, and how to publish results in various formats.

Goals

  • Report in the Excel Interface of the EPM add-in.
  • Report in the Web Client.
  • Use business process flows for reporting.

Prerequisites

Essential

  • Experience with Excel

Content

  • Overview of SAP Business Planning and Consolidation
    • Introducing SAP Business Planning and Consolidation
    • Using the Microsoft Excel Interface of the EPM Add-In
    • Connecting and Configuring the Microsoft Excel Interface of the EPM Add-In
  • Basic Report Building in Microsoft Excel
    • Creating Reports with the EPM Report Editor
    • Using the Member Selector
    • Sorting, Filtering, and Ranking Data
    • Using Read Only, Member Names, and Insertion Filtering
    • Using Account Types and the Measures Dimension
    • Using Member Recognition
    • Using Local Members in a Plan Actual Variance Analysis
  • Enhancements to Microsoft Excel Reports
    • Linking Reports
    • Formatting Reports
    • Reporting on Multiple Sources
    • Reporting by Using Axis Sharing
    • Generating Worksheets
    • Analyzing Data with Time Dependent Hierarchies
  • Report Functions
    • Creating Cell-Based Reports with Functions
    • Creating Cell-Based Reports with Advanced Functions
    • Using the EPMOlapMemberO Function
    • Executing VBA and API Functions
  • Delivered Templates
    • Using Delivered Templates
    • Creating Reports Using Best Practices
  • Everest Data Range Exchange (EvDRE) Reports
    • Comparing EvDRE to EPM Reports
    • Migrating EvDRE Templates
  • Distribution and Collection of Input Schedules
    • Configuring Distribution and Collection
    • Distributing and Collecting Workbooks
    • Comments in SAP Business Planning and Consolidation
    • Describing the Comment Functionality in SAP Business Planning and Consolidation
    • Entering Comments with the EPM Ribbon
    • Managing Comment Data
  • The EPM Add-in Planning Functions
    • Using The Spread, Trend, and Weight Planning Functions
    • Using Disaggregation
  • Business Process Flows (BPFs)
    • Positioning Business Process Flows (BPFs)
    • Using Reporting Business Process Flows (BPFs)
  • Web Interface in SAP Business Planning and Consolidation
    • Navigating in the Web Interface
    • Creating Web Reports, Input Forms, and Workspaces
    • Publishing Books
  • Drill Through
    • Positioning Drill Through
    • Creating Drill Through for Web Sites
    • Creating a Drill Through for BW Queries
    • Creating Drill Through for SAP ERP
  • Microsoft Word and Microsoft PowerPoint Reports with Live Data
    • Creating Reports with Microsoft Word and Microsoft PowerPoint
  • Dashboards
    • Creating a Dashboard

Para mais informação sobre datas, contacte [email protected]