MDX provider is used to connect HANA with different reporting tools like MS Excel. MDX provider provides drivers to connect HANA system to Excel and supports data modeling. You can use Microsoft Office Excel 2010/2013 for connectivity with HANA for both 32 bit and 64 bit Windows.To connect HANA system ... Read More

Information Composer is self-service BI reporting and modeling tool in SAP HANA system. Using Information Composer end users can import data to HANA system using .csv and.xls files and can analyze dataset using HANA Modeling.It is used by non-technical business users as It provides simple functionalities with easy to use ... Read More

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

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.

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.

This mode supports activation of the selected objects only if there are no inconsistent in affected objects in SAP HANA.

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

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

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.

When you use object of a schema to build HANA modeling views then it’s necessary to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema. You need to execute the following:GRANT SELECT ON SCHEMA "" TO _SYS_REPO WITH GRANT OPTIONTo use tables from one Schema to create views we ... Read More