SAP HANA VS SAP DW(DATA WAREHOUSE) CLOUD

                                SAP HANA VS SAP DW(DATA WAREHOUSE) CLOUD

 SAP HANA (HIGH PERFORMANCE ANALYTICAL APPLIANCE) :

• SAP HANA is a In Memory Database Computing engine which can retrieve the data quickly when compared to traditional databases(RDBMS).It is flexible in Row and Column based Storage. It contains Multi core and Multi processor that runs completely in main memory. SAP HANA is available in both on premise and Cloud.

 SAP DW (DATA WAREHOUSE) CLOUD :

• SAP DW is a data warehouse in the cloud that unites all your data sources in one solution and also supports Modelling the data and building a story on top of created models. This SAP DW can be Accessed only through Internet as it is a Cloud based tool. 

1. DIFFERENCES BETWEEN MODELLING CAPABILITIES FOR SAP HANA VS SAP DW(DATA WAREHOUSE)CLOUD

     1.1 Creating Different Views for Modelling :

 


   1.2 Different Nodes available for Modelling :

     1.3 Option for Aggregation Node :

    1.4 Different Joins Available for Modelling :

    

     1.5 Different Ways to Create a Calculated Column for Modelling :

                          

     1.6 Different Ways to Check Output Fields :

   2.    Different Function Capabilities in SAP HANA VS SAP DW Cloud

  2.1  String Functions in SAP HANA VS SAP DW Cloud

 String functions need to be used in multiple scenarios for business logic's like

 (a.) Concatenating the First name and Last name into one Separate column.
 (b.) Replacement of one String to another String which is Data Cleansing.
     

 Therefore below are the String functions which are used in SAP HANA and SAP DW cloud :     
       

                 

  

 2.2  Date Functions in SAP HANA VS SAP DW Cloud

 Date Functions are also used in multiple Business Scenarios like

 (a.) Based on previous year Sales data the user wants to predict future values in next column,where the calculation is done using previous year.
 (b.) In other times if user wants to extract only Year or Month or Date,there are certain functions which can trim the date dimension to the Specified user requirement. 

                                     
Therefore below are the Date functions which are used in SAP HANA and SAP DW cloud :

2.3 Conversion Functions in SAP HANA VS SAP DW Cloud

Conversion Functions are most widely used in Business Scenarios like :

(a.) If the user builded a model having date dimension which is saved in String data type. Now to change into Date dimension use TO_DATE conversion function.

Therefore below are the Conversion functions which are used in SAP HANA and SAP DW cloud :                                                        

                                    

2.4  Mathematical Functions in SAP HANA VS SAP DW Cloud

Mathematical functions are used in Business Scenarios like

(a.) In Retail Industry for every product there is impact in Profit or Loss. If there is a demand on the product, to get more Profit the price of product should be increased by particular percentage. This type of calculations can be done using Mathematical functions.

Therefore below are the Conversion functions which are used in SAP HANA and SAP DW cloud :

            

                              

 3.    Connections available – SAP DW cloud Vs SAP HANA

Connections supported by specific tool is to be acknowledged for Data Migration Scenarios. Therefore below image shows the different Cloud or On-Premise tools that can be connected to SAP HANA or SAP DW Cloud.