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.