// Explore More Tutorials
SAP HANA Studio, Build a Calculation View and View the Data in MS Excel
2018-09-29
Beginner
25 min.
In this tutorial, you will go through all the steps to import data from a MS Excel Spreadsheet, model a simple Calculation view and viewing the results in a pivot table using the HANA MDX connector.
You will learn
In this tutorial, you will go through all the steps to import data from a MS Excel Spreadsheet, model a simple Calculation view and view the results in a pivot table using the HANA MDX connector from MS Excel. You will first create the basic setup within an XS Project.
DEPRECATED: SAP HANA XS Classic is deprecated as of SPS02. Please use XS Advanced, and learn about how to get started with the new mission Get Started with XS Advanced Development.
Step 1: Download and Install SAP HANA Client
Step 2: Create the XS Project and Core Data Services artifacts
Step 3: Grant permissions to the newly created schema
Step 4: Import data into your tables
Step 5: Create a Calculation View
Step 6: Connect to your instance using the MDX connector
Navigate tutorial steps
-
Step 1: Download and Install SAP HANA Client
-
Step 2: Create the XS Project and Core Data Services artifacts
-
Step 3: Grant permissions to the newly created schema
-
Step 4: Import data into your tables
-
Step 5: Create a Calculation View
-
Step 6: Connect to your instance using the MDX connector
- Back to Top