Show TOC

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

You can generate attribute views and analytic views for InfoObjects in the SAP HANA database.

Prerequisites

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

  • It must be a characteristic and have master data or texts.
  • If the flag for high cardinality is set, the characteristic must have master data.
  • The master data access must be standard.
  • The Attribute Only flag has not been set.
  • The characteristic must be assigned to an InfoArea and must be flagged as an InfoProvider, so that an SAP HANA view can also be generated for the master data provider.

Context

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

  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 assign an InfoArea on the Master Data/Texts tab page.
  3. Go to the Master Data/Texts tab page 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.