Standardizing and industrializing a business process the dissemination
Standardizing and industrializing a business process – the dissemination use case – Annex 2 Alessio Cardacino - (alcardac@istat. it) ESTP Course “Information standards and technologies for describing, exchanging and disseminating data and metadata” THE CONTRACTOR IS ACTING UNDER A FRAMEWORK CONTRACT CONCLUDED WITH THE COMMISSION Eurostat
Disseminating UNSD’s SDG indicators through the «SDMX Datamanager» web application 2 Eurostat
Acess to the SDMX Datamanager Username: admin Password: admin 3 Eurostat
Import of the DSD 1. In the «Manager Structure» interface of the «Builder» section, click on the «Import Structure» button. 2. In the pop-up window, click on the «Add File» button, select the SDG_PROV+UNSD+1. 0, containing the DSD and the referenced artefacts, and click on the «Upload» button. 4 Eurostat
Import of the DSD 5 Eurostat
Primary hypercube creation In the «Manager Structure» interface of the «Builder» section: 1. select the SDG_PROV+UNSD+1. 0 DSD (that has to be final). 6 Eurostat
Primary hypercube creation 2. Category selection 7 Eurostat
Primary hypercube creation 3. Fill in the «Datacube unique code» textbox the BL_SDG code 4. Click on the «Add Name» button, and in the popup windows fill in the italian and english name of the hypercube: • Sustainable development goal indicators 8 Eurostat
Primary hypercube creation 5. Indication of category, unique code, name (en) and selected components 9 Eurostat
Primary hypercube creation 6. View of the created hypercube under the selected category in the Builder section 10 Eurostat
Mapping of the csv data file against the hypercube structure This task has to be performed only once for importing in a specific hypercube data stored in csv files having the structure of the selected file. 1. In the «Manager mapping» interface of the «Builder» section, click on the «New Mapping. Set» button. 2. Select the hypercube to be mapped: BL_SDG 3. Select the csv file to be mapped: UNSD+DF_UNDATA_SDG+1. 0_ECU. csv 11 Eurostat
Mapping of the csv data file against the hypercube structure 12 Eurostat
Import the csv data file 1. In the «Data import» interface of the «Loader» section, select the mapping previously created: 2. Select the csv data file to be imported: UNSD+DF_UNDATA_SDG+1. 0_ECU. csv 3. Upload the file by clicking on the button «Upload» 4. Preview the data to be imported 5. Click on «Data Import» button 13 Eurostat
Import the csv data file 14 Eurostat
Import the csv data file 15 Eurostat
Hypercubes to be disseminated Starting from the primary hypercube ( «Sustainable Development Goal indicators» ), have to be disseminated in SDMX format and via web service the following Dataflows: • SDG Indicators goal 1: End of poverty in all its forms everywhere - Ecuador. • SDG indicators goal 2: End hunger, achieve food security and improved nutrition and promote sustainable agriculture – Ecuador. 16 Eurostat
Definition of the Dataflows Under the «Sustainable Development Goal indicators» category, have to be created the following dataflows: Dataflow Id Dataflow name (en) SDG_G 1 SDG indicators goal 1: End poverty in all its forms everywhere - Ecuador SDG_G 2 SDG indicators goal 2: End hunger, achieve food security and improved nutrition and promote sustainable agriculture 17 Eurostat
Dataflow creation of SDG_G 1 1. In the «Query builder» section, click on the «New Cube View» button: 18 Eurostat
Dataflow creation of SDG_G 1 2. In the «Dataflow» tab, insert the following information: 19 Eurostat
Dataflow creation of SDG_G 1 3. In the «Query» tab, select the SDG_G 1 hypercube 4. Select the following cube columns: 20 Eurostat
Dataflow creation of SDG_G 1 5. insert the following filter conditions: 21 Eurostat
Dataflow creation of SDG_G 1 6. insert the following filter conditions: 22 Eurostat
Dataflow creation of SDG_G 1 7. Dataflow categorization: 5. Save Dataflow by clicking on the «Save View» button 23 Eurostat
Dataflow creation of SDG_G 2 1. In the «Query builder» section, click on the «New Cube View» button: 24 Eurostat
Dataflow creation of SDG_G 2 2. In the «Dataflow» tab, insert the following information: 25 Eurostat
Dataflow creation of SDG_G 2 3. In the «Query» tab, select the SDG_G 2 hypercube 4. Select the following cube columns: 26 Eurostat
Dataflow creation of SDG_G 2 5. insert the following filter conditions: 27 Eurostat
Dataflow creation of SDG_G 2 6. insert the following filter conditions: 28 Eurostat
Dataflow creation of SDG_G 2 7. Dataflow categorization: 5. Save Dataflow by clicking on the «Save View» button 29 Eurostat
List of the created Dataflow/Views 30 Eurostat
Put in production Dataflow/Views From the Dataflow/Views list, click on Then insert eventually header information about sender and/or receiver for the selected dataflow 31 Eurostat
- Slides: 31