BPC Administration Training: 10.0 Microsoft
Course Description / Summary:
This course includes in-depth instruction on primary tasks of an administrator of SAP BPC. In this course you will explore creating and running data manager packages and managing environments, models, and dimensions. You will also discover how to secure dimensions and how to provide users with specific tasks and data profiles. You will also learn how to streamline business processes by creating process templates and managing Business Process Flows, and much more!
Audience:
- BPC Administrators
- BPC Power Users
Prerequisites:
- Experience using Microsoft Excel
- Familiarity with modeling concepts and data warehousing
Courses:
- BPC Metadata
- Data Manager packages
- Security and Work Status
- Journals and BPC Web Client
- Publication and Distribution
- Process Flows (BPFs)
- Introduction to BPC Logic
Read MoreRead Less
Timing:
- BPC Application Administration (Microsoft) is comprised of seven, 3-hour courses, which may be taken alone or in series. These courses should be taken as early in the implementation as possible.
Product Hands-On:
- Virtual Classroom Training: Interactive simulation exercises to provide hands-on experience with BPC
- On-Demand eLearning: Interactive simulation exercises to provide hands-on experience with BPC
- On-Site Classroom: Exercises performed in your BPC environment
Training Curriculum:
- Presentation, instructor demonstrations, and exercises use the Column5 Training environment.
- BPC 10.0 Microsoft Administration Learning Objectives
- Metadata
- Identify the process for creating new environments
- Identify the process for deleting environments from the server
- Recognize the method for modifying environment parameters
- Identify the steps and rules for adding new dimensions to environments
- Differentiate between dimension types
- Recognize the process for managing dimension hierarchies
- Recognize the process for storing data by creating new models
- Distinguish between Model types
- Identify the method for managing model properties
- Recognize how to optimize data by utilizing storage and process types
- Data Manager
- Recognize the location and uses of Data Manager
- Identify how packages are represented
- Identify the file type used to represent packages
- Recognize the order of the standard five steps of the Package Cycle
- Identify how prompts are used
- Identify the process for executing Data Manager Packages
- Identify the steps for using a Data Manager Package to clear data from within a model
- Recognize the method for utilizing package comments
- Identify the steps for using a Data Manager Package to copy data between dimensions
- Identify the steps for using a Data Manager Package to export data from a model
- Identify the steps for using a Data Manager Package to import data into a model
- Recognize the process for organizing packages
- Identify the process for customizing an existing package
- Journals and Web Client
- Recognize the method for correcting Journals
- Identify the process for creating a Journal template
- Recognize the purpose and method for validating a journal with validation rules
- Identify the steps for creating journal translation rules
- Identify the process for clearing a journal table
- Recognize the steps involved in administering Journal parameters
- Identify the correct steps for creating, saving, posting, and un-posting Journal entries
- Recognize the process for accessing Planning and Consolidation objects
- Identify the steps taken to add New Objects to the Library
- Identify the steps involved in formatting and generating a report
- Differentiate between uses for Objects, Processes and Documents
- Recognize the steps for preparing reports on system information using the Web Client
- Recognize the steps in creating an Advanced Variance Analysis
- Security and Work Status
- Differentiate between the different ways user access can be managed by configuring security components
- Identify the steps for adding new user accounts
- Identify the steps for modifying user properties
- Identify the steps for assigning users to teams
- Identify the steps for creating Team Leaders
- Recognize the steps for assigning team access to Task Profiles and Data Access Profiles
- Identify the methods for creating, modifying, and deleting Task Profiles
- Recognize the process for granting users access in a Data Access Profile
- Identify the process for configuring a Data Access Profile
- Recognize the steps for securing dimensions, as well as the results
- Identify the purpose for creating the Owner dimension
- Identify the process for modifying the work status settings
- Recognize the steps for configuring work status message and environment parameters
- Recognize the process for generating a work status reports
- Publication and Distribution
- Identify the steps to take to produce a report using the EPM Pane
- Differentiate between Portal Publication and Book Publication
- Identify the correct steps for creating a book template
- Identify the process for modifying the properties of a book
- Differentiate between the three Dimension selector types
- Recognize how to select dimensions using the Dimension Selector
- Identify the steps for saving a book template
- Recognize the steps involved in publishing a book of reports
- Identify the correct method for creating a distribution template
- Identify the purpose and process for performing validation on a template
- Recognize the steps involved in distributing and collecting reports and input forms
- Identify the correct steps for utilizing the EPM Add-in for Word and PowerPoint to create BPC Reports
- Processes and Audit
- Differentiate between Process Templates and Process Instances
- Identify the method for creating a Process Template
- Identify required dimensions and properties when creating Processes
- Identify the definitions of Process Steps or Sub-Steps
- Recognize the process for modifying process templates
- Recognize the steps for administering processes
- Identify the process for managing data and activity auditing
- Recognize the process for generating audit reports
- Intro to Logic
- Identify the process for using Excel to perform Worksheet Logic
- Name the steps for creating and executing calculations
- Identify the method for utilizing Script Logic to perform calculations for special requirements
- Recognize the process and purpose for supporting accounting activities using Business Rules
- Identify the steps for assigning dimension logic to a member
- Recognize the purpose and method for adding the FORMULA property to a dimension
- Recognize the steps for performing complex allocations using the Allocation engine
- Differentiate between different Account-based calculations
Take Away Training Materials:
- PDF of presentation
Software:
- SAP Planning and Consolidation 10 for Microsoft.
Advanced Preparation:
- None
CPE Credits for Onsite Training (Group Live) and Virtual Classroom (Group
- 5 CPE credits per course