Select language:
Entering content frame!--a11y-->

Object documentation Structures 

Definition

Objects that appear in the Query Designer and can be defined freely.

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 set up 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 structure in the executed query and set filters for it.

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.

Note

You have to use two structures as a prerequisite for defining exception cells. You can override the value of cell values created implicitly at the intersection of two structural components. See Defining Exception Cells

Use

Structures and their structural components are complex objects. Structural components can be formulas or selections.

Caution

In key figure structures, each selection structural component has to consist of one key figure selection along with possible characteristic selections.

Within a query definition you can use either no structures or a maximum of two structures. Of these, only one can be a key figure structure.

You can combine structures freely with other characteristics on the axes.

Key figure structure

A structure appears in the Query Designer automatically if you move a key figure from the left selection window for InfoProvider objects into the rows or columns of the query definition. The structure that the system creates automatically is identified by the This graphic is explained in the accompanying text symbol and contains the default name Key Figures as a proposal.

You can change this default name.

...

  1.  Select the structure and choose Properties from the context menu (secondary mouse click). This brings you to the structure properties dialog box.

  2.  Change the name if necessary, and choose OK.

 For more information, see Structure Element Texts and their Language-Dependency.

Caution

Note the following when using key figures in a query:

§  Key figures in the Rows or Columns are always a component of a structure.

If you place a key figure in the Filter area of the query definition, the key figure is not a structural component. In this case, you can still use up to two characteristic structures in the rows or columns.

§  You can use key figures in a query in only one structure.

§  Each structural component of a key figure structure must contain a key figure.

Characteristic structure

If you want to use a structure in the query with several characteristic values, you first have to create a structure and then insert the required characteristic values.

...

  1.  Use the right mouse button to open the context menu in the columns or rows and choose New Structure. The default name for the structure is Structure. You can change this default name. See above under Key Figure Structure.

  2.  Use Drag&Drop to move the required characteristic values from the left selection window for the InfoProvider objects into the structure.

Although a key figure has to be available in the form of a structure for the query, the use of a characteristic structure is optional. The difference between a characteristic structure and the use of characteristics on an axis is that with the characteristic structure, you have already specified the number and sequence of the characteristic values in the query definition. If you use a characteristic on an axis, all posted characteristic values for the characteristic are displayed in the query. You can restrict the selection of specific characteristic values by setting a filter.

Special features when using two structures

Note that when you use two structures, you can include a characteristic in only one of the two structural components of a selection structural component.

Example

If you have made a selection in a structure element for one structure on the characteristic fiscal year, you cannot use the fiscal year characteristic as a selection in the other structure.

Hierarchical display of structures

You can arrange the structural components in a structure hierarchically.

Use the right mouse button to call the context menu and choose Level Down or Level Up. The hierarchical relationship of the structural components is displayed in the executed query like a presentation hierarchy. You can expand and collapse the nodes.

Arranging the structural components

You determine the sequence of the structural components when you add a key figure or characteristic to the structure below another. You can change the sequence later by selecting the structural component and using Drag&Drop to move it to the required position further up or down.

Copying structural components

The components of key figure structures often contain very complex objects that are made up of formulas or selections. If you want to reuse the definition of a structural component within a structure, you can copy the structural component, paste it into the structure and continue to work with it. This enables you to create similarly structured structural components quickly and easily.

Example

For example, if you want to use the formula for a calculated key figure (K1) in another calculated key figure (K2), you can copy K1 and continue to build the formula in K2.

From the context menu of the structural component, choose Copy and from the context menu of the structure, choose Insert. You can also copy structural components using temporary storage locations (Ctrl-C, Ctrl-V).

Saving structures for reuse

You can use structures in several different queries. You have to save them in the InfoProvider to reuse them. These structures are then called reusable structures. For more information, see Creating Reusable Structures.

Integration

Considered abstractly, you can think of a structure as a characteristic. However, the following differences exist between a characteristic and a structure:

·  Structural components can be complex objects (selections, formulas…) while characteristic values are atomic values.

·  You cannot aggregate structures. For a characteristic, you can determine whether it can be aggregated or not. If a characteristic can be aggregated, the sum of the characteristic values is created automatically. Structural components cannot create sums.

·  If a characteristic is in the drilldown, all posted characteristic values are displayed. Characteristic values that do not include posted values are not displayed. If a structural component does not include posted values, then the structural component is always displayed, and the respective cells for this structural component are empty and have no numbers.

Constraints

The number of structural components in a structure is restricted to 999.

Examples

Plan/Actual Comparison (= Key Figure Structure)

This graphic is explained in the accompanying text

Time Structure (= Characteristic Structure)

This graphic is explained in the accompanying text

Creating a query with two structures

Key figure structure in the rows and characteristic structure in the columns:

This graphic is explained in the accompanying text

 

See also:

 

Displaying Changes for Queries in Workbooks

 

Leaving content frame