-
Notifications
You must be signed in to change notification settings - Fork 4
2. Dimension related Features
The query /DMO/ANA_C_DIM_Txt shows how to switch on text for dimension values in the default layout. There is a convenient way if an according foreign-key or text association is maintained in the underlying analytical model (cube-view). In this case you can use the annotation @UI.textArrangement only. If this is not the case you have to specify the text element via @ObjectModel.text.element as well.
The query /DMO/ANA_C_DIM_Attr shows how display attributes are handled. The attributes, in this case DepartureTime and ArrivalTime are only displayed together with the dimension (ConnectionID). Display attributes can neither be used for grouping nor for filtering.
The query /DMO/ANA_C_DIM_Attr_Txt shows how to switch on display attributes in the default layout. The text arrangement can be done in the standard way Display attributes can't be used for slice&dice at runtime. These will be displayed when the dimension field to which these belong are assigned to rows or columns.
The query /DMO/ANA_C_DIM_Hier shows how to add a display hierarchy to the default layout
The query /DMO/ANA_C_DIM_UDH shows how to switch on the row-property to show the data in a hierarchical (sometimes it is called "compact") way by default ("Universal Display Hierarchy"). The levels of the hierarchy are defined by the order of dimensions assigned to the rows-axis. The feature with a similar annotation is available for the column-axis. Note that by default the totals position is at the bottom. This means the hierarchy nodes expand upwards (on row level). The position of the totals can be changed with annotation @Analytis.settings.rows.totalsLocation or @Analytis.settings.columns.totalsLocation.
The query /DMO/ANA_C_DIM_Unbooked shows how to "fill up" the drill down of a dimension with values from the dimension which are not part of the query result. This is useful for example:
- With special filters there is not data available for all month of a query but a chart is needed which shows all month
- The business user is interested e.g. in products which were not sold.
The query /DMO/ANA_C_Key_Disp shows how to display a compounded key for a dimension using @AnalyticsDetails.query.keyDisplay settings (the setting can be use for hierarchy nodes too). In the example the key will be displayed by compounding the two key fields AirlineID and ConnectionID of the underlying cube view.