Microdata preview should display dimension values in specified order and indented according to their hierarchy
As Yavuz,
I want that the microdata preview is displayed with dimension values ordered and indented according to their hierarchy, similarly to the normal data table,
So that the microdata preview is more meaningful and easier to read.
Functional specifications
Applying the same rules as for the normal table, the rows of the microdata table should be sorted for all dimensions in the order listed in the table columns according to their (in priority order):
- explicit order through HCL
- explicit order through the ORDER annotations
- implicit order in codelist
In addition, the dimension value should be intended according to their level in the displayed hierarchy.
Also see:
- https://sis-cc.gitlab.io/dotstatsuite-documentation/using-de/viewing-data/preview-table/custom-data-view/implicit-explicit-order/
- https://sis-cc.gitlab.io/dotstatsuite-documentation/using-de/viewing-data/filters/advanced-hierarchies/
Examples
Case 1
- Structures: OECD.GOV.SIGM-DSD_SIGMA_DF_SIGMA-1.0-all.xml
- Data: OECD.GOV.SIGM-DSD_SIGMA_DF_SIGMA-1.0-data.csv
The expected order is defined in the CL_CRITERIA
codelist used by the CRITERIA
concept, which is:
- SIGM_1111_1
- SIGM_1111_2
- SIGM_1111_3
- SIGM_1111_4
- SIGM_1111_5
- SIGM_1112_1
- SIGM_1112_2
- SIGM_1112_3
Case 2 with HCL indentation
- Structures: OECD.GOV.SIGM-DSD_SIGMA_DF_SIGMA-1.0-all.xml
- Data: OECD.GOV.SIGM-DSD_SIGMA_DF_SIGMA-1.0-data.csv
New structure for hierarchy in criteria codelist :DSD_SIGMA_V2_Multiple.xml
Case 3 with HCL code list and indentation
I have already defined HierarchicalCodelist linked to my DF. I should be able to see already defined HCL on microdata table display while it's show mix and without indentation.
Full Structure : OECD.SDD.SDPS-DSD_DD_HCL-1.0-all.xml
HCL :OECD.SDD.SDPS-HCL_PRODUCT_DD_HCL-1.0-all.xml
Dataset example :TEST_DATA.csv