SAP BPC Logic Workshop

Course Description/Summary:

This workshop is designed to help you make sense of the basic and more advanced principles of BPC logic – including dimension, SQL-based, allocation, and business rules logic types.  More importantly this workshop will give you the confidence and empowerment to create your own logic scripts and to troubleshoot existing logic. This workshop includes presentations, demonstrations, and hands-on exercises.  The presentations capture the key concepts, while live demonstrations offer real-world scenarios.  Our hands-on exercises present students with practical application to test the solutions.


  • BPC administrators
  • BPC power users


  • Worksheet Logic
  • Dimension Logic
  • SQL-Based Script Logic
  • Allocation Logic
  • Business Rules
  • Darwin Calculation Engine (DarCE)
  • 3 days

Product Hands-On

  • Presentation, instructor demonstrations, and exercises use the Column5 Training environment.

Learning Objectives

BPC Logic Overview

  • Explain the purpose and uses of Sheet Logic
  • Explain the purpose and uses of Dimension Logic
  • Explain the purpose and uses of SQL Logic
  • Explain the purpose and uses of Allocation Logic
  • Explain the purpose and uses of Business Rules

Worksheet Logic

  • Explain when worksheet logic is calculated
  • Activate Local Member Recognition within Sheet Options
  • Create a Local Member calculation directly in the worksheet
  • Explain the purpose and function of local member keywords in calculations
  • Explain how Local Members are attached to a specific part of the report
  • How to use the option Use Excel Cell References when creating a Local Member
  • How to use the option Position in Axis when creating a Local Member

Dimension Logic

  • Define the purpose of Member Formulas, how they are used, and when they should be used
  • Understand the pros and cons of using Member Formulas
  • Learn how to enable Member Formulas (NW & MS)
  • Learn how to create statistical members to be used as Member Formulas (NW & MS)
  • Create member formula using Formula Editor (NW)
  • Create member formula using FORMULA property (MS)
  • Understand how to create member formulas using MDX Syntax
  • Understand how the Time and Measure dimensions affect member calculations
  • Understand how the ACCTYPE property affects member calculations
  • Understand how to use SOLVE_ORDER value to determine the order of member calculations
  • Member formula considerations and best practices

SQL-Based Scripting Logic

  • Explain how the logic engine works
  • Explain when best to use SQL Script Logic
  • Differentiate between SQL Script Logic syntax and MDX Syntax
  • Explain what layer SQL-based logic is run
  • Describe the script logic structure
  • Show where script logic files are maintained in NW and MS
  • Name the two script logic file types and how they are used
  • List the different types of keywords that can be included in script logic files and how to insert them
  • List the steps to edit, copy, and delete logic script files
  • Explain the purpose of using comment rows within script logic files
  • Explain the two ways in which logic files are executed
  • Explain the query scope when logic is executed via a Data Send vs. a Data Manager package
  • Identify where Data Manager package status and logs can be found

Allocation Logic

  • Describe the function and purpose of the Allocation Engine, and the types of calculations it can perform
  • Describe the purpose of each key element of the Allocation Engine’s structure. Including WHAT, WHERE, USING, TOTAL, and FACTOR
  • Scope Allocation Logic using *XDIM_MEMBERSET
  • Explain when to use *DIM_NONAGGR
  • Describe how to create an offset in Allocation Logic
  • Explain how to use %YEAR% in order to retrieve the current calendar year
  • Create a multi-step allocations

BPC Business Rules

  • Describe the purpose and function of using Business Logic
  • List the steps needed in order to add a Business Rule to a model
  • Manage, edit, and delete business rules
  • Explain the purpose of each field in the Account-based Calculations Business Rules table
  • Create Account-based Calculations using a Business Rules table
  • Run an Account-Based Calculation rule by calling the stored procedure from a logic file
  • Explain the purpose of each field in the Currency Translation Business Rules table
  • Explain the dimension properties needed in order to perform Currency Translation
  • Create Currency Translations using a Business Rules table
  • Run a Currency Translation rule by calling the stored procedure from a logic file

Darwin Calculation Engine (DarCE) Overview

  • Explain what is Darwin EPM
  • Explain how the Darwin Calculation Engine (DarCE) addresses gaps in BPC functionality
  • List and describe each main component of DarCE
  • Explain why DarCE calculations are performed faster than standard SQL-based logic calculations

Take Away Training Materials:

  • PDF of presentation


  • This workshop is applicable to both the Microsoft and NetWeaver platforms for BPC 10.x – 11.x Standard.  Any differences between platforms and versions will be noted by our instructors and documented in our training materials.

Advanced Preparation:

  • None

CPE Credits for Onsite Training (Group Live) and Virtual Classroom (Group Internet Based):

  • You will earn 25 CPE credits by taking this course and will receive a CPE certificate of completion.