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

SAP Analytics
Thought Leadership

SAP BPC Performance - Best Practices

Posted by Charles Dagaev on Tue, Feb 02, 2016 @ 09:02 AM

Column5 and I have seen a lot of things over the years in the EPM space. I have been working on the technical side of BPC MS since 2000, BPC NW since 2007, and BPC NW on HANA since 2012, having implemented it around the world over 1000 times.

I have a dream to, at some point, write a book of everything I have seen over the years. If investors knew what was really going on deep within some of the world’s datacenters, I think some heads would be rolling! I won’t mention ANY NAMEs but some of them are the who’s who of worldwide companies!

I keep running into the same thing over and over and over again, whether it is hosted by a 3rd party or implemented on-site at a client. The challenges start with a common element that is surprisingly easy to fix: No one seems to take care of the servers and technology!

Topics: Best Practices, Performance, BPC (Business Planning & Consolidation)

How to Calculate Return on Investment for SAP BPC Projects

Posted by Richard Hynes on Wed, Nov 25, 2015 @ 10:11 AM

We know that EPM (and specifically SAP BPC) implementations have the potential to be very profitable, more so than other IT projects like ERP implementations. But how do you prove that?

This blog takes a step by step approach to building a solid business case for a SAP BPC implementation. There are many intangible benefits to an EPM project which are difficult to put a value to, but we can set out all the costs and calculate a large part of the benefits. Even without adding in the intangible benefits, such as improved data quality, higher management efficiency and faster decision making, BPC projects can still be very profitable projects, so let’s go through the business case elements step by step.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), EPM ROI, BPC (Business Planning & Consolidation)

SAP BPC Staffing and Support Models

Posted by Jonathon Pause on Wed, Nov 18, 2015 @ 09:11 AM

Whether you already have an existing BPC environment or are planning a new one, how to appropriately staff and support your EPM environment is a big question to tackle early on. While the number of FTEs will greatly differ based on the size or your organization, the complexities of your planning process, and the level of automation you invest in upfront, there are some basic skillsets you should address.

Topics: Process Improvement, Thought Leadership, Enterprise Performance Management (EPM), BPC (Business Planning & Consolidation)

The Integrity of Data Entered into SAP BPC via Input Schedules

Posted by Michael Sheard on Tue, Oct 20, 2015 @ 08:10 AM

SAP BPC systems receive data from a range of external sources.  The planning and configuration necessary to insert this data into the system is an important aspect of an implementation.  The integrity of data is vital, and invalid data can affect processes within SAP BPC, such as calculations and reporting.  Safeguards should be in place to prevent the entry of invalid data.

The main methods employed to enter external data into a SAP BPC system are:

  • Interfaces to source systems such as an ERP or SAP BW system.
  • Flat file uploads.
  • Input schedules for manual data entry.

The first two sources – interfaces and flat files – are tested, configured, and operated by experienced administrators and consultants who understand the data structures of source systems and SAP BPC, so these usually do not create problems.  The greatest risk is with data entered through input schedules by users who, whilst knowledgeable about the commercial functions of their organisations, are not experts in the data structures of financial information systems like SAP BPC.  The techniques available to ensure the integrity of data entered via input schedules are the focus of this article.

Topics: Thought Leadership, Enterprise Performance Management (EPM), Data, BPC (Business Planning & Consolidation)

New Features of BPC 10.x Upgrades

Posted by Staci Matt on Tue, Oct 13, 2015 @ 08:10 AM

When upgrading to BPC 10.x, many companies are curious about what new features will become available to them.  Besides being quicker, more stable, etc., there are three new features that Column5 believes are worth the upgrade.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), Project Management, EPM 10, BPC (Business Planning & Consolidation)

EPM Add-in and Admin 10/10.1 on a Tablet?

Posted by Charles Dagaev on Tue, Oct 06, 2015 @ 09:10 AM

A key component of an effective reporting strategy is the ability to get data to users when, where, and how they need it to make better decisions. For many users in today’s technology-driven world, that means mobile devices are a critical part of the overall reporting strategy.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), EPM 10, BPC (Business Planning & Consolidation)

Going Back to Diagrams

Posted by Israel F. Anotado on Tue, Aug 25, 2015 @ 10:08 AM

While working with clients to deliver EPM capabilities, we have all heard about how it is critical to have good EPM business processes in place within an organization. I would say that I totally agree with an earlier Column5 blog post, “The Process is King”. Clearly documented business process models assist organizations to align operations to their strategy, promote better communication, improve existing practices, establish control and consistency, and even gain competitive advantage.

Topics: Best Practices, Process Improvement, Thought Leadership, Enterprise Performance Management (EPM), BPC (Business Planning & Consolidation)

Why EPM Checklists, Methodologies, and Fast Start Templates Ensure Success

Posted by Connie Folk on Wed, Aug 19, 2015 @ 09:08 AM

Column5 CEO David Den Boer once told me, “Behind every checklist there is a dead body. “ As a military veteran, he knew that safety procedures were often put in place in the aftermath of a tragic accident that unfortunately involved the loss of life. The military is well known for their rigor, strict definition of procedures, and processes that deliver consistent and repeatable results.  Isn’t that what we all strive for in delivery of our EPM projects? You can accomplish this result without enduring fatalities along the way.

Topics: Best Practices, Enterprise Performance Management (EPM), Project Management, BPC (Business Planning & Consolidation)

The MakeDim Task is Not a Dimension Automation Process - BPC for Microsoft

Posted by David Kolka on Tue, Aug 11, 2015 @ 08:08 AM

BPC owners often seek to implement automation to make manual administration the exception wherever possible, in order to lower TCO and increase uptime.  For dimension automation, new members added to source systems (accounts, product names, etc.) would be automatically inserted into the BPC master data tables.  Automating this task could save quite a bit of manual effort over time, and increase system uptime.  If your BPC deployment requires manual dimension maintenance, this solution may be of great interest to you.

Topics: Best Practices, Excel, Thought Leadership, Enterprise Performance Management (EPM), Microsoft, BPC (Business Planning & Consolidation)

Does BPC Performance Depend on the Technology Stack?

Posted by Charles Dagaev on Wed, Aug 05, 2015 @ 12:08 PM

The Battle of BPC

I have been in the Analytics space for over 13 years, having started at the original OutlookSoft Corporation (creator of the BPC software) as employee #33 (or so). I stayed with the company that acquired OutlookSoft in 2007, SAP, until 2008, when I came to Column5. I have been involved in over 1000 technical implementations of the BPC software (all technology stacks) over the years with companies around the world.

When I say “Technical Implementation”, I mean performing a System Landscape Design (SLD), multiple Installations, Performance Tuning, Disaster Recovery, Environment Synchronization (Transports), and Go-Live Support. As I started the Technical team at Column5 back in 2008 after working at SAP/OutlookSoft for 8 years Column5, has used the above services and others to ensure client success, or as I like to say “EPM NIRVANA”.

Obviously SAP has moved the software forward leaps and bounds in a lot of functional ways, but especially supporting multiple server technology stacks on the backend. This allows SAP to really fit into just about all of the worldwide business technology strategies. Currently with BPC, there are three different “flavors” of the software and they are:

  • BPC (10) BW powered by HANA
  • BPC (10) NetWeaver
  • BPC (10) Microsoft

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM), Performance, BPC (Business Planning & Consolidation)

Subscribe

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  

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