Automated parent selection in viz filter for specific dataflows/dsds
As data owner,
I want to be able to configure per dataflow/DSD an automated systematic selection of specific or all parent hierarchy levels (whether they have data or not) whenever a child with data is selected (and only in this case!),
so that the parents get also displayed in the table and the specific child context can be understood by end-users.
Detailed functional specifications
This automated selection does not depend on data availability for the parents concerned. The advanced selection modes also take this auto-selection feature into account. The end-user cannot deselect those auto-selected parents except when using those advanced selection modes that also deselect all children. Parents without data should again automatically be de-selected when the user deselects all corresponding children.
A new SDMX annotation at DF or DSD level is defined for this purpose:
Annotation type | Use case | Where to attach | Annotation title | Annotation text |
---|---|---|---|---|
ALWAYS_DISPLAY_PARENTS | Automatic display of specified parent hierarchy levels (whether they have data or not) or of all parent hierarchy levels** when a child with data is selected | DSD or DF* |
<concept id>=LEVEL<level #>+ LEVEL<level #>+…,<concept id>,… example: REF_AREA,ANALYTICAL_CATEGORIES: LEVEL1+LEVEL3
|
* CL and DIM attachments could be added later to comply with the general SDMX approach for such annotations.
** If no specific level is specified, like above REF_AREA
, then all parent hierarchy levels are concerned.
The generated SDMX data query should contain all currently selected dimension items, even those auto-selected parents that do not have data. The table-generating engine can so easily know from the SDMX data query, which items (whether having data or not) were selected and thus should be displayed in the table and which not.
New design elements
Functional mockups
'Single item' selection mode | 'All items at the same level' selection mode | Whole branch and Item and all items directly below selection modes | 'All items' selection mode |
---|---|---|---|
Example
Annotation title: ANALYTICAL_CATEGORIES=LEVEL1+LEVEL2+LEVEL3
Original request
The idea is to have grayed out title rows for the parents in the hierarchy that have no data, as shown on the picture below.
In the current implementation you need to attach attribute to this dimension member or observation to have this value displayed. For example,
Using "FULL_NAME" annotation with the hierarchy description or dots in it doesn't seem to be an elegant solution as well.
(the request came originally from NBB)