Entering content frame

Procedure documentation Creating HPA Indexes Locate the document in its SAP Library structure

Prerequisites

Communication between the BI system and the HPA server takes place using RFC modules. You have to make the following settings in order to connect a HPA server to the BI system.

·        Set up the RFC destination for the HPA server (transaction SM59). For more information, see Customizing under SAP Customizing Implementation Guide ® SAP NetWeaver ® Business Intelligence ® Connectivity of TREX ® Creation of RFC Destination in BI System.

·        Determine the RFC destination for the HPA server (transaction RSADMIN). The HPA RFC Destination parameter has to correspond to the above RFC destination.

Note

Note on system landscape

Only one HPA server can be used for each BI system. This is because the master data tables stored in the HPA server can be used by multiple HPA indexes. However, this does not work if the data is distributed across various HPA servers.

However, various BI systems can store their data on the same HPA server and access it there as long as there is enough room on the server. It is thus not necessary for each BI system in the productive landscape to have its own HPA server. The system ID is used to keep the indexes separate.

Procedure

Access from Data Warehousing Workbench

...

       1.      You are in the Data Warehousing Workbench in the Modeling functional area. In the navigation window, choose InfoProvider and in the InfoProvider tree, navigate to the InfoCube whose queries you want to optimize.

       2.      In the context menu of the InfoCube, choose Maintain HPA Index. The HPA Index Maintenance screen appears.

Access from Transaction RSDDV

...

       1.      On the Aggregate/HPA Index Maintenance: Select InfoCubescreen (transaction RSDDV), choose the InfoCube you require.

       2.      Choose This graphic is explained in the accompanying text HPA Index. The HPA Index Maintenance screen appears.

The user interface draws on the maintenance of relational aggregates: In the left side of the screen, the system displays InfoCubes for HPA Indexes with dimensions, characteristics and navigation attributes in a tree structure.

       3.      Unlike the procedure with aggregates, it is not necessary to make specific selections and restrictions for the definition of the HPA index. Instead, there is only one HPA index for each InfoCube. This HPA index contains all the data of the InfoCube. Select the InfoCube you require and choose This graphic is explained in the accompanying text Create.

In the right-hand window, the description of the HPA index that you need to create appears. In the Save column, the system displays the icon This graphic is explained in the accompanying text to indicate that you have not yet saved the index. The status display of the Object Version and Object Status shows This graphic is explained in the accompanying text. This indicates that the HPA index is inactive and has not been filled with data.

Note

For more information about the description of the HPA index (Table/Indexes and Properties) in the right-hand area of the screen, see Design and Properties of HPA Indexes.

       4.      If you want to split the fact table differently to the system’s calculations, you can change this setting in the context menu of the Fact Index Parts property (see Design and Properties of a HPA Index).

       5.      Save theHPA Index.

Result

You have created a HPA index for the required InfoCube. In order to use the HPA index for reporting, you have to activate it and fill it with data. For more information, see Activating and Filling HPA Indexes.

 

 

 

Leaving content frame