Show TOC

Storing Generated SAP HANA ViewsLocate this document in the navigation structure

Package in SAP HANA

The generated SAP HANA views are stored in a content package in SAP HANA. This Content package should be write-protected. Only read-only authorization should be given for the SAP HANA views.

In Customizing, under Start of the navigation path SAP NetWeaver Next navigation step Business Warehouse Next navigation step General Settings Next navigation step Settings for Generating SAP HANA Views of InfoProviders End of the navigation path, you can set which SAP HANA Content package the SAP HANA views are stored in.

If you have more than one BW system on your SAP HANA database, you have to specify a different package for each BW system.

If the present package does not contain any objects, you can change its name in Customizing. If it does contain objects, and you want to change its name anyway, you first have to create a new Content package in SAP HANA Modeler and move the objects there.

If you do not make any entries for the package in Customizing, the name of the Content package will be system-local.bw.bw2hana. If the InfoProvider that you want to generate the SAP HANA view from is in a special namespace, a sub-package is created with this namespace.

For queries as InfoProviders, the system creates a sub-package called query. The naming convention for queries is system-local.bw.bw2hana.query.<IPROV>.<queryname>.

Example

The query as InfoProvider is called @QMY_QPROV. The package is named system-local.bw.bw2hana.query, and the created view is named MY_QPROV.

For CompositeProviders from the BW workspace, the system creates a sub-package called workspace.

Example

The CompositeProvider is called @3MY_COPR and is created in BW workspace my_workspace. The package is named system-local.bw.bw2hana.workspaces.my_workspace, and the created view is named MY_QPROV.

Name of SAP HANAView

The SAP HANA view is given the name of the InfoProvider minus the namespace prefix. For InfoObjects, the generated attribute view is given the name of the InfoObject, while the analysis view is given the name <InfoObject>_REPORTING.

For queries as InfoProviders, the generated analysis view is given the name of the query as the InfoProvider minus the @Q prefix.

For CompositeProviders in the BW workspaces, the generated SAP HANA view is given the name of the CompositeProvider minus the @3 prefix.

Type of the SAP HANA View
The type of the SAP HANA view is determined automatically from the properties of the BW object. SAP Note 2236064 Information published on SAP site describes how to ensure that all generated SAP HANA views are of type Calculation View.