Show TOC

SAP HANA Views for Hierarchies Locate this document in the navigation structure

If you generate a SAP HANA view for an InfoObject that has hierarchies, a SAP HANA view is generated for the hierarchies too.

If the InfoObject is not selected as an InfoProvider, and the External SAP HANA View for Master Data flag is set, an attribute view and an internal hierarchy view are generated. This internal hierarchy view cannot be used in a query.

If the InfoObject is selected as an InfoProvider, and the External SAP HANA View for Master Data flag is set, an attribute view, an internal hierarchy view and a calculation view are generated as a reporting hierarchy view that can be used directly in a BI front end.

Information about the Internal Hierarchy View

The internal hierarchy view is given a name with the following format: <IOBJNM>_HIERARCHY. It is a calculation view of type DIMENSION. It can be used in other SAP HANA views.

Information about the Reporting Hierarchy View

The reporting hierarchy view is given a name with the following format: <IOBJNM>_REPORTING_HIERARCHY. It is a calculation view of type CUBE.

It can be used standalone in order to display the characteristic values in a hierarchical structure. The transaction data is aggregated accordingly.

You can use the following input parameters: hieid (hierarchy ID) and keydate (default: current date).

Information about the Input Help View for Input Parameter hieid

The name of the input help view is HIEID_F4. A subpackage help_view is contained in a content package. Example: <path_set_in_customizing>/help_view/HIEID_F4.

This view is generated with the hierarchy view. For all basic characteristics, the hierarchy IDs with the key and a text with the format <basicchar_name><hier_name><validity> are displayed.

If the input value for parameter hieid does not match any of the characteristic's hierarchies, all characteristic values under the NotAssigned node are displayed in the hierarchy.

Restrictions:

The following functions are not supported:

  • Link nodes, multiple parents
  • Parent-child nodes with the same node name
  • Time-dependency of the hierarchy structure or of the entire hierarchy and version-dependency of the hierarchy
  • Intervals
  • Characteristic nodes in the hierarchy, which are not defined as external characteristics
  • If the hierarchy contains external characteristics that are not listed in the editing screen for the characteristic, the SAP HANA view only contains part of the data.

The following functions are displayed differently:

  • Unassigned nodes are always displayed under the NotAssigned node and are not suppressed like in the BW back end.
  • In a reporting hierarchy view with transaction data, all nodes in the hierarchy are displayed, with the exception of leaves of the basic characteristic without transaction data.