SAP BPC

Course Description

SAP Business Planning and Consolidation (SAP BPC) provides you with a single view of financial and operational data, standardizes management processes, and models what-if scenarios. Start learning today and become expert at your own pace.

What will you learn?

• BPC 420 – Introduction to Web UI
• Navigating Through the Web Interface, Workspace, Web Input Forms
• Reports, Activities, Web Administration Console
• BPC 420 – Dimension Management
• Dimension Tyoes, Creation of Dimensions, Editing Dimensions
• Creating Dimension Properties, Processing Dimensions
• BPC 420 – Model management
• Understanding the concept of models
• arious types of models, Mandatory Dimensions for models
• Data Entry Modes, Cretion of Models, Editing Model
• BPC 420 – Security Configuration in BPC
• Security Framework in BPC
• Users, Task Profiles, Teams, Data Access Profiles
• BPC 420 – Introduction to EPM Add-In
• Intrduction to EPM Add IN, Creating connections,
• EPM Context, EPM Pane, Sheet Options
• Context Options, Creating Simple Reports
• BPC 420 – Introduction to Data Manager
• Understanding the Data Manager Cocepts, Understanding the building blocks of Data Manager
• Process Chains, Scripts, Prompts etc, Conversion Files
• Transformation Files, Delivered Data Manager Packages
• BPC 420 – Data Manager in Detail
• BPC 420 – Data Validations in BPC
• Why is Data Validation Required
• Configuring Data Validations
• Impact of Data Validations
• BPC 420 – Script Logic in BPC
• Different Types pf logic in BPC
• Server Logic vs Sheet Logoc
• On the Fly vs Bact Calculations
• Sheet Based Logic, Dimension Logic
• Script Logic, Business Rules
• BPC 420 – Member Formula & Script Logic Basics
• Components of Script Logic
• Considerations while writing Script Logic
• *REC Command, *WHEN Command
• BPC 420 – Script Logic Deep Dive
• The COMMIT Statement
• Scoping statement – XDIM Memberset & XDIM Add Memberset Statement
• XDIM Max Members Statement, XDIM Filter Statement
• , Select Statement, Select Case Statement, TMVL Parameter
• Looping in Scripts using For/Next Loop
• Script Logic – Implied Keywords, Multi Model Scripting
• Lookup Statement, Destination App Statement
• Basic Rules for writing efficient and performance driven Script Logic
• ADD/ADD END Statement
• Implementation of Badis
• BPC 420 – Allocations in SAP BPC
• Allocations Business Scenario, Components of Allocations in BPC
• Example of Allocations, Allocations Syntax, What Keyword
• Where Keyword, Factor Keyword, Factor/Using Keyword
• BPC 420 – Allocations in SAP BPC- Hands On
• BPC 420 – BPC Backup and restore using UJBR
• Bacup of Environment using UJBR
• Restoration of Environment using UJBR
• BPC 430 – Data Storage in BPC
• Periodic vs YTD storage in BPC
• Account Types in BPC
• BPC 430 – Basics of Reporting – Layouts rules etc
• EPM Report Layouts and Rules, Page Axis, Row Axis, Column Axis, Data Grid
• Dimension Layout Restrictions, Simple Row Axis, Multidimesional or Nested Row
• VarAxis, Row Axis Restrictions, Simple Column Axis
• Nested Column Axis, Column Axis Restrictions, Data Grid Considerations
• Various techniques of creating EPM Reports
• Member Identification, Member Properties
• BPC 430 – Basics of Reporting – Report Options, Local Member etc
• Sheet Options, General Sheet Options, Formatting Sheet Options
• Refresh Sheet Options, Protection Sheet Options
• Report Options, Sorting, Filtering, Read Only Data
• Ranking, Local Members, Member Names
• Excluded Members, Member Insertion Filtering
• BPC 430 – Basics of Reporting – Multiple reports, refresh etc
• Multiple Reports in a Sheet
• Shared Axis, Hide/Remove zeros
• BPC 430 – Basics of Reporting – Shhet options – general formatting and refresh
• BPC 430 – Context Options, Static Formatting, EPMcontext member
• Context Options, User options
• Static Formatting, EPM Context Member
• Static Formatting, EPM Context Member
• BPC 430 – EPM Functions
• EPM Functions, EPMuser, EPMserver, EPMEnvDatabaseID
• EPMEnvDatabaseDesc, EPMmodel, EPMmemberdesc
• EPMMemberProperty, EPMMemberoffset, EPMOLAPMemberO
• EPMreportID, EPMFullContext,EPMDimensionProperty
• EPMDimensionList, EPMDimensionPropertyValue
• EPMRetrieveData,EPMSaveData
• EPMComparison, EPMDimenList
• BPC 430 – Dynamic Formatting in EPM reports
• Difference between static & dynamic formatting
• Activating the dynamic formatting
• Understanding the EPM formatting sheet
• Page Axis Formatting, Row & column bading
• Hierarchy level formatting
• member specific and property specific formatting
• BPC 440 – Business Process Flows
• Introduction to Business Process Flows
• Creating BPF Template, Driving Dimension
• Performer, Reviewer, Activities
• Performer Workspace, Deploying BPF Templates
• Creating BPF Instances, Executing BPF Instances
• Suspending & Resuming BPF instances
• BPC 440 – Work Status & data Locking in BPC
• Understanding the data lock concept, Defining work status
• Configuring work status in the system
• Locking data using work status
• BPC 440 – Balance Carry Forward
• Understanding the concept of balance carry forward
• Understanding the mandatory dimensions and properties for BCF
• Configuring the BCF Business Rule
• Configuring the Script Logic
• Configuring the balance carry forward data manager package
• BPC 440 – Currency Conversion
• Building Blocks of the Currency conversion process, Mandatory Models
• Dimensions & properties required for currency cnversion
• BPC 440 – Intercompany Transactions and US Eliminatns
• BPC 440 – Intercompany Reconciliation & Matching
• Analysisng the intercompany transactions and the need for eliminations
• Understanding the mandatory dimensions and properties for Eliminations
• Configuring the US Elimination Business Rule
• Script Logic & Data Manager Package
• Understanding the need For Intercompany Reconciliation during the close process
• Configuring the building blocks for IC Mataching & IC booking
• Upgrade Scenarion IN BPC
• Various Upgrade paths in BPC landscapes
• Process of upgrading an environment
• pre and post activities