SAP HANA Operational Reporting Templates for SAP ECC

Description

The current repository contains templates with Calculation Views for SAP HANA and models and setup instructions for connecting to this content from SAP Analytics Cloud.

The Calculation Views and other design-time artifacts can be cloned into SAP Web IDE for SAP HANA. The artifacts can be deployed into SAP HANA, extended application services, advanced model (XS Advanced).

Available templates

Master Data: Material Master List, Customer Master List, Vendor Master List
Sales: Sales Order List (Header), Sales Order List (Items), Sales Order List (Scheduling), Sales Organization Analysis, Credit Memo Analysis, Billing Document List, Return Analysis (SD), Perfect Order Fulfillment, Credit Memo vs. Billing Document Ratio Report, Stock Overview (SD)
Purchasing: Purchase Orders Analysis, Goods Receipts / Goods Issues , Logistic Invoice Analysis, Stock Overview (MM) , Order History Overview
Shipping: Flexible customer open item reporting (Debtor), Flexible vendor open items reporting (Creditor), Overdue item reporting, Customer open item analysis (Day sales outstanding )
5.Accounting: Outbound Delivery Overview, Outbound Delivery Items Overview, Outbound Deliveries for Picking, Outbound Delivery Items for Picking

Requirements

The current repository contains sample data so that the models can be tested without configuring the replication through Smart Data Integration.

The replication from the SAP Netweaver system is done through the activation of Operational Data Provisioning extractors and the ABAP adapter.

For replication:
- These templates leverage the Operational Data Provisioning (ODP) extractors embedded in the BW component in an ECC system. You can get further information about them in the introduction to ODP
- Follow instructions in note 1931427 - ODP Data Replication API 2.0 to check or fulfill prerequisites in the source system
- Version 2.3.5.2 or higher of the Data Provisioning Agent available in the SAP Development Tools or the SAP Software Downloads Center
To clone the calculation views:
- SAP HANA (on-premises) with XS Advanced (including, SAP HANA, express edition).
- SAP Web IDE for SAP HANA in XS Advanced
- Permissions to create a user-provided service in the same organization and space in which the HDI container will be deployed
To expose the models through Information Access
- The latest version of the SAP HANA Analytics Adapter, available in SAP Development Tools

Download and Installation

Using Sample data

You can find step-by-step instructions in the following tutorial: https://developers.sap.com/tutorials/haas-ecc-operational-reporting-sample-data.html

In SAP Web IDE, right-click on the Workspace and choose Git -> Clone Repository. Paste the URL for the current repository and clone.
Remove the folders with names CONFIGURE_ME in db and in db/src
Right-click on the db folder and choose Build. After a successful build, the models can be executed.

Using Smart Data Integration

The integration requires the publication of ODP extractors from the ABAP system using the ABAP adapter in Smart Data Integration. The Calculation Views will be deployed in an HDI container and the virtual tables will access a remote source. The remote source is accessed in the same way as a plain or replicated schema. Further context about this process is provided in this blog post.

Install the Data Provisioing Agent in the source ABAP system
Connect the Data Provisioning Agent to the SAP HANA System.
Register the ABAP Adapter with the SAP HANA instance.
Create a Remote Source based on the agent you have registered. Call the remote source SAPECC unless you want to adapt the references to it in virtual tables. See Step 6 in this tutorial for reference.

Create a user with permissions to the remote source. Here is a sample SQL statement creating a user and setting permissions to a source with name SAPECC

CREATE USER PLUSR PASSWORD "HanaRocks01" NO FORCE_FIRST_PASSWORD_CHANGE ;
CREATE ROLE CCROLE;
grant "CREATE VIRTUAL TABLE", "DROP", "CREATE REMOTE SUBSCRIPTION", "PROCESS REMOTE SUBSCRIPTION EXCEPTION"  on remote source "SAPECC" to CCROLE with grant option;
grant  CCROLE to PLUSR with admin option;

Create a user-provided service to provide the credentials for access to the remote source form the HDI Container. Call it CC_ACCESS unless you want to adapt references to it. See sample steps in Step 3 in this tutorial
Adapt the mta.yaml file to include the user-provided service as a resource for the HDI Container. See Step 4 in this tutorial for an example.
Remove _CONFIGURE_ME from the folders cfg, src/loads and from the file remote.hdbgrants. Be sure to Save all the modified artifacts

Note: The virtual tables use a remote source called SAPECC, adapt them if the name of your remote source is different. The .hdbgrants file refers to a user-provided service called CC_ACCESS and also references the remote source SAPECC. Adapt them if necessary.
Delete the folder demo_loads.
Right-click on the database module and choose Build.
You can now execute the flowgraphs and preview data on calculation views
It is recommended to apply performance tweaks to the Calculation Views once they have been adapted to your reporting needs. Check the SAP Help for suggestions.

Deploy the SAP HANA Advanced Analytics Adapter

The SAP HANA Advanced Analytics adapter allows for the consumption of Calculation Views in HDI Containers through Information Access. SAP Analytics Cloud uses Information Access for Live connection. Other tools, such as Analysis for Office work with this connector too.

Follow the instructions or the installation on on-premises systems.

Configure SAP Analytics Cloud

Create a connection to your HANA Analytics Adapter entry endpoint called HANALIVE. Note that the models currently depend on the connection being called HANALIVE. This can be adapter later.