-
Notifications
You must be signed in to change notification settings - Fork 4
5. Structures
The query /DMO/ANA_C_STR_Measure contains a set of calculated and restricted measures. In the preview you can see that all these objects are assigned to a 'measure structure'. The 'measure structure' behaves like a dimension at runtime: It can be assigned to rows- or columns-axis (but not free-axis) and filters can be set.
The query /DMO/ANA_C_STR_Char shows a second structure, which is called "characteristic structure". The annotation @AnalyticsDetails.query.onCharacteristicStructure: true assigned an element to that structure.
The query /DMO/ANA_C_STR_Char_Frml shows a second structure, which contains formulas.
Also see the blog post How to define an analytical query using two structures.
The query /DMO/ANA_C_STR_Measure_Hier shows multiple measures which are displayed in a hierarchical way.
The query /DMO/ANA_C_STR_Cell has a measure-, a characteristic- structure and exception cells. In this example, the exception cell emptyCell overwrites a cell spanned by the measure and characteristic structure.
Also see the blog post How to define an analytical query using cell definition.
The query /DMO/ANA_C_STR_Cell_Ref contains exception cells which overwrite existing cells in the grid (e.g. ShareOccupied) or which are relevant for calculations but not for the resultset (e.g. Max2024). Furthermore, it shows how to use the value of cells in the grid with the scalar function GET_CELL_REFERENCE_VALUE.