Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 43 of 58
Using header rows during flat file upload in SAP HANA
This can be done using File import option. While importing first file, you have an option to “Add columns” in new table so you can create addition columns as per column names in other CSV’s. You can also define their datatypes, length, Primary key, not null and other column properties in same window.
Read MoreImporting limited number of rows from CSV in SAP HANA
Yes, this can be done using File Import option in HANA Studio. In Import data from local file wizard, un-check the option- Import all data and you can mention Start Line and End Line value.
Read MoreMoving objects from one package to another package in SAP HANA
In SAP HANA Modeler perspective, you have an option of “Mass Copy” using which you can copy mass objects from package to other package. You have to define source and target package mapping.To add new package mapping, you can use button and select Source and Target package from drop down list. In next window, you have to select models and click on Next.
Read MoreMaintaining vendor ID for Delivery unit in HANA using SAP HANA Studio
You can also maintain Vendor ID in Administration tab in SAP HANA Studio. Select HANA system and click on Administration and go to Configuration tab. In filter, enter Vendor and search:Click on Change and you will get an option to enter new Vendor Id value. Click on Save to save the changes.
Read MoreNaming convention for creating a delivery unit in SAP HANA
The name of Delivery Unit must contain only capital letters (A-Z), digits (0-9) and underscores (_). It won’t accept any special characters.
Read MoreInformation required while creating a new Delivery Unit in SAP HANA
First is to pass the name as it is mandate field.Vendor field is mandatory however it won’t allow you enter vendor name here as it takes value from the SETTINGS tab.Version # should be in format: “#.#.#” Example: 1.0.5:1 - DU version number0 - support package version (optional)5 - patch version (optional)
Read MoreConfiguring a trusted RFC to be used in SLT Replication in SAP HANA
This can be done using T-code: ltrClick on New → New Window will open → Enter configuration name -> Click Next -> Enter RFC Destination i.e. connection name you have created and click on search option, choose name and click next.
Read MoreUsing IC_PUBLIC role in SAP HANA
Please note that IC_MODELER role assigned to your user means he can only create and use private Information Views. Normally IC_MODELER role also includes IC_PUBLIC role so users who has IC_MODELER role assigned, they are also granted with IC_PUBLIC role which is required to view Information views shared by other users.Please check If IC_PUBLIC role is available in that user profile, if not try adding that role separately.
Read MoreTransporting content from one SAP HANA system to other
This can be done using Delivery unit option in SAP HANA. You can assign packages to a delivery unit using SAP HANA Studio or using Application Lifecycle Management.Then this DU can be exported and you need to specify the location- local file system, where you want to save the exported DU. This file can be imported later to add the packages to other system. In below snapshot you can see a Delivery unit is selected under Upload/Download option in HANA Application Lifecycle Management ALM. Once delivery unit is selected, use “Export to File” option to export this DU locally in ...
Read MoreIC role to create physical tables, analyze data in SAP HANA
To create physical tables, uploading data and creating information views IC_MODELER role is required. If these users are only assigned with IC_PUBLIC role, they can view information views created by other users but can’t create their own views.
Read More