Data Quality Management (DQM) with SAP BW

The Challenge: efficient & central Data Quality Management

 

New IT innovations such as the Internet of Things (IoT) or the mobile Internet increase the data volume at an enormously fast pace and also confront your company with very great challenges in terms of securing your data quality. 

In times of big data, more than half of all companies consider the quality of their data to be critical for business decisions. Poor data quality leads to lower employee and customer satisfaction, but also to higher costs: manual quality assurance is about five to ten times more expensive than an automated variant.

It is difficult to measure and track success in a data quality offensive. Moreover, the result of a repetition is not always the same and the quality of the validation strongly depends on the user. IT must first create its own validation options. This creates further validation islands. Data entry checks take place in dialog, but in practice there are always cases where data has not been entered during validation, either through interfaces or alternative input options.

SAP Business Rules Framework (SAP BRFPlus) and SAP Hana Rules Framework (SAP HRF)

Our DQM solution can be based on both SAP BRFPlus and SAP HRF. Alternatively, the rules can also be made directly from IT in ABAP. Both frameworks can be used to create complex sets of rules that make the rules transparent and readable. Simple logics such as "if then else" can be applied within the set of rules. Dashboard conversion is usually done using the SAP Lumira Designer.

 

Daily Process with Data Quality Management

 
DQM daily process

 

Your Advantages

  • You can easily create rules for several source systems (existing in the SAP Business Warehouse) in a central location
  • Errors can only be relevant for reporting, since only one key figure formed in reporting is falsified, but it does not in itself pose a problem in the previous system.
  • You can track errors and measure your success in troubleshooting.
  • How many bugs have been fixed, how many new bugs have been added or still exist? These questions are processed in the error statistics in a dashboard.