Part 2 of Creating a Calculation View Based on the Table of the SAP Cloud Platform IoT Message Management Service

In this article, we are going to create a HANA Calculation View that is based on the SAP calculation Cloud Platform IoTMMS table that we set up in order to receive sensor data.

In most cases, the information that is obtained from sensors needs to be moulded and filtered in a particular manner before it can be utilised by the charts in the most effective manner possible.

This can be accomplished in a variety of stages of the Internet of Things pipeline depending on the use case.

In our particular scenario, we will be modifying our data by developing a Calculation View in order to make it more suitable for consumption by a visualisation tool called SAP BusinessObjects Cloud.

Pre-requirements:

1- You have access to an HCP account (the trial version will also work) and your user has permission to make use of the Web development Workbench.

2 – The INA USER role and "Select" privileges need to be granted to the SAP HANA user in order for us to be able to access the tables we need (see these pre-reqs).

3- You already have HANA Studio installed and are using it.

Tools Available on the SAP Cloud Platform

SAP rating calculation HANA Tools

If this is not the case, you can proceed with the steps that are outlined here and select the SAP Eclipse/Mars directory (or a later version of Eclipse)

NOTE: If you prefer, rather than using HANA Studio, you can complete this tutorial by using the SAP HANA Web-based Development Workbench instead.

Credentials:

You will need to provide the following forms of identification

user name and password for the SAP Cloud Platform

Username and password for the SAP Cloud Platform Developer Account

Your SAP Cloud Platform administrator will provide you with this information, and you will need it in order to log in to the HANA Cloud Tools or Development Workbench.

It is possible but not guaranteed that it will be the same as your HCP login credentials.

username and password for the HANA Database User

You are the one who will configure this by following the steps that are listed below.

HANA DB Name & System

0 - HCP Initial Configuration and Overview:

0.1 Head on over to the overview page for your SAP Cloud Platform account and make a mental note of the information that is highlighted.

It is required in order for you to log in to the HANA Cloud Tools.

0.2: Make a note of the name of your database, then select it using the button.

0.3: To configure your database user, navigate to Database User and click there.

THIS PROCEDURE MAY ONLY BE CARRIED OUT ONCE!

Make sure that the username and password are written down somewhere safe.

1 – Configuring authentication for SAP Cloud Platform on HANA Studio:

1.1 Launch HANA Studio and navigate to the SAP HANA Administration Console view using the drop-down menu.

1.2 – Add a Cloud System.

If you do not see this view, you can bring it up by selecting Window > Show View > Systems from the menu.

1.3 – Provide your credentials to access your HCP account.

Step 0.1 is where you'll find both the Landscape host and the HCP Account Name.

You will need to enter the username and password for your SAP Cloud Platform Dev account here; keep in mind that these may not be the same as your general HCP credentials

1.4 – Provide the Login Information for Your Database User Account.

You are responsible for setting this up in step 0.3.

In the event that everything operates as it should, the systems console will display your account name.

2. Establishing a Calculation View in accordance with the IoTMMS Table

2.1 You will need to make a package and place it within the "Content" folder.

2.2 – Enter package details.

For the purpose of this package, we will refer to it as iottutorial2.

2.3: In this package, you should generate a Calculation View.

Before the data are used in charts, views organise and transform them into a particular format. Charts then use the data.

2.4: Enter the calculation in order to view the details.

2.5 – Double

When you select your calculation view from the drop-down menu next to your package, the visual editor should appear below.

When you move your mouse over the Aggregation box, a plus sign will appear. Click on it.

To add a table that will be aggregated, you can do so by clicking on the plus sign.

2.6 - Conduct a search to identify the table that contains your data.

If you have completed the Internet of Things tutorial in Part-1, you can locate the table by searching for "t iot."

If everything works out as planned, you should be able to view the fields and columns of the table that are already there (as shown in the next step).

Note that if you are not the owner of the table that you want to use, you will need the owner of the table to grant your user "select" privileges on the table. If you are the owner of the table, you can skip this step.

You can look at the information about the owner that is enclosed in parentheses right next to the table.

This step may be necessary for you to take if the SAP Cloud Platform IoTMMS was not initially established in your name.

2.7: Include, within the output of your view, any columns that you find useful.

These are the columns that will be made available to whichever component will be consuming that view by the time it is finished processing.

For the purposes of this walkthrough, we will include all previously existing fields in the output.

2.8: If everything works as it should, the output section on the right will have your fields listed in it.

Simply selecting the semantics tab will bring up the editor for the fields.

2.9: Modify the types of your fields in accordance with how they are depicted in the picture.

In this section, you will choose the types of fields that you will use, as well as add rules and calculations to modify, filter, and aggregate the data.

We will proceed without making any changes to the data after we have finished setting the types.

The term "measure type" refers to a numerical measurement, while the term "attribute" stands for a category or label that describes the measure in question.

Take temperature as an example; it could be a numeric measure, and some of its attributes could be the city, the date, or the measuring device.

You are going to want to transform at least one of the fields into a "Attribute."

PLEASE TAKE NOTE That another term that is frequently used for Attribute is Dimension.

2.10: After saving your view, right-click on it and select the "Validate" option to check that it is free of any mistakes.

The next step is to right-click once more, and this time activate it.

In the event that there are any errors, they will be displayed in the console located at the bottom of the screen

2.11 - Perform the same actions again, and then activate your view.

Check to see that the appropriate view is active before continuing.

2.12 - A preview of the data in your view is now available to you.

Select your view, then use the right mouse button to select "Preview."

2.13 – If everything worked out as planned, the output will contain the data that was taken from the table.

This indicates that the view is prepared to be used by other components after it has been consumed.

Briary Energy provides this service to its customers, allowing them to make informed decisions about their fuel choices. This company's sap calculations are reliable and accurate, providing customers with peace of mind that they are making the best possible choices for their needs.