Expand +



Intro to BPC calculations using Business Rules: Tips from BPC Bootcamp Amsterdam

by Allison Martin

November 26, 2012

In SAP Business Planning and Consolidation, how can you perform calculations? There are a couple options, and two methods in particular - business rules and member formulas - require no programming skill. 

In their BPC Bootcamp session next week in Amsterdam -- "BPC Script Logic for Consolidations: Beyond the Basics" -- Mike Weeks and Martin Lloyd of Column5 take attendees through the basics and dive into the details of BPC calculations.

This tip is taken from some of their discussion of business rules:

How Can You Perform Calculations in BPC?

- On an Excel workbook:

  • Regular formulas in Excel files. The results of these formulas can be submitted back to the database.

- On the database using BPC rules such as:

  • ?     Member formulas – Dimension member calculations
  • ?     Business rules – Pre-built calculations accessed from Admin Console
  • ?     Controls – Enable you to test the validity of the data
  • ?     Script logic – BPC programming language for custom calculations
  • *Of the database methods, business rules and member formulas require no programming skill!

    What Are Business Rules?

    What business rules are …

    • Pre-written calculations that come with BPC out of the box
    • Programs that run directly on the database and do not involve Excel
    • Schedulable – can be scheduled to run within data manager
    • Configured using the BPC Administration Console in a table-like format
    • Powered behind the scenes by SQL Stored Procedures (BPC for Microsoft) or ABAP Programs (BPC for SAP NetWeaver)

    and are NOT...

    • Business rules are not Excel-based formulas
    • Business rules exist in the BPC database and perform their calculations directly on values stored in the database

    Business rules do not require you to open an Excel spreadsheet

    What Can Business Rules Do?

    Common Accounting Functions …

    • Post YTD net income to the balance sheet
    • Roll forward retained earnings and other equity accounts from prior years
    • Facilitate the tracking of cash flow movements

    Currency Translations …

    • Translate using average and end-of-period rates in a periodic application or YTD application, translating each month’s activity at that month’s rate
    •  Allow for certain entities or accounts to not be translate (e.g., historical equity)

    Intercompany Transactions …

    •  Facilitate intercompany matching between trading partners
    •  Automatically book offsetting intercompany entries
    •  Intercompany eliminations

    Legal Consolidations …

    •  Calculate minority interest for consolidated subsidiaries
    •  Calculate net equity in earnings of affiliates for associate companies

    For more on BPC - including business rules, calculations,  and forecasting with  BPC 10.0 -  join us next week in Amsterdam at BPC Bootcamp, December 3-5. And follow me at @AllisonMartin14 for more information on upcoming BPC Bootcamp cities and our Financials 2013 events.

Did you find this blog helpful? Get access to the latest updates and resources from SAPinsider with a free subscription.

Get the SAPinsider subscription now »»

An email has been sent to:

More from SAPinsider


Please log in to post a comment.

No comments have been submitted on this article. Be the first to comment!