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

SAP Analytics
Thought Leadership

[TECH ALERT] How to fix the top 10 issues for BPC Microsoft Environments

Posted by Manus Cornelius on Wed, Apr 21, 2021 @ 03:04 AM

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!

Topics: Performance, Microsoft, BPC (Business Planning & Consolidation), Technical, User Experience

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

[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

BREXIT and the Benefits of Constant Currency Reporting

Posted by Martin Lloyd on Thu, Oct 13, 2016 @ 05:10 AM

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.

Topics: BPC (Business Planning & Consolidation), reporting

Integrated Planning with SAP BPC 10.1 Standard

Posted by Richard Hynes on Tue, Apr 19, 2016 @ 08:04 AM


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.

Topics: Thought Leadership, Financial Information Management, BPC (Business Planning & Consolidation), Forecasting, sap

EPM Execute API - SAP BPC

Posted by Deb Silverman on Wed, Apr 13, 2016 @ 11:04 AM


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.

Topics: Excel, BPC (Business Planning & Consolidation), best practices for epm, API, VB

HOW TO: Suppress Send Dialog Box in SAP BPC

Posted by Deb Silverman on Fri, Mar 04, 2016 @ 09:03 AM


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.

Topics: Thought Leadership, BPC (Business Planning & Consolidation), best

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)

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