Monday, February 19, 2018

HANA Virtual Data Models Part 1

HANA Live Virtual Data Model is one of the key idea in the HANA technology. Below I will show you how core business data can be shared using well-defined views on HANA DB.

HANA Live VDM is a new approach to deliver predefined views to analytics applications. To be able to use SAP HANA Live you need to have your source table in SAP HANA.

Integration Approach and Side-by-side Approach

In the Integration Approach, you have your SAP Business Suite (ECC, CRM, etc.) on HANA. The other option is to use SAP BW. If you are using BW on HANA, data can be replicated from the source system to BW in real time (SLT). In both approaches real-time data is provided to reporting layer. The following picture shows replication to BW.

Transactional and master data from the source systems are immediately replicated to HANA tables, and these become the source for reports and applications. We are working here with an exact copy of the source data. Views on the BW side provide business-oriented data presentation. SAP delivers the entire catalog of pre-defined views required in various business areas. We can work on available structures or copy existing objects and modify them for our purposes.

What is available in standard structures?

You can review available models and structures using SAP HANA Live Browser. Using this UI5 Web-based application you can learn about data structures and dependencies. You can also preview real business data.

What are the types of available views?

We have a few types of views shown in the below picture.

1. Query Views

Views designed for direct use in applications and reports are called query views. In this structure you may convert data and currency, implement user-specific calculations.You should not include them in other structures.

2. Reuse Views

As a component, you can use reuse views. Reuse views are well structured and optimize objects that can be a puzzle of your solution. They are not designed to be directly used by reporting tools. In these structures you are enhancing data with key business logic, calculating fields, joining objects, filtering data.

3. Private Views

Private views represent SQL code executed on one or many tables/views. These are the basic building blocks of the model, usually focused on a small section of business data. Here you are doing basic selection, calculation and joins.

4. Value Help Views

One more type of views I would like to mention is value help view. That view provides value list for a specific business scenario and is used in a value help in a query view.

No comments: