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 ... Read More

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.

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 ... Read More

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 ... Read More

The name of Delivery Unit must contain only capital letters (A-Z), digits (0-9) and underscores (_). It won’t accept any special characters.

SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.

In SAP HANA system, you use statistics serve as a key to internal monitoring infrastructure. You will be notified when a critical alert raised in your HANA environment and you can also get all the historical monitoring data for analysis.Statistical Server is responsible for collecting the data related to system ... Read More

In SAP HANA database, you have different system schema. _SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository.  When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in ... Read More

Note that while modifying or creating the property configuration file, only the property which is different from default value needs to be set. The mistake in property configuration file may result in incorrect action or result of data source.

Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In ... Read More