Loading Classes
SAP Business Planning and Consolidation: Reporting and Planning (BPC430)
New Age Technologies has been delivering Authorized Training since 1996. We offer SAP’s full suite of authorized courses including courses pertaining to SAP Business Planning, Supply Chain Management (SCM), Enterprise Resource Planning (ERP), BusinessObjects, Product Lifecycle Management (PLM), and more. If you have any questions or can’t seem to find the SAP class that you are interested in, contact one of our SAP Training Specialists. Invest in your future today with SAP training from New Age Technologies.
✉ SAP Training Specialists | ☏ 502.909.0819
Current Promotion
COURSE INFORMATION
SAP Business Planning and Consolidation: Reporting and Planning (BPC430) Course Overview:
In the SAP Business Planning and Consolidation: Reporting and Planning (BPC430) class, you 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.
This course is based on software release:
- BPC 10.1 NW Standard Model SP5
- SAP BW 7.4 SPS10
- HANA SPS9
- EPM add-in SP21
- Design Studio 1.4
- Analysis for Office 1.4.9
Who Should Attend:
- Application Consultant
- Business Process Owner / Team Lead / Power User
- Program / Project Manager
SAP Business Planning and Consolidation: Reporting and Planning (BPC430) Course Prerequisites:
Before attending this course, you must have the following:
- Experience with Excel
- Recommended experience with OLAP products
SAP Business Planning and Consolidation: Reporting and Planning (BPC430) Course Objectives:
After successfully completing this course, you will be able to:
- Report in the Excel Interface of the EPM add-in
- Report in the Web Client
- Use business process flows for reporting
SAP Business Planning and Consolidation: Reporting and Planning (BPC430) Course 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
/Salary/by_Job/300s.png)
