SAP BPC Certification Syllabus

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.

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

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.

Explain model types, which dimension types are used by each model type, how to secure dimensions, how to create models and make model settings such as for comments and data storage, and identify the BW objects created for each model.

Describe the purpose of the data manager, how to create your own packages based on delivered process chains, how to create transformation and conversion files, how to execute packages and review logs, how to use data manager packages to import both master and transaction data.

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.

Explain how to configure business rules including: methods, method based multipliers, eliminations and adjustments, us eliminations, inter-company booking, copy opening, currency translation, controls, and reclassification.

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.

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.