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.
Show more

Share

About Trainer

A.S.
Sr. BPC Consultant/Trainer
A.S. is senior BPC Consultant/Manager/Trainer. He has extensive experience in the BPC and Finance and technically very strong
Show more

Duration

35 hrs | 40 Videos

SAP BPC

Duration
35 hrs
$69.65 $199.00    
Expand all
Collapse all
  • BPC 420 - Introduction to Web UI
    • Navigating Through the Web Interface, Workspace, Web Input Forms
    • Reports, Activities, Web Administration Console
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • Various Upgrade paths in BPC landscapes
    • Process of upgrading an environment
    • pre and post activities

Last Viewed Video

No Video Viewed.