Skip to Content
  • Developers
  • Tutorials
  • SAP HANA service for SAP BTP explore Operational Reporting for SAP ERP Central Component using test data

SAP HANA service for SAP BTP explore Operational Reporting for SAP ERP Central Component using test data

test
0 %
SAP HANA service for SAP BTP explore Operational Reporting for SAP ERP Central Component using test data
Details

SAP HANA service for SAP BTP explore Operational Reporting for SAP ERP Central Component using test data

Thomas Jung
Thomas Jung
January 27, 2021
Created by
Lucia Subatin
July 22, 2019
Beginner
40 min.
SAP HANA service for SAP BTP, SAP HANA, Beginner, SAP HANA, express edition, Tutorial
Clone and deploy the Calculation Views for SAP ERP Central Component Operational Reporting and import test data to consume from SAP Analytics Cloud

You will learn

  • How to import and deploy the template calculation views into SAP HANA using SAP Web IDE
  • How to remove the pre-built artifacts for Smart Data Integration to explore the templates using the test data
QR code

Prerequisites

This tutorial cannot currently be completed with a trial account.

If you would like to deploy the SAP HANA Operational Reporting Templates for SAP ERP Central Component (ECC) including the artifacts to integrate with an SAP ERP Central Component system, refer to the instructions in the repository

Step 1: Clone repository
View Full Instructions

Right-click on the workspace in SAP Web IDE and choose Git -> Clone Repository

Clone repo

Enter the following repository:

https://github.com/SAP-samples/hana-xsa-live-reporting
Clone repo

If you are using the SAP BTP trial and get the error No hdi-shared plan available found in this space, switch to the EU10 region. Check this blog post for instructions on changing the region.
Right-click on the repository and choose Project -> Project Settings to change the space where it is deployed
Clone repo


If you get an error, stating version 2.0.2.0 (installed) is incompatible with 2.0.40.0 in the SAP BTP trial account, change the plugin version in the hidden file .hdiconfig
Clone repo

Done
Log on to answer question
Step 2: Remove data replication artifacts

This repository includes virtual tables and flowgraphs to replicate data from an SAP ECC system. You will use the sample data instead.

If you want to deploy the replication artifacts, you will need to configure cross-container access. Follow the instructions in the README file in the repository

Remove the artifacts related to replication. Right-click on db/src/loads_CONFIGURE_ME and delete it.

Delete replication

Remove the folder db/cfg_CONFIGURE_ME

Delete replication
Done
Log on to answer question
Step 3: Build and preview the calculation views

Right-click on the db folder and choose Build.

Build module

The build log should show a successful deployment. You can scroll up to check for any errors.

Build module

After successful deployment, you can preview the data in each of the models. For example:

Build module
Done
Log on to answer question
Step 4: Install Information Access

If you are using a productive instance of the SAP HANA service for SAP BTP, you can use the Information Access (InA) protocol to connect with SAP Analytics Cloud or other reporting tools using the HTTP protocol for live connections.

Use these instructions to deploy the XS Advanced HANA Analytics Adapter into the SAP BTP, Cloud Foundry environment.

When configuring the connection from SAP Analytics Cloud, call it HANALIVE.

Note: For on-premise SAP HANA systems or SAP HANA, express edition, follow the instructions in this series of blog posts instead.

Once connected you can continue by creating reports in SAC to consume the Calculation Views deployed in earlier steps.

Done
Log on to answer question

Next Steps

Navigate tutorial steps

QR Code

QR code
Back to top