Structures are combinations of InfoProvider key figures and characteristics. A structure has multiple purposes. It can be used to form the basic framework of the rows or columns for a query result. Structures provide precise control of where key figures and characteristic appear in a result. A structure can also be defined as reusable so it provides a ready-made layout that benefits future query developers who need to the same layout.
Structures are built from selections and formulas.
Key Figure Structures
In the BW Query Designer in SAP HANA Studio, a Key Figure Structure appears automatically when you move a key figure from the InfoProvider section to the Rows or Columns sections.
Components are basic key figures, restricted key figures, and calculated key figures or formulas.
Key figures in rows or columns are always components of a key figure structure.
Each component of a key figure structure must contain a key figure.
You can use only one key figure structure in a query.
You also can define Characteristic Structures: The structural elements of a characteristic structure cannot contain any key figure selections.
- Use one or more characteristics and filtering to define the selections of the components of the structure - for example, single values, ranges, or hierarchy nodes.
- Use variables for flexible selections.
- The components of a characteristic structure cannot contain key figure selections, but they can contain formulas.
The difference between a characteristic structure and the use of characteristics on an axis is as follows:
- Characteristic structure: You specify the number, sequence, and the content of structure elements in the query definition.
- Characteristics on an axis: All selected characteristic values are displayed in the report.