4.5 Creating ConceptScheme & Codelist
In the context of SDMX, a ConceptScheme is a structured list of concepts used to define the dimensions and attributes of a dataset. When creating a data model, it’s important to identify and define the key concepts that are relevant to the data being collected.
One way to define these concepts is through the use of code lists, which are standardised lists of codes that classify objects based on a specific concept. For example, in a dataset on population demographics, the code list for the concept of sex might include codes such as Men, Women, and Both Sexes (Total).
To create Codelists and ConceptSchemes, you can use the SDMX Constructor by following these steps. First, upload the Code List and then the ConceptScheme. By completing these steps in sequence, you can create both artefacts in one go.
Create Codelist:
- Click on the Codelist button on top and ensure that the folder we created before, LOCAL_REGISTRY, is selected from the Codelist Editor’s ‘Load from registry’ dropdown option, as shown below.
Click here to enlarge the image
- Click on the Bulk load button as shown below.
Click here to enlarge the image
- It will open up a pop-up window, as shown below.
Click here to enlarge the image
- Copy the Codelist table (Table: 4.4) we prepared before and paste its contents here. Before pasting, remember to click on the ID column (shown in white in the image below). Then, select the entire row (by clicking on the little arrow (pointing at the right) at the beginning of the rows).
Click here to enlarge the image
- After pasting, remember to delete the header row. You can do this by selecting the entire row (by clicking again the little arrow pointing at the right at the beginning of the rows) and clicking the button (“-”) below, as indicated by a downward red arrow.
Click here to enlarge the image
- Enter the Agency ID and Version on the top row as DEMOLAND_NSO and 1.0, respectively, as shown below. If only the top row contains entries (DEMOLAND_NSO and 1.0) and the rest is empty, it implies that the Agency ID and Version are repeated for each row.
Click here to enlarge the image
- Click on Load, as shown below.
Click here to enlarge the image
- After the loading, this is how it would look (as shown below).
Click here to enlarge the image
- Clicking on any item on this list will show the details on the right pane, as shown below.
Click here to enlarge the image
Create ConceptScheme:
- Click on the ConceptScheme button on top and ensure that the folder we created before, LOCAL_REGISTRY, is selected from the ConceptScheme Editor’s ‘Load from registry’ dropdown option, as shown below.
Click here to enlarge the image
- Click on the Bulk load button, as shown below.
Click here to enlarge the image
- It will open up a pop-up window, as shown below.
Click here to enlarge the image
- Copy the ConceptScheme table (Table: 4.3) we prepared before and paste its contents here. Before pasting, remember to click on the ID column and select the entire row (by clicking on the little arrow at the beginning of the rows).
Click here to enlarge the image
- After pasting, remember to delete the header row by selecting the entire row and using the button (“-”) below, as indicated by a downward red arrow.
Click here to enlarge the image
- Click on Load, as shown below.
Click here to enlarge the image
- After loading, the concepts will be visible in the CONCEPT POOL, as shown below.
Click here to enlarge the image
- Move all the concepts from the CONCEPT POOL to the CONCEPT pane by selecting all (ctrl + a), then dragging and dropping. After the move, it would look like the following.
Click here to enlarge the image
- After moving the concepts, enter the details: (ID: CS_DEMOLAND_NSO, AgencyID: DEMOLAND_NSO, Version: 1.0, and Name: Concept Scheme of Demoland NSO) for the ConceptScheme, as shown below.
Click here to enlarge the image
- Then, click the ‘Save with descendants’ from the save option as shown below. This option, ‘Save with descendants,’ will save the concept scheme with the codelist.
Click here to enlarge the image
- A pop-up message will ask to save the XML file in the folder (LOCAL_REGISTRY) we created before. Click on Save to save the file.
Click here to enlarge the image
- After clicking Save, the tool will ask the question to merge files. Select Yes.
Click here to enlarge the image
- A confirmation message will appear for a short time at the bottom right corner, as shown below.
Click here to enlarge the image
- After that, if you go to the file’s location, you will see the XML file created, as shown below.
Click here to enlarge the image
- Opening the XML file will show the details containing, AgencyScheme, ConceptScheme and Codelists.