Ingo Röttting

Extension of an existing SAP S/4HANA embedded Analytic data model in an SAP Simple Finance Release 1809 environment.

According to customer requirements, standard Transient Providers (including the Trial Balance) were adapted and provided as customer-specific reports with Analysis for Excel.

Furthermore, by creating customer-specific CDS Views, the virtual supply of texts and characteristics within the embedded BW on the SAP S4HANA environment was expanded. Among other things, navigation attributes were provided for the virtual supply of data via composite providers.

Within an SAP BW 7.5 on HANA environment, an analysis application is being developed for evaluating and reporting balance sheets and profit and loss accounts for approx. 450 franchisees. Furthermore, a benchmark comparison is being developed within this application, which rates the individual franchisees against each other. The data is supplied via XML and CSV files as well as via a master data maintenance view and the possibility of versioning benchmark values via an SAP BPC 10.1 embedded development. Reporting is done with SAP BO Analysis for Excel Workbooks as well as the automatic generation of PDF documents via the SAP BW Broadcaster.

Development of an analytical mixed data model in SAP Simple Finance within an SAP S/4HANA Release 1709 environment. In the SAP Simple Finance area, an analytical data model is developed for reporting profit and loss, balance sheet and statistical key figures, which takes customer-specific requirements into account.

A pure VDM data model is compared with a mixed data model that uses CDS views as a data procurement level and realizes this within the SAP S/4HANA embedded BW (SAP BW 7.5 on HANA) to map business logic. SAP Analysis for Excel is used as a reporting tool.

As a second module, a cost center planning was developed within SAP BPC 10.1 embedded, planning-ready queries were created and integrated into SAP Analysis for Excel Workbooks.