SAP - Business Planning and Consolidation (BPC)

Introduction:

• What is EPM, BPC, BI-IP

• Architecture BPC-MS

• Release strategy

• Terminology

Administration :

• Creating Applications and Applying Dimensions

• Architecture of an Application-

• Explain the Tables, Optimization Options and Compression

• Loading Transaction Data using a FlatFile

• Creating a Transformation File

• Creating a conversion file

• Introduction to Logic/Calculations

• Loading and Validating Data

• Working with BPC for Excel

• Developing Reports

• Developing Input Schedules

• BPC Comments

• Book Publication

• Working with BPC Web

• Content Library

• Live Reporting

• Working with BPC for Word and BPC for PowerPoint

• Inserting Objects and Data Values

• Advanced reports using multiple EvDRE.

• Creating Custom Buttons and Assigning Macros

• Advanced Formatting options using Properties

• Demonstrate Building Income Statement, Balance Sheet and Trial Balance reports using EVDRE.

• Demonstrate building a report reading data from multiple applications using EVDRE

• In-depth study on BPC process flows

Planning

• Explain the Planning Process

• Define the planning Model

• Functional Specifications

• Seeding the Plan

• Rolling Forward Forecast

• Calculations using Script Logic

• Calculations Using Worksheet Logic

• Allocations using Script Logic

Consolidations:

• Budgeting System Implementation Overview

• Seeding the Budget

• Defining Modeling Requirements

• Defining and Creating Budget Input Templates

• Creating and Developing Budgeting Business Process Flows

• Creating variance calculation,

• Creating an EVDRE Report and input schedule

• Currency translation, Inter company eliminations

• Expansion, filtering, suppression and indentation in reporting

• Journals: Set Up, Journal Creation, and Journal Reports

• Introduction to Script Logic and Mdx logic

• Intercompany Eliminations Set up

• Intercompany Eliminations using Script Logic

• Currency Conversion – Direct and using script logic

• Competitor Analysis

• Cost Center planning dry run

Additional

• Hot Analysis

• ParknGo

• BPC Journals

• BPC Audit

• Comments

• Custom Menu

• Business Process Flows

• Lab Exercises

• Project Exercises

Security Set up

• Task Profile

• Member Access Profiles

• Users and Teams

• WorkStatus Settings

Using Standard Data manager Packages

Creating Custom Data Manager Packages

• Creating SSIS packages