Difference between revisions of "Series Key"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Created page with "Category:Concepts Reference A Series Key is the cross product of values of Dimensions uniquely identifying a series within a dataset. =Overview= Consider the following [...")
 
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
[[Category:Concepts Reference]]
 
[[Category:Concepts Reference]]
A Series Key is the cross product of values of Dimensions uniquely identifying a series within a dataset.  
+
[[Category:How_To]]
 +
A Series Key is a string expression consisting of a '.' or ':' separated list of Dimension values uniquely identifying a single series within a dataset.<br>
 +
Example
 +
A.E7.CAD.ERD0.A
 +
 
 +
In the SDMX REST API, series keys may also describe cubes containing multiple series from a dataset.<br>
 +
A+M..ESP..
 +
The above example selects series where:
 +
* Dimension 1 has a value of either 'A' or 'M'
 +
* Dimension 3 has a value of 'ESP'
 +
* All other dimensions can have any value
 +
 
  
 
=Overview=
 
=Overview=

Latest revision as of 23:12, 10 September 2023

A Series Key is a string expression consisting of a '.' or ':' separated list of Dimension values uniquely identifying a single series within a dataset.
Example

A.E7.CAD.ERD0.A

In the SDMX REST API, series keys may also describe cubes containing multiple series from a dataset.

A+M..ESP..

The above example selects series where:

  • Dimension 1 has a value of either 'A' or 'M'
  • Dimension 3 has a value of 'ESP'
  • All other dimensions can have any value


Overview

Consider the following 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

In SDMX, Series Keys are generally written by concatenating the Dimension values with dots (.) in the order specified in the DSD.

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

<INDICATOR>.<REF_AREA>.<FREQUENCY>

Examples

ATMCO2.GRC.A
ATMCO2.GRC.M
TBSINDC.MDG.A
TBSINDC.GBR.M

Attributes do not form part of the Series Key because they have no role in uniquely identifying series or observations.

In some implementations, Series Keys use a colon (:) separator:

Q:S:L:A:TO1:A:5J:A:5A:U:5R:N
Q:S:L:A:TO1:A:5J:A:5A:U:5C:N
Q:S:L:A:TO1:A:5J:A:5A:U:1N:N
Q:S:L:A:TO1:A:5J:A:5A:U:3C:N
Q:S:L:A:TO1:A:5J:A:5A:U:1C:N

Series Keys with time value

A Series Key that also includes a time value uniquely identifies an observation.

                    2015    2016    2017    2018    2019    2020
ATMCO2.GRC.A         278     290     298     304     312     209         
TBSINDC.MDG.A        631     678     645     655     662     669

In the above example ATMCO2.GRC.A.2015 identifies the 2015 time period with observation value 278.