SAP Data Analysis

From Section Data Analytics

Data analyses of various market players are generally standard analyses that are generated by a Data Dump from SAP. Extracting data from a SAP environment is often not possible due to lack of the proper authorization. Moreover, the extraction of data is limited to a specific number of document numbers per extraction. This requires the same extraction to be executed over 30 times when an extensive amount of data is to be retrieved.

Retrieving data in multiple steps brings the risk of the format of the data not always being identical. As a result, there are no unequivocal results available and many manual adjustments are necessary. In the case of extensive data, SAP often breaks off the analysis, because runtime limits are exceeded. In addition, due to restriction of the size of reports in SAP, created data files cannot always be copied to a pc.

Solely standard analyses are possible, which does not sufficiently take into account the complexity of business models and specific risk domains.

Another bottleneck could be the company's IT policy that simply does sometimes not allow to perform a data dump or a ABAP even if the relevant stakeholder's consider this a must.

Something to check first before you purchase or offer your services.

What is your experience? Any lesson learned to share?