Navigate to SAP HANA Modeler Perspective → Delivery Units. In the next window, click on the Create button and this will open below the window where you have to provide details about DU.As mentioned, the Delivery unit name should contain only capital letter alphabets (A-Z)(0-9) and _(underscore).

To create a delivery unit in SAP HANA, you have to navigate to SAP HANA Application Lifecycle Management.Next is to select PRODUCTS tab → Select Delivery Units tabTo create a new Delivery unit, click on the Create button. Enter the details as shown in the below window and click on ... Read More

To maintain Vendor ID in SAP HANA, you need to navigate to Application Lifecycle management. −Start the SAP HANA Application Lifecycle ManagementThe SAP HANA Application Lifecycle Management is available on the SAP HANA XS Web server at the following URL −http://:80/sap/hana/xs/lmhttp:// bwhana:8002/sap/hana/xs/lmSelect “Administration” tab and click on “Change Vendor”Read More

To add a role to user profile, open user profile in HANA Studio by navigating to Security folder. Go to Roles tab and click on “+” sign. In search window you have to search for this role − “sap.hana.xs.lm.roles::Administrator”

There are different authentication methods that you can use −Authentication by Operating System UserAuthentication by database userConnect using SSL

You can use an aggregate function to get the same. Common aggregation functions are −Average() − returns the average of the numeric values in a given columnSelect Average (Sales) from table_name where Column1=’ABC’; 

Each HANA system contains multiple serves inside, which are responsible to perform different functions. Index Server is heart of SAP HANA system which contains SQL/MDX processor for handling SQL statements. Key component includes −Index ServerPreprocessorName ServerStatistics ServerHANA XS EngineSAP Host AgentSAP Solution Manager Diagnostic AgentSAP HANA Studio + RepositorySAP HANA ... Read More

When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.To add a table as a ... Read More

When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With the use of config file- features, function mappings, data type mappings, and other properties will be linked together with the data source. This decides the communication between the SAP HANA ... Read More

You can check the following example to create a new remote source −CREATE REMOTE SOURCE TEST_11g ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral11g_lnx’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In above SQL statement, can be one of −  ASEODBC, IQODBC, TDODBC, HIVEODBC, ODBC. Obviously, ASEODBC is for Sybase ASE as ... Read More