Beginner
SAP HANA Service, explore Operational Reporting for SAP ECC using test data
2019-07-23
40 min.
Clone and deploy the Calculation Views for SAP ECC 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
Prerequisites
- You have a productive instance of the SAP Cloud Platform, SAP HANA Service on Cloud Foundry or have signed up for a trial account in SAP Cloud Platform or an on-premise instance of SAP HANA with XS Advanced (e.g., SAP HANA, express edition)
- You will need administration access to a tenant SAP Analytics Cloud to import the pre-built models
If you would like to deploy the SAP HANA Operational Reporting Templates for SAP ECC including the artifacts to integrate with an SAP ECC system, refer to the instructions in the repository
Step 1: Clone repository
Right-click on the workspace in SAP Web IDE and choose Git -> Clone Repository
Enter the following repository:
https://github.com/SAP-samples/hana-xsa-live-reporting
If you are using the trial in SAP Cloud Platform and get the error
No hdi-shared plan available found in this space, switch to theEU10region. Check this blog post for instructions on changing the region.
Right-click on the repository and chooseProject -> Project Settingsto change the space where it is deployed
If you get an error, stating version
2.0.2.0 (installed) is incompatible with 2.0.40.0in the trial account in SAP Cloud Platform, change the plugin version in the hidden file.hdiconfig
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.
Remove the folder db/cfg_CONFIGURE_ME
Step 3: Build and preview the calculation views
Right-click on the db folder and choose Build.
The build log should show a successful deployment. You can scroll up to check for any errors.
After successful deployment, you can preview the data in each of the models. For example:
Step 4: Install Information Access
Step 5: Import the models into SAP Analytics Cloud
You will need the following roles for the import and deployment: Admin, Analytics Hub Admin, BI Admin
Navigate into Deployment -> Import.
Choose Upload.
Select the source file downloaded from the repository and confirm the upload.
Confirm the import.
You will see a success message next to the import job…
… And the details of the imported artifacts if you click on the job:
Navigate into Browse -> Files. The Public folder will contain the imported models and stories
Click on any report to log in through the SAP HANA Analytics Adapter and fetch the test data from SAP HANA
