[Skip to content]


Blog Posts from the team at Budgeting Solutions

Separating out the wheat from the chaff can be challenging and sometimes the right facts are hard to find.  Our blogs contain a wealth of information gathered from many years of experience by our consultants dealing with everyday issues in projects on client sites.

They may provide clear insight on particular problems or act as a launching pad to clarify your thoughts on issues with how to deliver robust performance management solutions.

Is your planning application promoting bad behaviour by your finance team?

User AvatarPosted by James Salmon at 17/9/2018 2:35:17 PM
content type Industry Perspective

There is a trend in the performance management space to move away from the traditional spreadsheet-based planning application to a browser-based solution. This is, of course, a welcome move, as it automates a process which is very manual and error-prone. The business benefits of this new approach are well documented — reductions in cycle time, more confidence in the numbers, more time for analysis, etc. There are many.

In an earlier post on things to consider when selecting a planning application, I discussed some of the problems that can hinder reporting and analysis with these applications. One of the issues is the lack of spreadsheet integration and “owned by finance” reporting capabilities.

Finance users love their spreadsheets! They are very easy to use and extremely flexible. They also have very powerful, flexible and pixel-perfect reporting capabilities. You get lots of control and options for formatting (cell by cell), alignment, charts and printing (“fit to page,” for example). We all know that our finance executives have very specific requirements for their reports — fonts, underlines, column spacing and so on. Spreadsheets make it easy to meet their needs in this area.

This is where browser-only performance management applications fall down. Their lack of reporting flexibility may encourage poor behavior — the type of behavior that you were trying to get away from. Imagine being presented with an ad hoc reporting task. Finance executives require an answer to a question in their preferred highly-formatted report style. With a browser-only performance management solution, you may be tempted to copy and paste the data from the browser into a spreadsheet or perform a “data pull” into a .csv file and then manipulate the data in the spreadsheet using VLOOKUPs and SUMIFs. As we well know, any time you cut and paste data in that manner, it introduces the possibility of error that always comes with manual processes. Not the kind of data management behavior that we want to force people into by leaving them no alternative.

The approach taken by IBM Planning Analytics is different. The software provides an extremely powerful and flexible spreadsheet capability alongside sophisticated browser-based capabilities. Each of these sets of features augments the other so that users get the best of both worlds. Because the tool is fully integrated with the underlying database, users benefit from centralized definitions, business rules and security, which also keeps auditors, compliance officers and IT happy.

Meanwhile, though, end users can analyze and report on the data in the spreadsheet environment that they are most familiar with. That gives them the tools they need to meet tight reporting deadlines and satisfy even the most exacting formatting requirements of their executives. Thanks to this combination of features, Planning Analytics delivers uncompromising performance while discouraging the poor behavior described above.

Would you like some hands-on experience with IBM Planning Analytics so you can learn about more of its capabilities? Register for our free demonstration

Recent posts

Blog Category

Posts by Date