Show TOC

Modeling Data Flows for Hierarchies with Direct AccessLocate this document in the navigation structure

Use

In BEx queries, you can use hierarchies with direct access. This is recommended for small hierarchies that do not change often.

If the query that uses the hierarchy with direct access is executed, the system compares the hierarchy header data in the buffer with the hierarchy header data in the source system. If the data in the source system is more current than the data in the buffer, the entire hierarchy must be read into the buffer.

Prerequisites

You have created an InfoObject with hierarchies. The InfoObject is assigned to an InfoArea and is therefore an InfoProvider.

The DataSource must be "new" and must be released for the direct access. The source system version must be release SAP BW7.02 or higher.

Procedure

  1. Create a transformation at your InfoObject using the context menu. Enter the DataSource as the source for loading the hierarchy.

  2. In the transformation, you have to fill the hierarchy segments Hierarchy header and Hierarchy nodes.

    Below is an example of a transformation for the hierarchy header:

    Below is an example of a transformation for the hierarchy nodes:

  3. Activate the transformation.

  4. In the context menu of your hierarchy, choose Create Data Transfer Process. DTP for Direct Access is the default value for the DTP type.

  5. Select the DataSource as the source. Activate the data transfer process. More information: Creating Data Transfer Processes for Direct Access. When you activate the DTP, the system automatically activates direct access.

Testing the Direct Access to the Hierarchy

  1. Navigate to the hierarchy maintenance (transaction RSH1) and select your InfoObject. This system displays all hierarchies for this InfoObject.

  2. Next to the InfoObject input field, choose Import Direct Access Header. All hierarchy headers with direct access to this InfoObject are shown as an overview.

  3. Double-click a hierarchy header to select it. The entire hierarchy structure is read from the source system and is displayed.

Result

As with all other hierarchies, you can also use the hierarchy with direct access in the query. The structure of the hierarchy is read in the source system at runtime.