SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics



Fast Track to SAP HANA - SAP HANA Online Training

About The Course:

Fast Track to SAP HANA is the quickest way to get started in SAP HANA.

SAP HANA fast track training is designed for people who want to start working in HANA fast without going into too much theoretical detail.
In this course you will learn how to start development in SAP HANA and create data modeling using a real-time business use-case example.
Target Audience:
Anyone who want to learn SAP HANA development and data modeling.

Course Duration:
4 hours

Prerequisite:
None

No Course Fee - Totally Free:

This course is free of charge.
Just one note, if you really like the course, please share it with your friends and do provide your valuable feedback/comments through Contact Us.
You can also share information, ask questions, provide feedbacks and suggest us through The Forum .

Important Notes:

This course is targeted for people who do not want to spend time on theories and just want to get hands on in SAP HANA. This is a fast paced course. In case you have more time and you are interested in getting complete SAP HANA training for beginner, refer to SAP HANA Basic Course.


Good Luck!!
1.1. Introduction to SAP HANA


SAP HANA, short for "High-Performance Analytic Appliance" is an in-memory, column-oriented, relational database management system developed by SAP.
    • Data now resides in main-memory (RAM) and no longer on a hard disk.
    • It is a combination of hardware and software made to process massive real time data using In-Memory computing.
    • It combines row-based, column-based database technology.
    • It's best suited for performing real-time analytics on massive data, and developing & deploying real-time applications.



An in-memory database means all the data is stored in the memory (RAM). No time wasted in loading the data from hard-disk to RAM or storing the data in hard-disk. Everything is stored inside memory for all the time, which gives quick access ability to the CPUs while processing data. The speed advantages offered by this RAM storage system are further accelerated by the use of multi-core CPUs, and multiple CPUs per board, and multiple boards per server appliance.



SAP HANA is equipped with Multiengine Query Processing Environment which supports relational as well as graphical and text data within the same system. It provides features that support significant processing speed, handle huge data sizes and text mining capabilities.



Can we just increase the memory of the traditional database (like Oracle) to 1 TB and get similar performance?

NO. You might have performance gains due to more memory available for your current Oracle/Microsoft/Teradata database, but HANA is not just a database with bigger RAM. It is a combination of a lot of hardware and software technologies. The way data is stored and processed by the In-Memory data base is the true differentiator. Having that data available in RAM is just the icing on the cake.

Operating System Supported By SAP HANA:

Earlier SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 was the only Operating System supported by SAP HANA. From SPS08, Red Hat Enterprise Linux is also supported.

SAP HANA is developed in C++ language.

Why SAP HANA is fast?




1.2. A Business Use-case Example

In this course we will try to learn how to create data modeling in HANA and how to create business reports and charts in Excel using those modeling views. To make it more clear let us take a real time business scenario.

Business Use-case Example:
Suppose there is a retail company, which sales different stuffs like Shirts, Jackets, and Trousers etc.

The first table PRODUCT has the information about the product names and categories.

SAP HANA Online Training

The company has different branches around the world like Asia, Europe etc. The second table REGION has this information of different region and sub-regions.

SAP HANA Online Training

There is a third table SALES which contains information of different sales values. It contains PRODUCT_ID which connects this to PRODUCT table, REGION_ID which connects to REGION table.

SAP HANA Online Training

Suppose I am the manager of Asia region. I would like to analyze this huge data and make business decisions for my company, based on the information I get for below questions.
    • • What is the total sales value for "Asia" region?
    • • Which product has maximum sales value for Asia region?
    • • Which product has minimum sales value for Asia region?
    • • What is the total sales value for "Shirts"?
    • • What is the total sales value for "Asia" for "Jackets"?
    • • What are the total sales for category “Clothes”? And so on...

Further suppose the Discount values are decides based on Product Category.
If Product category = “Clothes” then Discount = 20%
Else If Product category = "Accessories" then Discount = 10%

Net Amount = Sales Amount – Discount

We also need to provide Discount and Net Amount for different regions and products.

Note: In real time scenario, these tables will have millions and billions of records.

In later chapters we will learn how to solve this problem with SAP HANA.
1.3. All Steps at a Glance

In order to create the business analysis report, we will follow below steps.

SAP HANA Online Training


2.1. Get Free Access To SAP HANA Server

You can get your own HANA DB server , running on Amazon Web Services. No license fee, you just pay AWS for the hosting cost.

If running your own HANA on AWS sounds like too much of an investment for now, there is even a completely free option. SAP is providing 30 days of free access to SAP HANA developer edition environment hosted on CloudShare.
Here is the link for registration: 30 days of free access to SAP HANA developer edition environment



2.2. Download and Install SAP HANA Studio

Introduction to SAP HANA Studio:
    • HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
    • It enables technical users to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc.
    • It is a client tool, which can be used to access local or remote HANA system.
SAP HANA Studio

Download HANA Studio:

From SAP Service Market Place:
    1. You need user account in SAP Service Market Place for this.
    2. Go to SAP Service Market Place
    3. Choose Support Packages and Patches > A-Z Index: H > SAP HANA Enterprise Edition > SAP HANA Enterprise EDIT .1.0 > Comprised Software Component Versions > SAP HANA STUDIO 1.00 > <your operating system>
    4. Run the SAPCAR executable to download the SAR file. Extract this SAR file.
      Use command SAPCAR -xvf <your-SAR-file> to extract the file.
    5. Run the HDBSETUP executable to install and update HANA Studio.
    6. When prompted, use option Install new SAP HANA Studio to proceed with the installation.

From SDN (FREE):
SAP provides a developer download of the HANA Studio and Client software on SDN, at the following link:
    1. HANA Developer Edition-SAP HANA Studio - The SAP HANA Administration and Modeling Tool
    2. HANA Developer Edition-SAP HANA Client - SDKs for JDBC, ODBC, ODBO and Python DB API, so that you can build client applications

SAP HANA Studio and Client, developer edition is also available at SAP SCN here -

Install SAP HANA Studio:
Run the setup file hdbsetup.exe to install the HANA Studio. Make sure you have downloaded correct version of the setup file as per your operating system.

Java JRE 1.6 or 1.7 must be installed to run the SAP HANA studio. The Java runtime must be specified in the PATH variable. Make sure to choose the correct Java variant for installation of SAP HANA studio:
2.3. Add HANA System in SAP HANA Studio


In order to connect to a SAP HANA system we need to know the Server Host ID and the Instance Number. In chapter 2.1, you have got access to an HANA system. Use that host id, instance no and credentials to connect

Steps to add HANA system in HANA Studio:
    1. Go to Windows --> Open Perspective and select SAP HANA Modeler.

      SAP HANA Online Training

    2. Right click in the System Tab in left side and click on Add System
    3. Enter HANA system details, i.e. the Hostname & Instance Number and click Next.
    4. Enter the database username & password to connect to the SAP HANA database. Click on Next and then Finish.
    5. The SAP HANA system now appears in the Navigator.

3.1. Create Table

Database table consists of columns and rows and contains the data.
At first we need to create tables to hold data for Products, Regions and Sales.

Steps to Create Tables:

  1. Open HANA Studio and expand the SAP HANA system.
  2. Go to your schema. Right-click on your schema and select SQL editor.
    SAP HANA Studio
    Note: In this example schema name is "SAP_HANA_TUTORIAL". In case you want to create a new schema use below query.
    create schema <schema_name>;

  3. Copy and paste the below script in SQL editor and execute.

    --REPLACE <YOUR SCHEMA> WITH YOUR SCHEMA NAME

    -- Create Product table
    create column table "<YOUR SCHEMA>"."PRODUCT"(
               "PRODUCT_ID" VARCHAR (100),
               "PRODUCT_NAME" VARCHAR (100),
               "PRODUCT_CATEGORY" VARCHAR (100),
               primary key ("PRODUCT_ID") );

    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_1','Shirts', 'Clothes');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_2','Jackets', 'Clothes');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_3','Trousers', 'Clothes');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_4','Coats', 'Clothes');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_5','Purse', 'Accessories');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_6','Jewelry', 'Accessories');
    insert into "<YOUR SCHEMA>"."PRODUCT" values('PROD_7','Sunglasses ', 'Accessories');

    --Create Region table
    create column table "<YOUR SCHEMA>"."REGION"(
               "REGION_ID" VARCHAR (100),
               "REGION_NAME" VARCHAR (100),
               "SUB_REGION_NAME" VARCHAR (100),
               PRIMARY KEY ("REGION_ID") );

    insert into "<YOUR SCHEMA>"."REGION" values('R_1','Americas','North-America');
    insert into "<YOUR SCHEMA>"."REGION" values('R_2','Americas','South-America');
    insert into "<YOUR SCHEMA>"."REGION" values('R_3','Asia','India');
    insert into "<YOUR SCHEMA>"."REGION" values('R_4','Asia','Japan');
    insert into "<YOUR SCHEMA>"."REGION" values('R_5','Europe','Germany');

    --Create Sales table
    create column table "<YOUR SCHEMA>"."SALES"(
               "REGION_ID" VARCHAR (100) ,
               "PRODUCT_ID" VARCHAR (100) ,
               "SALES_AMOUNT" DOUBLE,
               PRIMARY KEY ("REGION_ID", "PRODUCT_ID") );

    insert into "<YOUR SCHEMA>"."SALES" values('R_1','PROD_1',100);
    insert into "<YOUR SCHEMA>"."SALES" values('R_1','PROD_2',90);
    insert into "<YOUR SCHEMA>"."SALES" values('R_1','PROD_5',85);
    insert into "<YOUR SCHEMA>"."SALES" values('R_2','PROD_2',80);
    insert into "<YOUR SCHEMA>"."SALES" values('R_2','PROD_1',75);
    insert into "<YOUR SCHEMA>"."SALES" values('R_3','PROD_3',85);
    insert into "<YOUR SCHEMA>"."SALES" values('R_3','PROD_6',70);
    insert into "<YOUR SCHEMA>"."SALES" values('R_4','PROD_4',75);
    insert into "<YOUR SCHEMA>"."SALES" values('R_4','PROD_6',120);
    insert into "<YOUR SCHEMA>"."SALES" values('R_4','PROD_7',50);
    insert into "<YOUR SCHEMA>"."SALES" values('R_5','PROD_1',65);
    insert into "<YOUR SCHEMA>"."SALES" values('R_5','PROD_2',65);

  4. After executing the scripts you should have 3 tables created. If there are no tables, try right-clicking on your schema and refreshing.

    SAP HANA Studio
  5. Right click on table and click on data preview to see the data.

    SAP HANA Online Training


Grant schema SELECT rights to _SYS_REPO user:
Open the SQL editor of your schema and execute the following command line:
GRANT SELECT ON SCHEMA <YOUR SCHEMA> TO _SYS_REPO WITH GRANT OPTION;

If you miss this step, an error will occur when you activate your views later. Click here to know more about this.



3.2. Introduction to Data Modeling

SAP HANA Data Modeling is the heart of HANA application development.
Modeling refers to an activity of refining or slicing data in database tables by creating views to depict a business scenario. The views can be used for reporting and decision making.
You can create modeling views on top of database tables and implement business logic to create a meaningful report. These modeling views can be consumed via Java or HTML based applications or SAP HANA native applications. You can also use SAP tools like SAP Lumira or Analysis Office to directly connect to HANA and report modeling views. It is also possible to use 3rd party tools like MS-Excel to connect to HANA and create your report.


Attribute and Measure:

Columns of modeling view can be classified as Attribute or Measure.
    • Attribute: Non-measurable, Descriptive data, such as customer ID, city, and country
    • Measure: Quantifiable data, such as revenue, quantity sold and counters.
In our example The SALES or PROFIT columns are numeric values. These columns are measurable and can be aggregated. While the columns PRODUCT_NAME, REGION_NAME are descriptive and non-measurable.
Here PRODUCT_NAME and REGION_NAME are attributes, while SALES and PROFIT are measures.

Categories of Modeling Views:

The modeling views are classified as:
    • • Attribute Views
    • • Analytic Views
    • • Calculation Views

Attribute View:

    • • Attribute views are used to join to a dimension or master data
    • • In most cases used to model master data like entities (like Product, Employee, Region)

In this example, we will create two attribute views:
AT_Region: This attribute view will use REGION table and will be used to get all Region related information.
AT_Product: This attribute view will use PRODUCT table and will be used to get all Product related information.

These attribute views will be used in Analytic view.

Analytic View:

    • • Analytic views are typically defined on at least one fact table that contains transactional data along with number of tables or attribute views.
    • • Analytic views leverage the computing power of SAP HANA to calculate aggregate data, e. g., the total sales value of a product sold per country, or the maximum sales value of product.

In this example, we will create an Analytic view AN_SalesReport to provide a business analysis report.

Calculation View:

    • • Calculation view can perform complex calculations not possible with other views.
    • • Calculation views can be referred as combination of tables, attributes views and analytical views to deliver a complex business requirement.

In this example, we will create a Calculation View to apply Discount formula and calculate Net Amount.
3.3. Create Attribute View


Create First Attribute View - AT_Region:

  1. Open HANA Studio. Go to Windows --> Open Perspective and select SAP HANA Modeler.

    SAP HANA Online Training


  2. SAP HANA Studio
  3. Create a new package under the content folder.
    Right-click on the content folder and choose "New" -> "Package." Fill the fields "Name" and "Description" and click "OK."
    If you dont see the new package after this, try right-clicking on the content folder and refreshing.
  4. Right click on the package and choose "New Attribute View." Enter a name and a description and click "Finish"

    SAP HANA Attribute View

  5. The attribute view will be opened in the HANA studio editor. Select "+" sign on "Data Foundation"

    SAP HANA Attribute View

  6. Search for table "REGION" and select it.

    SAP HANA Attribute View

  7. Now add the columns from the REGION table to output. Simply right click on the column and select "Add to Output". Add all 3 columns REGION_ID, REGION_NAME, SUB_REGION_NAME to the output.
    Once it is done, you will see the selected column in right side pane.

    SAP HANA Attribute View

  8. Now select "Semantics". All 3 columns appears under Column pane as attributes.

    SAP HANA Attribute View

  9. Now you need to define attributes and key attributes. Every attribute view must have at least one key attribute.
  10. Click on the "Type" to select key attribute for REGION_ID.

    SAP HANA Studio

  11. Click on the "Save and Activate" button on top right corner to activate the view.

    SAP HANA Studio
  12. In the "Job log" Pane you will see an activation completed message.
    SAP HANA Studio
  13. Attribute view is created and activated.
    To see the output of this view click on the "Data Preview" button on top right corner.
    SAP HANA Studio
    Then select "Raw Data" tab.
    SAP HANA Studio

Create Next Attribute View - AT_Product:

Similar to AT_Region create one more attribute view AT_Product using PRODUCT table.
  1. Right click on package and select Attribute view. Add PRODUCT table.

    SAP HANA Online Training

  2. Add all 3 columns PRODUCT_ID, PRODUCT_NAME AND PRODUCT_CATEGORY to the output.

    SAP HANA Online Training

  3. Now select “Semantics”. All 3 columns appear under Column pane as attributes. Click on the “Type” to select key attribute for PRODUCT_ID.

    SAP HANA Online Training

  4. Click on the “Save and Activate” button on top right corner to activate the view. Click on the “Data Preview” button on top right corner to see the data preview.

    SAP HANA Online Training

3.4. Create Analytic View

  1. Right click on the package and choose “New Analytic View.” Enter a name and a description and click “Finish”.

    SAP HANA Online Training

  2. Click on “+” sign of “Data Foundation” and add table SALES.

    SAP HANA Online Training

  3. Right Click on the columns of table SALES and add REGION_ID, PRODUCT_ID and SALES_AMOUNT to output.

    SAP HANA Online Training

  4. Click on “+” sign of “Logical Join” and add attribute view “AT_Region” which was created earlier.

    SAP HANA Online Training

  5. Click on “+” sign of “Logical Join” again and add attribute view “AT_Product”.
  6. Click on the REGION_ID from “Data Foundation” and connect it to the REGION_ID of attribute view AT_Region. In the properties pane select join type as left outer join and cardinality as n..1

    SAP HANA Online Training

  7. Similarly Click on the PRODUCT_ID from “Data Foundation” and connect it to the PRODUCT_ID of attribute view AT_Product. In the properties pane select join type as left outer join and cardinality as n..1

    SAP HANA Online Training

  8. Select “Sementics”. In the right side change the column type of SALES_AMOUNT as measure.

    SAP HANA Online Training

  9. Activate the analytic view similar to attribute view.
  10. Right-click on your analytic view and choose “Data Preview.” After that, you can browse through the tabs named raw data, distinct values, and analysis.

    SAP HANA Online Training

    SAP HANA Online Training


3.5 Create Calculation View

Analytic View created in the previous chapter can further be used in a Calculation view to do more complex calculation. Here we will create a calculation view to calculate Discount and Net Amount.

As discussed previously, the formula for calculating Discount and net Amount is

If Product category = “Clothes” then Discount = 20%
Else If Product category = "Accessories" then Discount = 10%

Net Amount = Sales Amount – Discount


Steps to Create Calculation View:

  1. Right click on the package and choose “New Calculation View.”

    SAP HANA Online Training

  2. Enter a name and a description. For all other options, use default values. Click “Finish”.

    SAP HANA Online Training

  3. In the left side of the window you will find a tool palate which has different option for Join, Union, Projection and Aggregation.

    SAP HANA Online Training

  4. Click on Projection and drag in the middle area to create a Projection block as shown in image below. Then click on plus (+) sign to add Analytic view to it. Search for AV_SalesReport and click on Ok.

    SAP HANA Online Training

  5. We will add all the columns of this Analytic view to output. For that right click and click on “Add all to output”. After this all the columns will appear on right side Output Pane.

    SAP HANA Online Training

  6. Now we will calculate Discount and Net Amount using calculated column. Right click on the Calculated Columns and select New.

    SAP HANA Online Training

  7. Specify the name as DISCOUNT, select the Data Type as Integer. And provide the expression as
    if("PRODUCT_CATEGORY" = 'Clothes',20,10)


    SAP HANA Online Training

    Note: The syntax of “if” operator is
    If (condition, argument1, argument2)
    Return argument1 if condition is true, else return argument2.
  8. Similarly, create another calculated column NET_AMOUNT using the formula
    "SALES_AMOUNT" -"DISCOUNT"


    SAP HANA Online Training

  9. Select the Projection block and connect it to the Aggregation block as shown in image below.

    SAP HANA Online Training

  10. Select Aggregation block. Now we need to add columns to output. Right click on the columns REGION_ID, REGION_NAME, SUB_REGION_NAME, PRODUCT_ID, PRODUCT_NAME, PRODUCT_CATEGORY and click on “Add To Output”.

    Similarly right click on the columns SALES_AMOUNT, DISCOUNT and NET_AMOUNT and click on “Add As Aggregated Column”.

    SAP HANA Online Training

  11. Select Semantics. Now we need to specify which columns are attributes and which columns are measures. Click on the “Auto Assign” button to do it automatically.
    Alternatively you can also specify the Attribute/measure by clicking on Type down-arrow. Select SALES_AMOUNT DISCOUNT and NET_AMOUNT as measure and rest of the column as attribute.

    SAP HANA Online Training

  12. Activate the calculation view. Right-click on your calculation view and choose “Data Preview”. After that, you can browse through the tabs named Raw Data, Distinct Values, and Analysis.

    SAP HANA Online Training

Congratulation! You have successfully created the calculation view. In next chapter we will learn how to consume these views and create business reports and graphs.
4.1. Reporting Tools in SAP HANA

Once the modeling view (attribute view, analytic view and calculation view) is created in SAP HANA, you can see the output in HANA Studio.
But finally it will be non-technical end users (for example manager, sales executive, board members etc.) who will consume the modeling views to visualize different business scenarios.
Asking a non-technical user to use HANA Studio is not really practical. You also would not want to put the modeling software in the hands of all your users.
That's why we need separate reporting tools which can connect to SAP HANA, take the data from modeling views and show in a nice, easy to understand format.

Currently there are number of tools/applications which can be used for reporting in SAP HANA. SAP suggests using frontends of the SAP Business Objects BI Suite. Recommended frontend tools include SAP Business Objects Crystal Reports, Analysis Office, and Explorer.
Reporting on SAP HANA can be done in most of SAP's Business Objects BI Suite of applications, or in tools which can create and consume MDX queries and data.
Microsoft Excel can also be used for reporting on SAP HANA.
You can use Excel to connect to SAP HANA, access the modeling views and slice and dice" data to create meaningful reports.

4.2. Download and install SAP HANA Client For Excel:

Excel can connect to SAP HANA using the MDX language in the form of pivot tables. These in turn allow users to "slice and dice" data as they require, to extract the metrics they need.
In order to make MDX connections to SAP HANA, the SAP HANA Client software is needed. This is separate to the Studio, and must be installed on the client system.
Like the Studio itself, it can be found on the SAP Service market place. Additionally, SAP provides a developer download of the client software on SDN, at the following link: HANA Developer Edition-SAP HANA Client

Note:Download and install the appropriate SAP HANA Client as per your operating system version and Microsoft Office installation.
If you are using a 64-bit operating system in combination with a 32-bit Office installation, then you'll need the 32-bit version of the SAP HANA Client software.
Once the software is installed, there is no shortcut created on your desktop, and no entry will be created in your "Start" menu, so don't be surprised to not see anything to run.

4.3. Build Reports in Excel

  1. Open Excel.
  2. Go to the Data tab, and click on From Other Sources, then From Data Connection Wizard, as shown:

    SAP HANA Report in Excel

  3. Select Other/Advanced, then SAP HANA MDX provider, and then click Next.

    SAP HANA Report in Excel

  4. The SAP HANA Logon dialog will appear, so enter your Host, Instance, and login information (the same information you use to connect to SAP HANA with the Studio).

    SAP HANA Report in Excel

  5. Click on Test Connection to validate the connection. If the test succeeds, click on OK to choose the Modeling views to which you want to connect. Select the package which contains the modeling views.

    SAP HANA Report in Excel

  6. Click on the name of the calculation view. Click "Next."

    SAP HANA Report in Excel

  7. On this screen there's a checkbox Save password in file – this will avoid having to type in the SAP HANA password every time the Excel file is opened – but the password is stored in the Excel file, which is a little less secure.
    SAP HANA Report in Excel
  8. Click on the Finish button to create the connection to SAP HANA, and your View.
  9. Now that you have established your connection to the SAP HANA database and specified the data that you want to use, you can start exploring it in Microsoft Excel, using a pivot table. Select the attributes and measures and create a report and graph you want.
    SAP HANA Report in Excel

Create some business reports and graphs

What are the total sales values for different products for different regions?
  1. Open the calculation view in excel as shown in previously.
  2. Select the SALES_AMOUNT, REGION_NAME, SUB_REGION_NAME and PRODUCT_NAME in exactly this sequence. On the right side you can see the output.

    SAP HANA Online Training

  3. Select the excel cells and click on "Pivot Chart". Select a chart type and click on Ok.

    SAP HANA Online Training

  4. The report is created. You can save this excel and circulate to people interested in this information.

    SAP HANA Online Training


Similarly you can create another report to show comparison of SALES_AMOUNT and NET_AMOUNT for different regions and products.

SAP HANA Online Training



Completed This Course!! What is Next?

After completing the course Fast Track to SAP HANA you should have got basic idea on "how to start SAP HANA Development".

You should now be able to
  • • Understand what is SAP HANA and its basic features.
  • • How to install HANA Studio and start data modeling.
  • • How to create business reports and charts in Excel using SAP HANA.



Next step would be to get more in-depth knowledge on SAP HANA topics like Architecture, Core Components, Design etc. We recommend you to go thru SAP HANA Basic Course to get complete end-to-end information on HANA.



Course Index
Close
X
Fast Track to SAP HANA
Course Overview
1. Introduction
2. Installation and System Setup
3. Data Modeling in SAP HANA
4. Creating Reports in HANA
5. What is Next?
 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy