SAP HANA Articles - Page 7 of 69

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

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.

Following roles are available w.r.t Information Composer in SAP HANA −Role IC_MODELERThis role is used to by business users to upload data, create Information Views and to use other features of Information Composers.Role IC_PUBLICThis role is used by business users to work with Information Composer and to see workbooks and Information Views which are shared by other users.

You can try accessing below link if it is accessible −http://:8080/IC or https://:8443/ICTo access Information Composer, you should have Microsoft Silverlight installed and activated as an add-on to the web browser.

Following features are supported using SAP HANA Information Composer −Using Information Composer, users can extract data, clean data, preview data and can also create the physical tables in HANA database as an automated process.Using Information Composer, you can join different objects like tables, Analytic Views and attribute view and calculation views and develop HANA Modeling views to be consumed by different BI Reporting tools.Information Composer can be accessed from a centralize location in the form of URL.

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 interface.

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 using MDX provider, you have to navigate to “Other Sources” in MS Excel and select SAP HANA MDX Provider in the list.You have to provide HANA host name, instance number and authentication details to setup a connection between MS Excel and HANA Modeling views.

While export a delivery unit, you can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.After selecting Delivery unit from drop down list, you have to select checkbox and then enter the Time interval- From and To date.In below snapshot you can see we have highlighted “Filter by Time” option and user can select this checkbox to use time filter during export.