SAP Analytics
Thought Leadership

Over the past 6 months, we’ve seen a lot of our clients experience stubborn errors and issues that have surfaced in BPC for Microsoft environments. It’s important to understand that these issues are mostly related to user errors or updates not being performed correctly.

The Technical Team at Column5 has performed in-depth troubleshooting and continues to provide various technical solutions for our customers. Today, we have compiled a list of the top 10 issues including root cause and a simple solution. Continue reading to discover how you can tackle these issues and improve your performance!

The ability to drill through from BPC to more detailed information is a high value exercise for a relatively low investment - yet it continues to be one of BPC’s most overlooked features. 

The typical use cases are as follows:

• Lower level connection with details
  • Exact, accurate actuals for run rates, deconstructing numbersDetails necessary to calculate drivers that drive the accurate plan
  • Ability to link to transactional systems at the lowest level of detail for drill through
  • Time definition is the frequent axis for alignment
• Automate time to explain variances & identify anomalies
  • Understand exactly what transaction drives variance (if applicable)
  • For close, audits, and other reconciliation exercises, spot suspect numbers
• Convenience builds user adoption Adds functionality like drill through to details, even possibly images
  • “One stop shopping” user experience
  • No need to switch tools wholesale as data gets lower in details

Our Technical Services team has received an influx of service tickets regarding issues with the recently released SAP BPC EPM Add-in Service Pack 29.

Problem

With EPM Add-in SP29 installed, we noticed that none of the built-in reports or report templates are working when trying to refresh with BPC 10.1 Microsoft (MS). When attempting to refresh, it keeps prompting to login to SAP NetWeaver (NW) system, instead of BPC 10.1 Microsoft.  Please see example below:

ldcie3f.wdf.sap.corp EPMAddin_ODBOSP3 Consolidation

We are connected to the Planning model for BPC MS but it is trying to login to BPC NW Consolidation.

As many of you know, a properly implemented EPM solution can help model changing market conditions. Such
conditions may be commodity prices, competitive pressure in certain product and geographical markets, interest rates, or currency exchange rates. The thinking is, the better the ability to understand the impact to your organization of such volatility drivers, the more time you will have to craft a strategy to react. However, this task is not very simple as you will have all of those influences (and likely many more) nudging your company’s performance indicators up and down simultaneously.

SAP BPC is a tool that can be customised to facilitate planning, budgeting and forecasting processes for different
 functional areas such as Revenue, Human Capital Management, Operating Expenses, and Capital Expenditure. In this blog we will talk about how to integrate these functional areas into one unified BPC reporting model, for fully integrated planning.

The different functional areas require different data structures and consequently we  will need to use a separate BPC model for each area. To give some common examples:

The Revenue model may, depending on the modelling requirements, need to have Product dimensionality in order to plan the sales volumes and calculate planned revenue according to the price by product, and a Customer dimension to plan sales and analyse the outstanding payments by customer or channel.

The Labour planning, or HCM model may need to include a role dimension, in order to plan the salary by role or grade, or an Employee dimension to enable planning by employee or job grade.

The Operating Expenses or OPEX model should enable the user to plan the expense related General Ledger accounts at the required level of detail, for example, by collecting the number of flights and hotel nights and using forecast unit costs to calculate travel expenses.

The Capital Expenditure or CAPEX model should include an asset dimension which will include the company’s asset list and allow the user to plan new asset purchases and the corresponding depreciation for the planning period.

When comparing BPC to other products, a big factor to consider is the user interface experience. SaaS based
EPM solutions often have significant constraints to the available options when designing the experience users will 
interact with, due to the inherent design limitations of those solutions. BPC’s robust Excel interface has an unlimited ability to meet any user experience requirement. In addition to the significant numbers of Excel functions included in the EPM Add-in that can be applied creatively to meet any need, sometimes it is necessary to leverage Visual Basic to create highly specific behavior in the interface.

BPC has always been a flexible tool with many “hooks” through Excel and the database layer enabling all manner of customizations to increase usability to customers’ exact specifications. The risk of customizing is the potential of that customization being an impediment to an upgrade. One popular access point provided by SAP/OutlookSoft was the “MNU_Commands” hook.

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!

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.

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.