Thursday 12 March 2015

Data Modelling in SAP HANA

Using Information Composer and SAP HANA Studio, we can create data modelling in SAP HANA.


SAP HANA Information Composer


SAP HANA Information Composer is intended for power user and authors. This application allows users to access the data in the SAP HANA in-memory database and model their own reporting objects based on existing information views in SAP HANA(Information view is the overall term for a reusable view created in SAP HANA). In addition, it's possible for users to upload their own data (ex: from spreadsheets). Load this data into SAP HANA, and combine it with existing information views to create new information views directly in Information Composer.

The objects and views that can be modeled in Information Composer can equally well be created in SAP HANA Studio. In contrast to Studio, however, Information Composer offers the basic modelling capabilities of Studio in a web-based tool that is much easier to use. This tool can thus be used by non IT to build data models that can serve as data sources for new reports in SAP BusinessObjects BI or elsewhere.

Information composer has two main functions: the UPLOAD function and the COMPOSE function. The UPLOAD function allows you to load data from your PC to Information Composer and, after cleansing and clasifying the data, to the SAP HANA database itself. The COMPOSE function allows you to use two sources of data from SAP HANA combine with UPLOAD.

SAP HANA Studio



SAP HANA Studio is the central SAP HAAN developer tool for defining the tables that will hold your data, setting up data provisioning on SAP HANA, and modeling data into views. The basic modeling capabilities in Studio comprise attribute views, analytic views, and calculation views. Advance capabilities is filtering, variables, custom calculations, and currency conversion.

I will discover more detail about SAP HANA Studio basic like Attribute View, Analytic View and Calculation view in next post.

No comments:

Post a Comment