May 22 2017 SDMX DATA MODELING Example Foreign

May , 22 2017 SDMX DATA MODELING “Example : Foreign Trade data (From Website) Rafik Mahjoubi Rafik. MAHJOUBI@oecd. org Kamel ABDELLAOUI abdellaoui. kamel@ins. tn

Merchandise Trade by Commodity, HS 2012 COMMODITY TIME PERIOD REPORTER PARTNER INDICATOR FREQUENCY Hidden Concepts TRADE FLOW TIME FORMAT OBSERVATION VALUE UNIT MEASURE

Merchandise Trade by Commodity, HS 2012 COMMODITY TIME PERIOD REPORTER PARTNER INDICATOR FREQUENCY TRADE FLOW TIME FORMAT OBSERVATION VALUE UNIT MEASURE

Concept ID Concept Name FREQ Frequency TIME_PERIOD Reference period REF_AREA Reporter COUNTERPART_AREA Partner COMMODITY Commodity TRADE_FLOW Trade flow OBS_TYPE Indicator OBS_VALUE Observation value CONF_STATUS Confidentiality status DECIMALS Decimals OBS_STATUS Observation status TIME_FORMAT Time format UNIT Unit Concept Scheme: CS_FOREIN_TRADE

Concept Role Concept ID Concept Name Code List Dimension FREQ Frequency CL_FREQ Dimension TIME_PERIOD Reference period - Dimension REF_AREA Reporter CL_AREA Dimension COUNTERPART_AREA Partner CL_AREA Dimension COMMODITY Commodity CL_COMMODITY Dimension TRADE_FLOW Trade flow CL_TRADE_FLOW Dimension OBS_TYPE Indicator CL_OBS_TYPE Measure OBS_VALUE Observation value - Attribute CONF_STATUS Confidentiality status CL_CONF_STATUS Attribute DECIMALS Decimals CL_DECIMALS Attribute OBS_STATUS Observation status CL_OBS_STATUS Attribute TIME_FORMAT Time format CL_TIME_FORMAT Attribute UNIT Unit CL_UNIT

EXERCICE “Using Generic DSD Matrix for Data Modeling”

Generic DSD Matrix Use the SDMX Glossary for concept IDs and definitions Commonly used Complete the version, maintenance agency, and other details Complete the Concept Scheme overview table with all concepts

Generic DSD Matrix • For each Code List identified in the Concept Scheme overview, add a worksheet called CL_[code list] • Use the Cross Domain Code Lists, Global Registry and other registries to reuse existing code lists

Concept Role Concept ID Concept Name Code List Dimension FREQ Frequency CL_FREQ Dimension TIME_PERIOD Reference period - Dimension REF_AREA Reporter CL_AREA Dimension COUNTERPART_AREA Partner CL_AREA Dimension COMMODITY Commodity CL_COMMODITY Dimension TRADE_FLOW Trade flow CL_TRADE_FLOW Dimension MEASURE_TYPE Indicator CL_OBS_TYPE OBS_VALUE Observation value - Attribute CONF_STATUS Confidentiality status CL_CONF_STATUS Attribute DECIMALS Decimals CL_DECIMALS Attribute OBS_STATUS Observation status CL_OBS_STATUS Attribute TIME_FORMAT Time format CL_TIME_FORMAT Attribute UNIT Unit CL_UNIT Measurement

Generic DSD Matrix

EXERCICE Create Code. List

Reuse codelist

Reuse codelist

Create Codelist

Create Concept Schema

Create DSD