In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit

In SAP HANA, using file import you can load data to an existing table or can create a new table with the same column names as in the flat file.While using import wizard, you can define the mapping of columns. Following options are available −One to OneMap by NameUsing Map ... Read More

In SAP HANA data replication, following replication methods can be used −SAP Landscape Transformation (SLT)SAP Data ServicesDXCFrom the above method, SAP Landscape Transformation (SLT) Replication is a trigger based data replication method in HANA system. It is used for replicating real-time data or schedule-based replication from SAP and non-SAP sources. ... Read More

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