Show TOC

Generating SAP HANA Views for InfoObjectsLocate this document in the navigation structure

You can generate InfoObjects SAP HANA views for queries in the SAP HANA database.

Prerequisites

To generate an SAP HANA view, an InfoObject must meet the following prerequisites:

An attribute view can be generated if

  • the InfoObject is a characteristic and it contains master data or texts.
  • the master data access is Standard.
  • the Attribute Only flag has not been set.
An analytic view for analysis and reporting can be generated if
  • the characteristic is an InfoProvider.
  • the characteristic contains master data or texts.
  • the master data access is Standard.
  • the Attribute Only flag has not been set.

This cannot be combined with the function for virtual master data in SAP HANA.

Context

Attribute views and analytic views can be generated.

The attribute views generated in this way can be used for analyzing master data. Alternatively, you can use these views in other models; for example in models where the transaction data comes from SAP HANA and the master data comes from the BW system.

The external attribute view of an InfoObject also contains all text fields as hidden attributes.

The attribute view of an InfoObject does not have input parameter keydate. However, there are corresponding placeholders ($$keydate$$) for the time-dependent tables used. An entry must then be made for the placeholder during SQL access using the addition (´PLACEHOLDER´ = (´$$keydate´, ´20130101´)). When using the attribute view in other SAP HANA views, you can define a keydate parameter and assign it to the attribute view's placeholder.

Procedure

InfoObjects in the Data Warehousing Workbench

  1. You are in the Data Warehousing Workbench in the Modeling area. Proceed as follows: Creating InfoObjects: Characteristic.
  2. If you want to generate an analytic view, you have to mark the InfoObject on the Master Data/Texts tab as an InfoProvider.
  3. Go to the Master Data/Texts tab and set the External SAP HANA View for Master Data flag for an attribute view or External SAP HANA View for Master Data Provider for an analytic view.
  4. When the InfoObject is activated, an SAP HANA view corresponding to the structure of the object is generated on the SAP HANA database.

InfoObjects in the BW modeling tools:

  1. You are in the modeling of an InfoObject in the BW modeling tools. Proceed as follows: Creating Characteristics
  2. If you want to generate an analytic view, you have to activate the Usable as InfoProvider flag on the General tab.
  3. Go to the General tab page and set the External SAP HANA View for Master Data flag for an attribute view or External SAP HANA View for Reporting for an analytic view.
  4. When the InfoObject is activated, an SAP HANA view corresponding to the structure of the object is generated on the SAP HANA database.