How to Accelerate SAP Analytics Cloud for Planning Implementation

Enterprise Performance Management (EPM) is a critical process in every organization to drive results and performance. In this blog, I describe how using a template-based implementation approach with our extended planning and analysis accelerator (xP&A) will accelerate any SAP Analytics Cloud (SAC) for planning implementation.  

Throughout my 25+ year career, I have implemented various EPM solutions across several platforms (e.g. Excel, Oracle, SAS, SAP, Solver, Microsoft, Anaplan, etc.) and most industry verticals (consumer packaged goods, retail, insurance, banking, healthcare). Each technical solution has their unique strengths and weaknesses, with each industry vertical having its own complexitiesRegardless of what system is used, one key influencer of success is having a solution that is content specific, with pre-packaged content and built-in best practices.   

One method to implementing an EPM solution is to take a blank slate approach, whereby requirements are gathered, a design created and a process implemented. This often involves looking at existing planning logic (usually in Excel) and recreating it in the systemHowever, this is very time consuming to build and requires additional time to test and maintain. With this method, the logic is usually created in some sort of scripting engine (such as SAC planning data action, BPC scripting, Hyperion calc script), which like any other programming language, must be developed, tested and retested for any changes to system parameters.  

A second approach is to utilize a templated system, in which core set of logic, reports and processes are used to customize to a specific environment.  The solution is already partially built, thus reducing time and cost to complete. In addition, the components have already been tested, reducing one of the largest and often underestimated phases of a project, testing and remediation. In addition, with a templated system, the templates, reports, calculations, models, etc. are built with best practices specific to the industry vertical and incorporate refinements from other clients with similar problems and solutions.   Eventually, these are collated to a common group of best practice functionalities This is exactly what is offered with Protiviti’s extended planning and analysis accelerator (xP&A). 

As an example of the difference between blank slate and template systems, I share two personal examples. One is blank slate approach with superior technology; the second is a template system approach with a less sophisticated technology.  The first is from one of my first planning implementations in 2003. I worked at a large property casualty insurance company where we implemented Hyperion Planning. We used the blank slate approach and recreated the planning system from scratchWe implemented insurance logicbased on an actuarial model to calculate planned revenue and losses for their commercial and personal insurance lines. Each step of the way required extensive testing, validation and remediation. The project took approximately one year for three to four consultants to build and the cost was somewhere in the $1 million range to complete 

Fast forward a few years to 2008. I was implementing a BusinessObjects Planning (formerly SRC) packageSRC, not the most sophisticated technology platform, was basically a SQL server database on top of Excel. What it lacked in technical sophistication was made up with pre-built solutions for banking. It had extensive business logic to calculate banking logic such as net interest income and expense with key drivers including interest rates for loans and deposits. We also utilized the templated system for payroll and operational expense planning.  We were able to deliver the solution to the client in a three-month timeframe, fully tested and deployed to productionThe overall cost was approximately $150,000 (nearly a tenth the cost of my first example above) and we delivered a more complicated model and more functionalities including full P&L and balance sheet planning system with detailed payroll, OpEx and Capex). This example illustrates the benefit of a templated system: better solution, faster delivery, with less risk and less cost. And in this case, with a less sophisticated technology 

Since then, SAP has developed a new planning solution SAC for planning is the flagship solution for all SAP planning and analytics. It is cloud-based and has incredible features and functionality including advanced and predictive analytics.  From a technical perspective, SAP is now one of the market leaderin cloudbased EPM solutions. But just like when I had implemented Business Objects planning many years ago, a vertical pre-built solution is critical to project success and to unlocking the value to an organization 

This is where Protiviti’s xP&A comes into play. xP&A is Protiviti’s planning solution accelerator for industry verticals (consumer packaged goodsretail, banking, insurance and healthcare) and line of business functionality (payroll, CapEx, OpEx). The solution is to streamline projects, similar to what we had done with banking\SRC as mentioned above and create pre-packaged solutions that can be deployed to clients with reduced implementation timeline, reduced risk and embedded best practices. In addition, with SAC we have industry-leading technology, giving us the best of both worlds.   

To learn more about how Protiviti’s xP&A platform with SAC planning works, read this story about our work with client National Vision, where we delivered a successful retail planning solution to support operational planning.  

xP&A easily adapts to industry-specific needs and offers functionality for headcount and compensation planning, CapEx planning and OpEx planning, along with builtin best practices for other design considerations such as allocation logic (data actions), security, model and dimension design.  Basically, we have worked out all key design considerations to facilitate an efficient, cost effective and robust design.  This, paired with a superior technology platform in SAC for planning, will enable a significant return on investment. 

 

To learn more about our SAP Analytics Cloud capabilitiescontact us. 

David Bath

Associate Director
Enterprise Application Solutions

Subscribe to Topics

Digitally transforming business with #Dynamics365 CE provides organizations with easy configuration and #integration with other #Microsoft products, fewer post-deployment issues and can be accessed anywhere. Read more in the #Technology Insights blog: http://ow.ly/AueX50GqQZs

In Protiviti's #cybersecurity #webinar series, learn insights from the effectiveness of crisis management response in #ransomware attacks to articulating core concepts of #zerotrust and the toolsets needed to architect zero trust. Explore sessions here: http://ow.ly/qVLp50Gi52T

Meeting compliance obligations is complex. Join us November 11th to see how #Microsoft Compliance Manager helps manage your #compliance requirements with greater ease and convenience. Register today: https://bit.ly/3DGIUye

#MicrosoftCompliance #Microsoft365 #compliancemanager

Businesses are benefiting from new value they’re creating with #data they already have. This #ProtivitiTech blog post demystifies data #monetization and explores how businesses can capitalize on #insights they develop from their data. Read more: http://ow.ly/UUr350GqPvQ

In this #webinar, Protiviti experts break down the approach to developing an #IAM program strategy that will keep organizations safe and give teams peace of mind. Register now: http://ow.ly/qDjC50GpFV5

#identity #identityaccessmanagement #security

Load More...