SAP BPC 10.0

SAP Certified Application Associate – SAP Business Planning and Consolidation 10.0

Component – Financial Consolidations

Business Object – EPM Solutions

References: SAP BPC 410, 420,  430, 440 & BW 310



BOPC 10.1 NW Administration and Planning

Course Overview

Course Goals

Course Objectives

Unit 1: Concepts and Objects in BPC Administration

Describe how to execute optimization, the difference between Light vs. Full optimization, the four areas of security: users, teams, data access profiles, task profiles, and how to best set up security, how to transport BPC objects, how to configure the three URL based drill through options: Websites, BW, and ECC and how to use drill though from Excel reports, what work status does, how to set up work states, the integration of work status with the owner property, and where to run work status reports.

Business Objects – Overview and Advantages of BO PC

Business Planning and Consolidation – Some Modeling Aspects

Describe how to execute currency translation, eliminations, the difference between incremental and full processing mode. Set and run data controls, and describe what happens when a data control fails and how to look up the root cause. Describe how to input ownership data, run ownership calculations, create journal templates, single period and multi period journals. Run journal reports.


Environment Management

Dimension Management

Describe dimension types, dimension properties, hierarchies, how to create dimensions, the difference between parent and base members, and  how to add members manually.

Creating Models


Unit 2: SAP EPM 10.1 add-in

Creating a Planning and Consolidation Connection

Unit 3: EPM Client – Microsoft Office Excel

Explain how to create EPM Excel reports and input forms, how to format, how to share a report axis, how to use the EPM options, how to set up a cross model report, how to create an input form, how to work with comments in the EPM add-in, how to configure and execute the Book Publisher, how to save files to be shared or for personal use.

Create a Report

Create a Input Form

Unit 4: Comments

Enable Comments

Input and Retrieve Comments

Unit 5: Multi-Reporting and Axis Sharing

Create a Multi-Reporting Spread Sheet

Share axis from one report with another report

Unit 6: Formatting

Dynamic formatting

Link a formatting sheet to one or several reports

EPM Function to apply formats

Unit 7: EPM Cell-based formulas

EPMAxisOverride Cell-based formula

EPMDimensionOverride Cell-based formula

EPMInsertCellsBeforeAfterBlock Cell-based formula

Unit 8: Books

Create a Book Template

Validate the Book Template

Publish a book to the Web Library

View the book in the Book Viewer

Unit 9: New Web Client

Create a Planning and Consolidation Web Report

Change the Report Behavior

Add a Chart to Report

Create a Web Input Form

Entering Comments via Web

Creating Document Types and Sub Types

Unit 10: Data Acquisition, Transformation, ECC and BW

Data Acquisition, Transformations, Packages, and Package Links

Unit 11: Working with Logic Scripts

Explain how to use script logic syntax, what the default logic file does, how to execute script logic via a data manager package, how to scope data records, and how to use the script debugger, how to use EPM Functions, how to create local members in the EPM add-in, how to use EPM macros, how to create dimension member formulas, and when to use dimension member formulas.

Logic Script and Online Execution

Logic Script and Central Execution

Logic Script and Allocation

Logic Script and ABAP Integration

Dimension Member Formulas

Unit 12: Drill Through

New Drill Through features

Create a new Drill Through

Specify the specific parameters of a Drill Through

Delete any parameter

Test Drill Through

Unit 13: Business Process Flows

How to manage Life Cycle of BPF Instances: Create/Start, Suspend, Reset, Archive

How to manage assignment of Process and Activity Instances

E-Mail notification

Unit 14: Dashboard Designer

Explain how to turn on data and activity audit and how to run the audit reports, create a business process flow template, create a business process flow instance, use a business process flow, the web client library, and add documents to the content library. Create document types and subtypes, workspaces and add objects to them, a dashboard to display BPC data, and run time and design time connections.

Design a Dashboard and Export it to Flash format in SAP Business Objects dashboard design

Insert a Flash object into a report

Publish a Flash objects into the Web

Creating Crystal Dashboards Using EPM Connector

Explain Crystal Dashboards functions with BPC Data

Display the content of a .txt file stored in Content Library

Input data in BPC from Dashboards

Unit 15: Word and PowerPoint Integration

Explain MS Word Integration with BPC 10.0

Explain MS PPT Integration with BPC 10.0

Unit 16: BPC 7.5 Migration

How to migrate BPC 7.5 Reports built with former EV Functions

How to migrate BPC EVDRE Reports

Unit 17: Others

Work Status


Work Spaces


Additional Concepts:


Over view on ASAP methodology

Transport request creation and release

Over view on technical aspects

SAP Query

Topic wise interview questions

Mock Interview

Mind Set at the Time of Interview

Voice Module / Body Language at the time face to face

Other Necessary Interview Tech


Tickets and Issues

© Cozy Consulting LLC 2017 ☏ 210-519-3650    ✉