Difference between revisions of "Series Key"

From FMR Knowledge Base
Jump to navigation Jump to search
(Created page with "Cross product of values of Dimensions where either the cross product or the cross product combined with a time value identifies uniquely an observation. Most Series Keys are...")
 
Line 1: Line 1:
−
Cross product of values of Dimensions where either the cross product or the cross product combined with a time value identifies uniquely an observation.
+
Cross product of values of Dimensions uniquely identifying a series within a dataset. A Series Key that also includes a time value uniquely identifies an observation.
  
−
Most Series Keys are combined with a time value in a Data Set in order to identify uniquely an observation. There may be particular Series Keys that do not require a time value in order to achieve this, so the "Time Dimension" is not obligatory in an SDMX Data Structure Definition. In an SDMX Data Set there must be a value for all of the Dimensions specified in the Data Structure Definition when reporting data for a Series Key. The combination of the semantic of the names of the concepts used by the Dimension (excluding time) describes a Series Key. Unless the Data Structure Definition contains multiple measures this semantic is often the semantic of the
+
Consider a [[Data Structure Definition]]:
 +
{| class="wikitable"
 +
|-
 +
! Position !! Component Type !! Component ID !! Description
 +
|-
 +
| 1 || Dimension || INDICATOR || Indicator
 +
|-
 +
| 2 || Dimension || REF_AREA || Reference Area
 +
|-
 +
| 3 || Dimension || FREQUENCY || Data Frequency
 +
|-
 +
| n/a || Time Dimension || TIME_PERIOD || Observation Time
 +
|-
 +
| n/a || Attribute || UNIT_MULT || Unit Multiplier e.g. tens, thousands, millions
 +
|-
 +
| n/a || Attribute || Observation Status || Observation Status e.g. Estimated, Final
 +
|-
 +
| n/a || Primary Measure || Observation Value || The observation value
 +
|}
 +
The Series Key is the dot (.) concatenation of the Dimensions in the order specified in the DSD.
 +
 
 +
For the DSD above, the Series Key is constructed as follows:
 +
 
 +
'''<INDICATOR>.<REF_AREA>.<FREQUENCY>'''
 +
 
 +
Examples
 +
EN_ATM_CO2E_GF_KT.GRC.A
 +
EN_ATM_CO2E_GF_KT.GRC.M
 +
SH_TBS_INCD.MDG.A
 +
DT_INR_PRVT.GBR.M
 +
 
 +
 
 +
Attributes do not form part of the Series Key so have no explicit or implied ordering.

Revision as of 09:35, 1 February 2021

Cross product of values of Dimensions uniquely identifying a series within a dataset. A Series Key that also includes a time value uniquely identifies an observation.

Consider a Data Structure Definition:

Position Component Type Component ID Description
1 Dimension INDICATOR Indicator
2 Dimension REF_AREA Reference Area
3 Dimension FREQUENCY Data Frequency
n/a Time Dimension TIME_PERIOD Observation Time
n/a Attribute UNIT_MULT Unit Multiplier e.g. tens, thousands, millions
n/a Attribute Observation Status Observation Status e.g. Estimated, Final
n/a Primary Measure Observation Value The observation value

The Series Key is the dot (.) concatenation of the Dimensions in the order specified in the DSD.

For the DSD above, the Series Key is constructed as follows:

<INDICATOR>.<REF_AREA>.<FREQUENCY>

Examples 

EN_ATM_CO2E_GF_KT.GRC.A
EN_ATM_CO2E_GF_KT.GRC.M
SH_TBS_INCD.MDG.A
DT_INR_PRVT.GBR.M


Attributes do not form part of the Series Key so have no explicit or implied ordering.

Retrieved from "https://fmrwiki.sdmxcloud.org/index.php?title=Series_Key&oldid=3714"