Skip to Content
Previous

Working with the SAP Vora Tools

By Vitaliy Rudnytskiy

Vora tools provide a data browser for viewing and exporting data in tables and views, an SQL editor for creating and running SQL scripts, and a modeller for creating data models

You will learn

You will learn how to use Data Browser and Modeler from Vora Tools.

Details


Step 1: SAP Vora Tools

The SAP Vora tools provide a data browser for viewing and exporting data in tables and views, an SQL editor for creating and running SQL scripts, and a modeler for creating data models.

SAP Vora makes available OLAP-style capabilities for data on Hadoop, in particular, a hierarchy implementation that allows you to define hierarchical data structures and perform complex computations on different levels of data.

Please log in to access this content.
Step 2: Accessing the Tools

You can access the SAP Vora tools via web browser on the port 9225 of the Vora host: http://<IP_ADDRESS>:9225. In your SAP Vora, developer edition, you can use user vora.

The initial screen appears as follows.
Logon to Tools

You will be presented with the initial landing page once logged in successfully.

Please log in to access this content.
Step 3: Data Browser

Continue by selecting the Data Browser. This node will give a list of all object created in the platform (from previous Zeppelin tutorials) you can also preview data.
Data Browser

Expand the tree views of Vora In-Memory Engine and Vora Disk Engine.
Expand

Continue by registering the tables: PRODUCTS in the In-Memory Engine and COMPLAINTS_DISK in the Disk Engine. You will be using the Vora Modeling tool to create a model, querying data across two engines.
Registration

Table registration will take a few moments.

Please log in to access this content.
Step 4: Modeler

Select the Modeler button once both tables are registered. This is where you will be doing the bulk of the work now.
Modeler

Expand the Vora In-Memory Engine and Vora Disk Engine tree view once the Modeler tool is loaded.
Trees

Create a new SQL View called V_CUSTOMER_ISSUES by clicking on the Add button.
Add

Select View Type SQL and name it V_CUSTOMER_ISSUES.
View create

Once the view is created, the next step is to add Data Sources (two tables from previous steps). Click on the Add Data Source button. You can start typing the table name or supply a * to list all known Data Sources as shown below.
Add first data source

Repeat to add second table.
Add first data source

Continue by selecting desired columns as output by clicking on the highlighted radio buttons next to each required column. Note that the selected output columns will appear in the right hand pane Columns.
Select Columns

Join the two tables on the common column COMPLAINT_ID. First use your mouse pointer to select the COMPLAINT_ID column in the PRODUCTS table. Hold the mouse button down while dragging it to the COMPLAINTS_DISK table and drop it on the COMPLAINT_ID column.
Join tables

The Join Definition window appears. Change the type to Left Outer and select OK when done.
Left Outer

Save the view. Now preview what you have done so far by clicking on the Preview button as demonstrated below. Note the join linking the two tables.
Join preview

Successful Data Preview.
Data preview

Add a ‘where’ condition to filter for issues logged via the Web by using the right hand pane. Look for Where and click the + button. The Where Condition window appears. Enter condition by selecting options or by typing the condition in the Expression box.

COMPLAINTS_DISK.SUBMITTED_VIA = 'Web'
Condition

Save your changes and do a Data Preview.
Data Preview with condition

Modify the existing view to count issues logged by PRODUCT. Start by selecting only PRODUCT as the output column. You can deselect unwanted columns by clicking on them.
Deselecting columns

Add a calculated column P_COUNT to count COMPLAINT_ID.

count( PRODUCTS.COMPLAINT_ID )
Calculated column

Add PRODUCT to the Group By clause.
Group by column

Save changes and do a Data Preview again.
Data Preview with calculated column

The modelled view is now ready for reporting. Click on the Data Browser in Vora Tools. You will notice the newly created object under Vora In-Memory Engine.
View in Data Browser

Please log in to access this content.

Next Steps

Updated 05/23/2017

Time to Complete

15 Min

Beginner

Tags

Next
Back to top