BPC430 SAP Business Planning and Consolidation: Reporting and Planning

Displaying courses for United States [Change]

Overview

In this course, students 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.

Objectives

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

Audience

The primary audience for this course are Application Consultants, Business Process Owners/Team Leads/Power Users, and Program/Project Managers.

Syllabus

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

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Enterprise resource planning
United States
This skill has an average salary of
US$86,984
and is mentioned in
2.14%
of job ads in this area.
Analysis
United States
This skill has an average salary of
US$82,684
and is mentioned in
25.05%
of job ads in this area.
Microsoft Exchange Server
United States
This skill has an average salary of
US$74,820
and is mentioned in
1.92%
of job ads in this area.
Visual Basic for Applications
United States
This skill has an average salary of
US$91,264
and is mentioned in
0.36%
of job ads in this area.