4.7 Creating CategoryScheme

A CategoryScheme groups similar objects based on shared characteristics, providing a hierarchical structure that helps classify and organise data and metadata meaningfully.

Referencing our two initial tables (Table: 4.1 and Table: 4.2), we will create a CategoryScheme using the Table Modeller option in the SDMX Constructor. The categorisation could be by topics such as ‘Unemployment Rate’ and ‘Population outside the labour force’.

  • First, we will click the CategoryScheme button and enter the properties (ID: CAS_BY_TOPIC, AgencyID: DEMOLAND_NSO, Version: 1.0 and Name: Categorisation Scheme By Topic) as shown below.

Click here to enlarge the image

  • Click on “Add New Category”, as shown below.

Click here to enlarge the image

  • It will open a pop-up window, as shown below. Enter the details: ID: UNER (shorthand for Unemployment Rate) and Name: Unemployment Rate.

Click here to enlarge the image

  • Click on the Load “Dataflows” button, as shown below.

Click here to enlarge the image

  • It will open another pop-up window to select the dataflow through the Registry.

Click here to enlarge the image

  • Select the Registry (LOCAL_REGISTRY), then the dataflow, and press Apply as shown below.

Click here to enlarge the image

  • A message will appear as shown below.

Click here to enlarge the image

  • Clicking the OK button will lead you to the following window.

Click here to enlarge the image

  • As shown below, move (dragging and dropping) the dataflow to the ‘attached dataflows’ space.

Click here to enlarge the image

  • Clicking “Apply” in that pop-up will take you to the following window, showing the entry into the CATEGORY POOL.

Click here to enlarge the image

  • Move it to the right pane, as shown below.

Click here to enlarge the image

  • Then hit Save (Save without descendants), and it will show the pop-up windows to ensure the location where it saves the file, as shown below.

Click here to enlarge the image

  • Clicking on Save will ask the confirmation to merge the file. Select Yes.
  • Repeat the process for the other category, ‘Population outside the labour force’. The final view would be as follows:

Click here to enlarge the image

  • The XML file (by going to the location of the folder we created before and opening the XML file) would be like the one below.

Click here to enlarge the image