<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">

SAP Analytics
Thought Leadership

Planning and Forecasting: Category Set-Up for SAP BPC

Posted by
David Meharry
David Meharry
on Tue, Dec 18, 2012 @ 09:12 AM
Find me on:

Whether you are just getting started with your Business Planning & Consolidation (BPC) implementation or looking for improvements to your existing implementation, best practices are often simple concepts that improve user satisfaction and reduce chances for errors.

Issue: Untrustworthy Data
One of the most frustrating things for users when it comes to planning and forecasting is data that they cannot trust. I recall one example where, after publishing executive reports, an analyst realized that their prior forecast had unexpectedly changed. The bad data was an accidental result of input templates, logic, and security being open for a prior forecast. Fortunately, the data was recovered, but not before a costly loss of time and resources. The error was the result of many manual steps in a process where all steps had to be done in exactly the right order. Prior to the forecast, there was a change in personnel. Even though proper knowledge transfer was done, the error still occurred.

Overview: Category Member Set-Up
Category member set-up, as it relates to planning and forecasting, is absolutely critical. The category member design impacts ongoing maintenance of business rules, custom logic, user security, and templates. For simplicity, let's focus on the forecasting process. This best practice design can be applied to any forecast, plan, or budget type of category.

How To Do It Right: Static Members
Category dimension builds typically have members such as "Forecast 2013 Q1," "Forecast 2013 Q2," etc. Sometimes, incorrectly, these verbose members IDs are used as IDs to write data, too. Then with each forecast lifecycle, the active ID changes. This creates constant work for system administrators to update rules, logic, variables, templates, and security. If a mistake is made, it can lead to data integrity and cause user frustration. To simplify the forecasting process, add a static member called "Current Forecast." This new member will always represent the active forecast.

Planning and Forecasting   Category Set Up for SAP BPC
Utilizing this simple concept offers three benefits. 1) It clearly identifies to all users what member is the current forecast. 2) It minimizes the maintenance required for your system administrator. 3) Finally, this process allows for system administrators to create multiple read-only snapshots of the current forecast for tracking changes.

Topics: BPC (Business Planning & Consolidation), Forecasting


Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book


2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC


  3. Get Your EPM Assessment  


Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment