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

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

Contents

  • 11.0
  • Lesson: Introducing SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA Lesson: BPC Modeling

Unit 2: Reporting and Planning with the Web Client

  • Lesson: Navigating in the Web Interface
  • Lesson: Using Business Process Flows

Unit 3: Reporting with the EPM Add-In

  • Lesson: Introducing the EPM Add-In
  • Lesson: Creating Ad Hoc Reports in the EPM Add-in with Member Recognition and the EPM Pane
  • Lesson: Connecting and Configuring the Microsoft Excel Interface of the EPM Add-In
  • Lesson: Using the EPM Report Editor
  • Lesson: Using the Member Selector
  • Lesson: Using the Account Types and the Measures Dimension
  • Lesson: Linking Reports
  • Lesson: Generating Worksheets
  • Lesson: Creating Microsoft Office PowerPoint and Word Reports with the EPM Add-in

Unit 4: Advanced Reporting with the EPM Add-In for Microsoft Office Excel

  • Lesson: Formatting Reports with the EPM Formatting Sheet
  • Lesson: Advanced Formatting
  • Lesson: Using Local Members
  • Lesson: Reporting on Multiple Sources
  • Lesson: Creating Butterfly Reports
  • Lesson: Analyzing Data with Time-Dependent Hierarchies
  • Lesson: Using EPM Functions
  • Lesson: Using Advanced EPM Functions
  • Lesson: Using the Drill-Through Feature
  • Lesson: Publishing Workbooks

Unit 5: Planning with the EPM Add-In for Microsoft Office Excel

  • Lesson: Explaining the Prerequisites for Input Forms
  • Lesson: Using Built-in Planning Functions: Disaggregation, Spread, Trend, and Weight
  • Lesson: Positioning and Using Comments in the EPM Add-In
  • Lesson: Working with Comments in Web Input Forms
  • Lesson: Managing Comment Data

Unit 6: Advanced Planning with the EPM Add-In for Microsoft Office Excel

  • Lesson: Using the EPMOlapMember for Rolling Forecast Input Forms
  • Lesson: Executing VBA and API Functions
  • Lesson: Configuring Distribution and Collection

Unit 7: Use SAP Analysis for Microsoft Office for BPC and Best Practices

  • Lesson: Using Delivered Reports
  • Lesson: Options for Reporting BPC Standard Data
  • Lesson: Creating Reports Using Best Practices

Course Overview

TARGET AUDIENCE

This course is intended for the following audiences:

  • Application Consultant
  • Business Process Owner/Team Lead/Power User
  • Program/Project Manager

 

Unit 1 Overview of SAP Business Planning and Consolidation Version 11.0

Lesson 1: Introducing SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA

Lesson Objectives

After completing this lesson, you will be able to:

  • Introduce SAP Business Planning and Consolidation, version 11.0 for SAP BW/4HANA

Lesson 2: BPC Modeling

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe BPC dimensions
  • Discuss models

 

Unit 2 Reporting and Planning with the Web Client

Lesson 1: Navigating in the Web Interface

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the HTML5 Web Interface

Lesson 2: Using Business Process Flows

Lesson Objectives

After completing this lesson, you will be able to:

  • Introduce Business Process Flows

 

Unit 3 Reporting with the EPM Add-In

Lesson 1: Introducing the EPM Add-In

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the EPM add-in

Lesson 2: Creating Ad Hoc Reports in the EPM Add-in with Member Recognition and the EPM Pane

Lesson Objectives

After completing this lesson, you will be able to:

  • Create ad hoc reports in the EPM add-in with Member Recognition and the EPM Pane

Lesson 3: Connecting and Configuring the Microsoft Excel Interface of the EPM Add-In

Lesson Objectives

After completing this lesson, you will be able to:

  • Enable the EPM add-in
  • Create EPM connections

Lesson 4: Using the EPM Report Editor

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the EPM Report Editor
  • Use read only, member naming, and insertion filtering
  • Explan the sort, filter, and rank option in the Report Editor

Lesson 5: Using the Member Selector

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the Member Selector

Lesson 6: Using the Account Types and the Measures Dimension

Lesson Objectives

After completing this lesson, you will be able to:

  • Use Account Types and Measures

Lesson 7: Linking Reports

Lesson Objectives

After completing this lesson, you will be able to:

  • Define Quick Links

Lesson 8: Generating Worksheets

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe How to Generate Worksheets

Lesson 9: Creating Microsoft Office PowerPoint and Word Reports with the EPM Add-in

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain the EPM add-in for Microsoft Office PowerPoint and Word

 

Unit 4 Advanced Reporting with the EPM Add-In for Microsoft Office Excel

Lesson 1: Formatting Reports with the EPM Formatting Sheet

Lesson Objectives

After completing this lesson, you will be able to:

  • Create an EPM Formatting Sheet

Lesson 2: Advanced Formatting

Lesson Objectives

After completing this lesson, you will be able to:

  • Scale with the EPM Formatting Sheet

Lesson 3: Using Local Members

Lesson Objectives

After completing this lesson, you will be able to:

  • Define Local Members

Lesson 4: Reporting on Multiple Sources

Lesson Objectives

After completing this lesson, you will be able to:

  • Create reports on different Models in the same worksheet
  • Create Reports on a BPC Model and a BW Query

Lesson 5: Creating Butterfly Reports

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain how to meet reporting requirements with axis sharing

Lesson 6: Analyzing Data with Time-Dependent Hierarchies

Lesson Objectives

After completing this lesson, you will be able to:

  • Analyze data with time dependent hierarchies

Lesson 7: Using EPM Functions

Lesson Objectives

After completing this lesson, you will be able to:

  • Create cell-based reports with EPM functions

Lesson 8: Using Advanced EPM Functions

Lesson Objectives

After completing this lesson, you will be able to:

  • Use EPM functions to override report items
  • Use EPM functions to retrieve dimension and member property data
  • Summarize the most important functions

Lesson 9: Using the Drill-Through Feature

Lesson Objectives

After completing this lesson, you will be able to:

  • Position the drill-through feature
  • Drill through to a Web site
  • Drill through to a BW Query
  • Drill through to ECC

Lesson 10: Publishing Workbooks

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe book publication

 

Unit 5 Planning with the EPM Add-In for Microsoft Office Excel

Lesson 1: Explaining the Prerequisites for Input Forms

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe prerequisites for Input Forms

Lesson 2: Using Built-in Planning Functions: Disaggregation, Spread, Trend, and Weight

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe spread, trend, and weight
  • Explain disaggregation

Lesson 3: Positioning and Using Comments in the EPM Add-In

Lesson Objectives

After completing this lesson, you will be able to:

  • Position and use comments in the EPM add-in

Lesson 4: Working with Comments in Web Input Forms

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain the Web Input Form Comment Features

Lesson 5: Managing Comment Data

Lesson Objectives

After completing this lesson, you will be able to:

  • Copy and Delete Comments

 

Unit 6 Advanced Planning with the EPM Add-In for Microsoft Office Excel

Lesson 1: Using the EPMOlapMember for Rolling Forecast Input Forms

Lesson Objectives

After completing this lesson, you will be able to:

  • Discuss the EPMOlapMember function

Lesson 2: Executing VBA and API Functions

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain how to create pushbuttons
  • Describe how to create and use a Planning LaunchPad with API functions

Lesson 3: Configuring Distribution and Collection

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain distribution templates

 

Unit 7 Use SAP Analysis for Microsoft Office for BPC and Best Practices

Lesson 1: Using Delivered Reports

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the delivered templates

Lesson 2: Options for Reporting BPC Standard Data

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain Options for BPC Reporting

Lesson 3: Creating Reports Using Best Practices

Lesson Objectives

After completing this lesson, you will be able to:

  • Discuss the reporting best practices

Submit your request

Is the course not scheduled? Let us know what works for you by clicking the button below and select your Interest. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom

Register Interest

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

Very Helpfull

User Rating: Be the first one !

Related Courses

  • BPC450 – SAP Embedded Business Planning and Consolidation 11.0 version for SAP BW/4HANA BPC450 SAP Embedded Business Planning and Consolidation 11.0 version for SAP BW/4HANA Contents Course Overview Unit 1: Overview of BPC11.0 Embedded Lesson: Positioning BPC11.0, Discussing Key Terms and Components Lesson: Describing BPC Implemention Options Lesson: Introducing SAP HANA Lesson: Introducing BW and How it is Used for Planning Unit 2: Planning with BPC11.0 Embedded Lesson: Configuring advanced DataStore Objects for Planning Lesson: Designing Data Acquisition Solutions for Planning Scenarios Lesson: Designing CompositeProviders for […]
  • S4F95 – Business Consolidation with SAP Group Reporting S4F95 SAP S/4HANA Finance for Group Reporting and Consolidation Contents Course Overview Unit 1: Business Consolidation with SAP Group Reporting Overview Lesson: Describing the Key Terms, Features, and Architecture Lesson: Running Consolidation Tasks Lesson: Implementing SAP S/4HANA Finance for group reporting Unit 2: Master Data and Structures Lesson: Describing the Structures Lesson: Explaining Global Settings, Ledger, COA, Versions, and Architecture Lesson: Managing Breakdown Categories and Subitems Lesson: Managing Cons Groups and Units […]
  • BPC410 – SAP Business Planning and Consolidation 10.1, version for the Microsoft platform: Administration | SAP TRAINING COURSES BPC410SAP Business Planning and Consolidation 10.1, version for the Microsoft platform: AdministrationSolution:SAP BusinessObjectsLevel:Details, Configuration & TransactionLanguages:EnglishGoalsSet up and manage a SAP Business Planning and Consolidation environment as application administrator.AudienceApplication AdministratorsApplication ConsultantsPre-Sales ConsultantsProject LeadersProject Team MembersPrerequisitesEssentialExperience with financial applications and systems.Experience with Microsoft Excel.RecommendedPlanning experienceCourse based on software releaseSAP […]
  • JOY054 – openSAP – Reporting with SAP Business ByDesign Level:Details, Configuration & Transaction Languages:English
  • S4F80 – SAP BPC optimized for SAP S/4HANA S4F80 SAP BPC Optimized for SAP S/4HANA Contents Course Overview Unit 1: Overview of SAP BPC for S/4HANA Lesson: Describing SAP HANA Technology Lesson: Positioning SAP S/4HANA Lesson: Explaining SAP BPC Optimized for SAP S/4HANA Lesson: Showing what is in SAP BPC S/4HANA Lesson: Setting up SAP BPC for SAP S/4HANA Finance and Embedded BW Reporting Unit 2: Data Structures Lesson: Explaining Master Data Structures Lesson: Showing Actual Data Structures Lesson: Describing Plan Data Structures Lesson: Depicting Retraction Structures Lesson: […]
  • BPC440 – SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Consolidation BPC440 SAP Business Planning and Consolidation: Consolidation Contents Course Overview Unit 1: SAP Business Planning and Consolidation Overview Lesson: Describing SAP Business Planning and Consolidation Lesson: Running Consolidation Tasks Lesson: Implementing the BPC Standard Consolidation Solution Unit 2: Modeling Consolidation Structures and Reporting Lesson: Configuring Environments and Dimensions Lesson: Creating Models for Consolidation Lesson: Creating a Report in the EPM Add-for Excel Lesson: Options for Reporting BPC Standard Data Unit 3: […]
  • BPC420 – SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Administration and Planning BPC420 SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Administration and Planning Configuration Contents Course Overview Unit 1: Overview and Architecture Lesson: Discussing the Overview and Architecture Lesson: Describing BPC Components Unit 2: Configuration Lesson: Creating an Environment Lesson: Designing and Managing Dimensions Lesson: Designing and Managing Models Lesson: Designing and Maintaining Security Lesson: Defining Administration Parameters Unit 3: Data Analysis with the EPM Add-In Lesson: Connecting to […]
  • BPC430 – SAP Business Planning and Consolidation: Reporting and Planning | SAP TRAINING COURSES BPC430SAP Business Planning and Consolidation: Reporting and PlanningSolution:SAP BusinessObjectsLevel:Basic Processes & FoundationLanguages:EnglishGoalsReport in the Excel Interface of the EPM add-in.Report in the Web Client.Use business process flows for reporting.AudienceApplication ConsultantBusiness Process Owner / Team Lead / Power UserProgram / Project ManagerPrerequisitesEssentialExperience with ExcelRecommendedExperience with OLAP productsCourse based on software releaseBPC 10.1 NW Standard Model SP5SAP BW 7.4 SPS10HANA SPS9EPM add-in SP21Design Studio 1.4Analysis for […]
  • BPC43E – SAP Business Planning and Consolidation: Reporting and Planning | SAP TRAINING COURSES BPC43ESAP Business Planning and Consolidation: Reporting and PlanningSolution:SAP BusinessObjectsLevel:Details, Configuration & TransactionLanguages:EnglishGoalsReport in the Excel Interface of the EPM add-in.Report in the Web Client.Use business process flows for planning.AudienceApplication ConsultantSupport ConsultantPower UserEnd UserProject ManagerProject StakeholderPrerequisitesEssentialExperience with Microsoft Excel.RecommendedExperience with OLAP products.Course based on software releaseSAP Business Planning and Consolidation, version for SAP NetWeaver 10.0This course […]
  • IBP200 – Platform Features and Time Series Based Heuristics Planning IBP200 SAP Integrated Business Planning - Platform Features and Customizing Contents Course Overview Unit 1: SAP Integrated Business Planning Lesson: Outlining the SAP Integrated Business Planning Solution Strategy Lesson: Explaining the Functionality and Benefits of SAP Integrated Business Planning Lesson: Describing the Architecture of SAP Integrated Business Planning Powered by HANA Lesson: Explaining SAP Integrated Business Planning Powered by HANA Out-of-the-Box Content Unit 2: User Interface Lesson: Navigating in the SAP Integrated […]