Man-Computer-Laptop-Coffee-Cafe-Concept-000079551979_Large-1.jpg

SAP BPC & EPM
Thought Leadership

Kill Bill Volume 1: Memory Consumption and the White Screen of Death

Posted by Bill Gaskins on Wed, Sep 13, 2017 @ 11:09 AM

Google “EPM Performance or Memory issues” and you will receive millions of hits from your search results.  When it comes to performance and especially memory consumption, not only is the “magic bullet” fix rare but the resolution is potentially complex and multifaceted in nature.  On a recent project, we started to see symptoms that became issues including long refresh times.  For one user, we saw an Input Schedule consume so much memory it resulted in the “White Screen of Death (WSoD) and Excel crashing.  In this article, I wanted to look at the challenges we faced and strategies employed to resolve the issues.

Topics: Excel, Performance, EPM, SO - Functional Track

Warning – SAP BPC Embedded Projects are not just “BPC Standard Projects with a bit more BW Resource!”

Posted by Sumit Goenka on Thu, Aug 31, 2017 @ 09:08 AM

The number of SAP BPC users evaluating SAP BPC Embedded and SAP BPC Optimized is growing. In many ways SAP BPC Embedded is an exciting option because it is fast performing and highly integrated with core SAP financials (S/4HANA Finance). We think Embedded is an option well worth exploring for all SAP BPC users, but we also want those users to be well informed, particularly if they don’t have a strong SAP BW and SAP BW-IP background. This article is the first in a series of blogs where we take our experiences of all flavours of SAP BPC and apply the learnings for those looking at Embedded.

Topics: BPC, BPC NW – Embedded, Embedded, BW

How To: Drill Through from SAP BPC

Posted by Mike Sullivan on Thu, Aug 24, 2017 @ 08:08 AM

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

Topics: Data, BPC (Business Planning & Consolidation), BPC, Functional, reporting

Using SAP Analytics Cloud as a Client to BPC

Posted by Steve Sussman on Wed, Aug 16, 2017 @ 08:08 AM

SAP Analytics Cloud (SAC) is delivered as a SaaS (Software as a Service) solution on the SAP HANA Cloud Platform.  SAC combines multiple EPM, BI and Analytics features/benefits into one product.  This allows users to plan with robust collaboration features while using Predictive Analytics as well as Business Intelligence, and robust, state of the art Analytics. Currently, SAP BPC remains the default approach for Enterprise-wide Planning, Forecasting and Consolidations, while SAP Analytics Cloud fulfills relatively straightforward requirements from a planning and forecasting perspective.  

Topics: HANA, Analytics, Cloud, BPC, SAP HANA, Analytics Cloud, SaaS, SAC

[TECH ALERT] BPC 10.x Microsoft with EPM Add-in SP29

Posted by Darko Kavazovic on Wed, Jul 12, 2017 @ 09:07 AM

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.

Topics: BPC (Business Planning & Consolidation), BPC, Services Focused, Technical, EPM Add-in, EPM

Key Lessons From Our Webcast Series with DNB ASA: "Achieving Excellence and Efficiency in EPM with SAP"

Posted by Paul Coleman on Thu, Apr 20, 2017 @ 12:04 PM

During November and December, Column5, in conjunction with our client DNB, three interesting and informative webcasts ran on the exciting and rewarding journey taken by DNB ASA, Norway’s largest financial services group.

This series of webcasts focused on the following specific and important elements of Enterprise Performance Management:

  • Financial Consolidation for Statutory and Regulatory Reporting
  • Intercompany Reconciliation
  • The Last Mile of Financial Reporting

Each topic was underpinned by informing the attendees how SAP EPM solutions help companies achieve excellence and efficiency based on this real life DNB example.

Topics: Best Practices, Case Study, sap, EPM, webcast

How to: Create Conditional Logic in SAP BPC, version for NetWeaver

Posted by Will Leonard on Tue, Apr 11, 2017 @ 09:04 AM

Applicable Releases:

Software Component Version  Support Package       
  • CPMBPC 800 SP18+
  •  CPMBPC 801 SP11+
  •  CPMBPC 810 SP07+

1. Business Scenario

Business logic is often dependent on which process is being performed.  For example, during Budget season, an EPM application will execute one set of logic over many different time periods.  However, during a monthly Consolidation process, a different set of logic will be executed to prepare data for financial reporting.

Analysis for Office and the BPC Plug-in – everything you need to know!

Posted by Adam Hess on Wed, Apr 05, 2017 @ 09:04 AM

Long term BPC customers know that one of the tool’s key strengths, its powerful and easy to use reporting  interface, can also be a challenge at inconvenient times. Over
the history of BPC’s reporting interface, dating back to OutlookSoft with venerable EvGet functions, relatively few changes have been made to the system.

Topics: BPC, Analysis Office

EPM Maturity Model - How do I use it?

Posted by Peter Bull on Mon, Mar 27, 2017 @ 14:03 PM

In the last article we looked at the definition and content of the EPM Maturity Model.

In this article we’ll look at how to gauge EPM Maturity and how to identify areas to improve. At the core of the Maturity Model is the definition of:

  • Right Model
  • Right Audience
  • Right Time

Across these definitions we lay a scale that moves from low levels of maturity to high levels of maturity:

Topics: Best Practices, Process Improvement, Thought Leadership, Enterprise Performance Management (EPM)

EPM Maturity Model - What is it?

Posted by Peter Bull on Thu, Mar 23, 2017 @ 09:03 AM

Organizations need to plan, measure and manage across Strategy, Operations and Finance. Isn’t that what Enterprise Performance Management (EPM) is all about? It seems like a simple formula. But what about if we change the question to ask what makes successful EPM and successful organizations? If we start with the definition that “Successful EPM drives organizations that dramatically outperform their competitors in terms of both financial and non-financial results” – this gives a very different perspective on the importance and value of EPM. It also means that you need to have a mechanism and framework to objectively review your EPM capabilities and relative maturity.

Topics: Best Practices, Thought Leadership, Enterprise Performance Management (EPM)

Subscribe