Course Content
Introduction
What is EPM, BPC, BI-IP
Architecture BPC-MS ,NW
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
Working with BPC for Word and BPC for PowerPoint
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
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
Work Status Settings
Using Standard Data manager Packages
Creating Custom Data Manager Packages
Automation of Master Data and Transactional Data