Column5 - EPM Thought Leadership Blog  

EPM Thought Leadership

EPM vs Analysis Office

Posted by Richard Hynes on Tue, May 24, 2016 @ 15:05 PM

Many of you will have heard that the EPM Add-In is being replaced with Analysis Office. This is not quite true: the EPM Add-In is being replaced by the EPM Plug-In which is a part of the new Analysis Office Add-In which also contains a Plug-In called Analysis. I hope that is clear.

If not, let me explain further.

Read More

SAP BW-IP, SAP BPC NW 10.1 Standard and SAP BPC NW 10.1 Embedded Compared

Posted by Richard Hynes on Thu, May 05, 2016 @ 15:05 PM

 

This blog will present a comparison of BW-IP, BPC NW 10.1 Standard and BPC NW 10.1 Embedded. Each of these products is currently offered by SAP as planning solutions, but each has characteristics and functionality which will influence the decision to use one rather than another. This article aims to clarify the differences between each of the products and aid in the decision as to which of them to implement. Each product will be better suited to a given company’s needs according to certain criteria, and this blog will set out to identify which product is best in each case.

Read More

SAP BPC: Top 5 Most Viewed Blog Posts of 2016 (So Far)

Posted by Gracie Arnold on Mon, May 02, 2016 @ 13:05 PM

For those who missed our 2016 blog posts! Here at Column5, we believe that user education is paramount. Because of this we provide our viewers and clients many free educational resources. If you love a post or want us to post something specific, throw us a comment below! 

Read More

Designing EPM Reports Around the Campfire

Posted by Steve Way on Thu, Apr 21, 2016 @ 08:04 AM

Here in the Pacific Northwest of the United States, people are either “fair weather” campers or “all weather” campers. When I was a young Boy Scout, my Scoutmaster (a former Marine) could politely be described as an “all weather” camper. He had no regard for cold blowing horizontal rain or snow….we went camping anyway. The best part of the trip was roasting marshmallows and drying out around the campfire, weather permitting. To distract all of us cold campers from turning it into a complaint party, he would engage us in games and stories. His favorite was the age old game of one person telling a story to your neighbor, and that person tells it to his neighbor and so on. Of course the story that is told by the last person bears little resemblance to the original story.

Read More

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.

Read More

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.

Read More

11 Dirty Secrets of EPM Projects Part 2

Posted by David Den Boer on Wed, Apr 06, 2016 @ 10:04 AM

 Baking_BASICS_1.jpg

This is the second part of the original post of 11 Dirty Secrets of EPM Projects.

"I thought for Column5's 11th birthday, I'd give our more than 1000 blog readers a gift! I’ve wrapped it up and called in the 11 'dirty secrets' of EPM projects. I know this is heresy to disclose some of these EPM professional services insider secrets, but I care more about you being successful than I worry about the flak I will inevitably get by letting you in on these secrets."

Let’s continue:

Dirty Secret #6: Systems inadvertently create dependency on 3rd party 

Read More

11 Dirty Secrets of EPM Projects

Posted by David Den Boer on Tue, Apr 05, 2016 @ 09:04 AM

Though the actual market size may vary, a reasonable estimation states that throughout the world more than $4 billion is spent annually on EPM consulting alone. Yet, EPM projects often fail to return positive value to those investing in them. Why is this outcome so prevalent with this technology solution in particular? I thought for Column5's 11th birthday, I'd give our more than 1000 blog readers a gift! I’ve wrapped it up and called in the 11 'dirty secrets' of EPM projects.

I know this is heresy to disclose some of these EPM professional services insider secrets, but I care more about you being successful than I worry about the flak I will inevitably get by letting you in on these secrets. Let’s begin:

Read More

IT Best Practices for EPM Implementation Success

Posted by Tony DeStefanis on Mon, Mar 28, 2016 @ 14:03 PM



If you follow best practices for SAP implementation and use, whether it be BPC, Disclosure Management, ECC, HANA, ABAP, or many others, you will be successful in quantifying the benefits from the suite of products you choose.  Our perspective is that there are no inherently “bad” SAP products, just poor implementation that can make your product use more stressful than it needs to be.

Read More

Calculating Column Totals Dynamically - SAP BPC

Posted by Deb Silverman on Wed, Mar 16, 2016 @ 12:03 PM

Need to calculate a grand total dynamically?  Shifting of Local Members giving you a headache?  I previously used Indirect() functions, but I discovered with larger reports this put a drag on reporting performance.  To sum from the first report column to the last report column I was using something like this  =SUM(EPMPOSITION(1):INDIRECT(ADDRESS(ROW(),COLUMN()-1))), which is not considered best practice but I got results!

The SAP definition: “EPMALLMEMBERS is used to perform a calculation (such as sum or average) on all the members displayed in a row or column axis, whether the axis contains one or several dimensions

HOW?  Here are some examples:

Read More

Subscribe to Email Updates