SAP HANA Articles - Page 5 of 58

In Analytic View, to hide few of columns you have to click on Semantics in scenario pane. There you can select the checkbox in front of column name that you want to hide.

In SAP HANA Modeler Perspective, you can Auto Documentation feature to capture the details of an information model or a package in a single document. This helps you view the necessary details from the document, instead of referring to multiple table.

The default activation mode is “Activate and ignore the inconsistencies in affected objects”.

This activation mode supports activating the selected objects even if it results in inconsistent affected objects. For example, if you choose to activate an object A that is used by B and C, and it causes inconsistencies in B and C but you can choose to go ahead with the activation of A.

Redeploy option is available under SAP HANA Modeler Perspective −

This option is used for bulk activation of inactive objects in HANA repository. You have the following Activation modes −Stop activation incase of inconsistencies in affected objectsActivate and ignore the inconsistencies in affected objects

Once data is published to HANA database, you cannot rename the table. In this case, you have to delete the table from Schema in HANA database.

In SAP HANA system, you can load in following ways using SAP HANA Information Composer −Data from Filesystem − This options is used to upload data using .xls, .csv file directly to HANA database.Data from clipboard − Other way is to copy data to clipboard and copy from there to HANA database.

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.

You should setup a separate server for HANA Information Composer and it should be set next to your HANA system. Following server, a requirement should be met −Server Requirements −At least 2GB of available RAM is requiredJava 6 (64-bit) must be installed on the server