DE Support for non-calendar year reporting at observation level
As Hugh
I want the Data Explorer/Data Viewer to take the "REPORTING_YEAR_START_DAY" (and "REPYEARSTART") attribute into account when interpreting non-calendar year time periods in the data table and chart and to display them in the appropriate way
So that I can understand to what underlying calendar time periods the data relate to.
There are 2 documents for the related SDMX standard:
- Section 6 – Technical Notes
-
Guidelines on Non-Calendar Year Reporting of Data
Note that the SDMX standard allows also the alternative usage of "REPORTING_YEAR_END_DAY" (or "REPYEAREND") but its usage is much less frequent and, if required to be supported, should then be implemented within another ticket.
Specification:
When the "REPORTING_YEAR_START_DAY" (or "REPYEARSTART") attribute at dataset(/dataflow), time series or observation level is being used in the DSD (with a fixed representation (xs:gMonthDay), e.g. having as value "--07-01" for specifying 1st of July as the start of every reporting year), then the value of this attribute needs to be taken into account when interpreting and displaying time periods in the Data Explorer/Data Viewer as follow:
Frequency or time period format | Reporting year start day example | SDMX time period ID example | Label display ltr (EN) | Auto-flag ltr | Label display rtl (AR) | Auto-flag rtl |
---|---|---|---|---|---|---|
Annual | "--07-01" | "2001-A1" or "2001" | "2001/2002" | "2001-07-01 – 2002-06-30" | "2002/2001" | "2002-06-30 – 2001-07-01" |
Half-yearly | "--07-01" | "2001-S1" | "2001/2002-S1" | "2001-07-01 – 2001-12-31" | "2002/2001-S1" | "2001-12-31 – 2001-07-01" |
Quarterly | "--07-01" | "2001-Q1" | "2001/2002-Q1" | "2001-07-01 – 2001-09-30" | "2002/2001-Q1" | "2001-09-30 – 2001-07-01" |
Monthly | "--07-01" | "2001-M01" or "2001-01" | "2001-Jul" (current monthly formatting) | - | "[2001-07]" (current monthly formatting) | - |
Monthly | "--07-15" | "2001-M01" or "2001-01" | "2001/2002-M01" | "2001-07-15 – 2001-10-14" | "2002/2001-M01" | "2001-10-14 – 2001-07-15" |
Weekly | "--07-01" | "2001-W01" | "2001/2002-W01" | "2001-07-01 – 2001-07-07" | "2002/2001-W01" | "2001-07-07 – 2001-07-01" |
Daily | "--07-01" | "2001-D001" or "2001-01-01" | "2001-07-01" | - | "2001-07-01" | - |
Notes:
- For the frequencies/time formats mentioned, the DE should auto-generate flags with these texts in the corresponding time period table cells.
- There are currently no changes to the time range selector in the DE.
Example data:
- DSD DS_WPI_OS_4: Using attribute "REPORTING_YEAR_START_DAY" attached at dataset level, see: https://de-qa.siscc.org/vis?lc=en&df[ds]=qa%3Astable&df[id]=DF_WPI_OS_4&df[ag]=ABS&df[vs]=0.0.1&av=true&pd=%2C&dq=......Q&lb=bt
structures: all_structures_WPI_OS_4.xml
data: RYSD_data_4.csv - DSD DS_WPI_OS_3: Using attribute "REPYEARSTART" attached at dataset level, see: https://de-qa.siscc.org/vis?lc=en&df%5Bds%5D=qa%3Astable&df%5Bid%5D=DF_WPI_OS_2&df%5Bag%5D=ABS&df%5Bvs%5D=0.0.2&av=true&pd=%2C&dq=......Q
structures: all_structures_WPI_OS_3.xml
data: RYSD_data_3.csv - DSD DS_WPI_OS_2: Using attribute "REPORTING_YEAR_START_DAY" attached at observation level, see: https://de-qa.siscc.org/vis?lc=en&df%5Bds%5D=qa%3Astable&df%5Bid%5D=DF_WPI_OS_3&df%5Bag%5D=ABS&df%5Bvs%5D=0.0.1&av=true&pd=%2C&dq=......Q
structures: Structure_WPI_OS_2.xml
data: RYSD_data_2.csv