Finance Owned and Managed SAP CPM – Part V
Just came back from the SAP Reporting and Analytics Conference where about 1000+ SAP Customers, Partners, Analyst,Consultants and Employees assembled to look at the most comprehensive set of BI , CPM and Reporting solutions from SAP. The business user community assembled in this conference were very excited about the prospect of they owning and managing the CPM solutions. So I just thought of writing the concluding part of this blog series where we discuss the easy and highly flexible administration capabilities available in SAP CPM products. Here we discuss the aspect of input schedules and reports that can be modeled using Excel and also some of the BPC functions which have prefix of ‘EV’.
Schedule and Report authoring
This is the part that finance users like the most. They want all the flexibility to model input sheets (or schedules) for budgeting, planning and forecasting. This is because every quarter there are new information needed to captured or accommodated into the forecasting cycle. This could be adding a new territory, or modifying the layout to bring regions from columns to rows, or modifying the assumptions. Given this requirement, the tool that allows them to have all this flexibility in the past was spreadsheets. But as pointed out by in an earlier How are EPM solutions better than spreadsheets? on the perils of spreadsheets, finance users would like to have more controlled tool but with the flexibility of spreadsheets.
SAP BPC provides this flexibility extensively. This is because the modeling of the input schedules can be done in Microsoft Excel, in what is called as the control panel. Here the finance users can use most of the Excel native functionality, formulas to model the schedules. The finance users can also build dynamic reports that allow multi level drill down of data from the top level region. In addition to this finance users are provided with a library of predefined dynamic report/schedule templates that they could use to create schedules for their requirements. These templates would cover majority of use cases that the finance users would require for planning, forecasting or reporting. The below screenshot shows a view of picking the report templates.
Finance users like functions with easily understood parameters. They have been extensively using these functions in spreadsheet, that help them do various tasks, in a very easy and intuitive way. The SAP BPC product extends to have similar functions that are prefixed with the letters ‘EV’. EV functions includes functions to pull text information, do calculations, filter data based on properties, drill down the hierarchy levels of data, allows modification of layouts and manages data. There are also some EV functions that provide financial ratio analysis. EVDRE function allows for authoring the entire layout.
Good, now you have learnt a lot about how SAP CPM is finance owned and managed. Just to summarize the features that make up the finance owned and managed concept possible are given below:
- Explorer view administration environment
2. Context sensitive action panes
3. Concept of Save As
4. Excel embedded administration interface
5. Wizard driven interface
6. Business Error messages for troubleshooting
7. Robust Data Manager
9. Schedule and Report authoring
10. EV Functions
You can find more details of the above in each of the earlier blogs – Part Finance owned and managed SAP CPM – Part I, Finance owned and managed SAP CPM – Part II, Finance owned and managed SAP CPM – Part III, Finance owned and managed SAP CPM – Part IV Hope you enjoyed this blog series.