Working with Structures
Structures are objects that you define in the BEx Query Designer.
A structure forms the basic framework of the axes in a table (rows or columns). It consists of structural components. We differentiate between key figure structures and characteristic structures.
Structural components of key figure structures are always based on the key figure selections (basic key figures, restricted key figures, and calculated key figures). Characteristic structural components cannot contain key figure selections.
The setup of the structure determines the sequence and number of key figures or characteristic values in the columns and rows of the query. You can navigate through the structures in the executed query and set filters for them.
If you are using two structures (for example, a key figure structure in the columns and a characteristic structure in the rows), a table with fixed cell definitions is created.
You can save structures in the InfoProvider for reuse in other queries that are based on this InfoProvider.
At least one InfoProvider is available in the BW system.
Defining Structures
Proceed as follows to define structures in the BEx Query Designer:
- In the Rows or Columns directory of theQuery Designer, choose New Structure from the context menu.
- Select the characteristics and key figures of the InfoProvider that you want to use in the new structure and drag them into the structure directory.
Where necessary, restrict a characteristic or a key figure, or define a new calculated key figure.
For more information, seeCreating Reusable Structures
Saving Structures
Save the structures either locally or for reuse:
- Save the structure locally by saving the query.
- Proceed as follows to save the structure for reuse:
- Select the structure in the query and choose Save Structure As… in the context menu.
- Enter a technical name and a description.
Using Structures
Drag the required reusable structure from the InfoProvider screen area into the rows or columns in the Row/Columns screen area.
You can use a maximum of two structures in a query definition. Of these, only one can be a key figure structure. You can combine structures freely with other characteristics on the axes.
Changing Structures
- If you want to change a reusable structure, edit it in the query by removing, inserting, or editing structural components.Caution
Note that the change affects all other queries in which the reusable structure is referenced.
- If you want the change to the reusable structure to affect only one query, you can use the reusable structure locally in this query. To do this, you delete the reference to the reusable structure.
Select the reusable structure in the query and choose Remove Referencein the context menu.
Deleting Structures
If you no longer need a reusable structure, select it in the InfoProvider screen area and choose Delete in the context menu.
Before doing this, ensure that no other queries reference the structure.
You can check this by choosing Where-Used List in the context menu of the reusable structure. In the Where-Used List screen area, the system displays the queries that still reference the structure.
Transporting Structures
To make the reusable structures available in various BW systems, transport them.
If the transport system is activated, a dialog box for specifying a transport request appears when you save the reusable structure. Enter the required transport request.
If a fixed standard BEx transport request is specified, the reusable structures are automatically written to this request and the transport request dialog box is not displayed.
The technical name of the object type (TLOGO) for reusable structures in transport requests is ELEM (ELEM.STR).
More information:
More Information