Corporate performance management refers to a set of solutions targeted at decision-makers who can leverage these solutions for effective budgeting, reporting, and decision support.
Everyone who creates reports, inputs and manipulates data (especially planning data) or does calculations on the data loves spreadsheet solution because they are easy to use and allows for lot of flexibility. Again the other major driving factor is that the business users can themselves manage it and do not have to depend on their IT friends to help them do their job.
Some of the top reasons users want to go with spreadsheets:
• Ease of use
• Minimal training
• Minimal involvement of IT
• Easy authoring of workbooks or reports
Why not spreadsheets?
Though spreadsheets provide the above advantages, the biggest comment against spreadsheet is ‘Considerable individual flexibility without control’. Since decision makers rely on the information available to take critical decisions, having all the flexibility can be very serious problem, if the information provided are not accurate. Also spreadsheets are standalone systems that do not have information on their own and it would be difficult to get data into spreadsheets, without going through several manual steps before bringing the requisite information into spreadsheets, including updated information. The other issues are performance and scalability, when spreadsheets are used for reporting with hundred of thousand of records, data manipulation or performing complex calculations such as top down allocations, massive data copy etc.
So to summarize the following are the issues for going with spreadsheets:
• Lack of control
• Accessibility - Manual process to get information
• Lack of updated information
• Scalability – large data volumes, complex calculation logic
Is it easy to move users away from spreadsheets?
Though IT may want to move users away from spreadsheets, it is impossible to move the users away since it is the most flexible and fast tool available for the said needs of reporting and data manipulation. We also have to understand the difference between two types of users – ‘Producers’ and ‘Consumers’. ‘Producers’ are the administrators who create the reports or input sheets to collect information and ‘Consumers’ are the business managers who use the information or input the information. From a recent study both these user community want to use spreadsheets extensively. So it is going to be very difficult to move users away from spreadsheets.
So, what is better than spreadsheets?
Given the conclusion that it is going to be difficult to move users away from spreadsheets, what would be an ideal solution for the above needs? The solutions that offer best of both worlds will be the winner. The solutions should be as flexible and usable as spreadsheets and should overcome the above inherent issues of spreadsheets. CPM solutions are empowered to offer solutions that can take care of both. SAP CPM solutions with the flexibility of spreadsheet like interface and accessibility to underlying SAP ERP data would be the solution that satisfies the needs – and would undoubtedly be better than spreadsheets
Top 10 Tech Trends of 2017 in India
With the passage of time, technology is advancing rapidly, owing to its dynamic elements. Not only has it enriched our lives with its ready accessibility, technology has simultaneously revolutionized...
TECH SPECS AND FUNC SPECS
HI SAP EXPERTISE, Can anyone tel me how to write tech specs if u r given functional specs in a implementation project (abap)!!am i looking forward for ur ans if possible pls send ne documents to...
Virtual SAP TechEd '06
Is a compilation of over 170 conference sessions recorded live at SAP TechEd '06 Amsterdam, Virtual SAP TechEd '06 lets you learn anytime, anywhere. This sounds very useful but very costly...
Virtual SAP TechEd - Complete Package
The Virtual SAP TechEd Complete Package is the comprehensive assembly of live, SAP TechEd conference sessions recorded at the 2008, 2007 and 2006 SAP TechEd conferences. With the...