SDMX-NA Webinar 16 th October 2014 Welcome! Webinar to start at 14: 30 CEST Recordings: http: //europa. eu/!ug 86 w. U Eurostat
SDMX-NA Webinar October, Agenda • • • Recap: data transmission workflow Excel: tipps and tricks, common mistakes Converter: issues reported Validation: Fusion Cloud demo EDAMIS: finalisation of dataset configuration • Q&A Eurostat
http: //europa. eu/!ug 86 w. U Data transmission workflow http: //www. sdmx. org/? p=1498 SDMX-NA maintenance page Excel templates SDMX Converter (Validation) EDAMIS https: //data. sdmxcloud. org/ http: //europa. eu/!WR 67 CC https: //webgate. ec. europa. eu/edamis Eurostat
http: //europa. eu/!ug 86 w. U Data transmission workflow http: //www. sdmx. org/? p=1498 SDMX-NA maintenance page Excel templates SDMX Converter Eurostat (Validation) EDAMIS
SDMX-NA Maintenance Page • http: //www. sdmx. org/? p=1498 • Take care which version you download • Note: • there is no T 0107 • T 0119 is OECD only, not applicable for EU Eurostat
Excel templates: flags This overrides that Eurostat
Excel templates: flags This is under embargo until then This is not under embargo! This is confidential Eurostat
Reporting confidentiality Treatment of confidentiality: F: will always be published, embargo ignored N + embargo time: will be published after the embargo N without embargo time: will never be published buy may be shared internally, N flag is forwarded C: will never be published Note: the XML file counts, not the Excel source! Eurostat
Excel templates: flags This is under derogation Value: Na. N Flag: J Eurostat
Reporting missing values Treatment of Na. N: • Case sensitive • Only allowed and required with flags J/L/M Flag: J: under derogation please report such series M: does not exist L: exists, but not available (e. g. no sources) caution: might lead to incompliance Eurostat
Excel – templates with "year tabs" Eurostat
Excel – templates with "year tabs" Make sure the same series attributes are used in all tabs: • Sender footnote • Last update • Unit multiplier • Decimals • … Eurostat
http: //europa. eu/!ug 86 w. U Data transmission workflow http: //www. sdmx. org/? p=1498 SDMX-NA maintenance page Excel templates SDMX Converter Eurostat (Validation) EDAMIS
http: //europa. eu/!ug 86 w. U Data transmission workflow SDMX-NA maintenance page Excel templates SDMX Converter http: //europa. eu/!WR 67 CC Eurostat (Validation) EDAMIS
Tip: SDMX Converter - Validation Use "SDMX Validation" function in Converter. bat -header_file %HEADER% -dsd_file %DSD% -validation true xxx. xls xxx. xml EXCEL COMPACT_SDMX Eurostat
SDMX Converter • Issues with regional settings reported in some countries • New version of converter expected within 1 -2 weeks • Workaround available, change Converter. bat file: "%JAVA_HOME%binjava" -Duser. language=en -Duser. country=EN -Xmx 2048 m -classpath %Classpath%; com. agilis. sdmx. converter. ui. Converter. CLI %* • Please make sure you use newest Converter as far as possible Eurostat
SDMX Converter • Issues with memory reported in some countries • Change Converter. bat file: "%JAVA_HOME%binjava" –Xmx 1536 m -classpath %Classpath%; com. agilis. sdmx. converter. ui. Converter. CLI %* • • 1536 m theoretical maximum on 32 bit Java Can be much higher on 64 bit Java Your maximum may be lower (PC memory) Large tables require more memory (REG, SUIOT) Eurostat
http: //europa. eu/!ug 86 w. U Data transmission workflow SDMX-NA maintenance page Excel templates SDMX Converter http: //europa. eu/!WR 67 CC Eurostat (Validation) EDAMIS
http: //europa. eu/!ug 86 w. U Data transmission workflow SDMX-NA maintenance page Excel templates SDMX Converter (Validation) https: //data. sdmxcloud. org/ Eurostat EDAMIS
Fusion Cloud Validation - Demo https: //data. sdmxcloud. org/ ü ü ü ü Create account Login Upload data file Choose DSD Look at report If OK, select dataflow Loot at report again ü If OK Note: tool is hosted online, do not upload embargo or confidential data Eurostat
http: //europa. eu/!ug 86 w. U Data transmission workflow SDMX-NA maintenance page Excel templates SDMX Converter (Validation) https: //data. sdmxcloud. org/ Eurostat EDAMIS
http: //europa. eu/!ug 86 w. U Data transmission workflow SDMX-NA maintenance page Excel templates SDMX Converter (Validation) EDAMIS https: //webgate. ec. europa. eu/edamis Eurostat
EDAMIS for ESA 2010 • Use new EDAMIS datasets • • • NAMAIN_… NAREG_. . . NASEC_… (801 SAV uses same as 801) NASU_. . . GFS tables use old ESA 95 identifiers! • EDAMIS configuration to be fine-tuned • Legal deadlines & reminders to be added • Dataset for GDP Flash to be created (NAMAIN_FLASH_Q) Eurostat
Other topics • LIVE Stream, Friday, 17/10/2014, 11: 00 CEST: Eurostat publishes ESA 2010 EU 28 GDP figures • http: //ec. europa. eu/avservices/ebs/schedule. cfm • ESTP SDMX Basic course and SDMX-NA workshop: • Back to back 2 -3 March and 4 -6 March 2015 • http: //epp. eurostat. ec. europa. eu/portal/page/porta l/pgp_ess/about_ess/estp Eurostat
Скачать презентацию SDMX-NA Webinar 16 th October 2014 Welcome Webinar
ff7af99abcfbd754f968375059a71c84.ppt