SAP BPC systems receive data from a range of external sources. The planning and configuration necessary to insert this data into the system is an important aspect of an implementation. The integrity of data is vital, and invalid data can affect processes within SAP BPC, such as calculations and reporting. Safeguards should be in place to prevent the entry of invalid data.
The main methods employed to enter external data into a SAP BPC system are:
- Interfaces to source systems such as an ERP or SAP BW system.
- Flat file uploads.
- Input schedules for manual data entry.
The first two sources – interfaces and flat files – are tested, configured, and operated by experienced administrators and consultants who understand the data structures of source systems and SAP BPC, so these usually do not create problems. The greatest risk is with data entered through input schedules by users who, whilst knowledgeable about the commercial functions of their organisations, are not experts in the data structures of financial information systems like SAP BPC. The techniques available to ensure the integrity of data entered via input schedules are the focus of this article.