110 likes | 309 Views
Global SDMX Implementation. Experience from on-going projects Daniel Suranyi, Eurostat Project Officer for SDMX implementation SDMX Expert Group, 13-14 September, Paris. Challenge: Global DSD. International Projects (Eurostat perspective). Balance of Payments, National Accounts.
E N D
Global SDMX Implementation Experience from on-going projects Daniel Suranyi, EurostatProject Officer for SDMX implementation SDMX Expert Group, 13-14 September, Paris
Balance of Payments, National Accounts • The SDMX sponsors mandated • ECB, Eurostat, IMF ECB, Eurostat, OECD • To propose Data Structure Definitions for • BPM 6 SNA 2008 • Governance • Steering Group ↔ Coordination ↔ Technical Group
2 0 1 2 2 0 1 3 0 1 4 2 Roadmap – National Accounts Preparation Organisation, planning, data flows Development Domain concepts, draft DSDs, fine tuning Consultations SDMX & NA expert review, acceptance Implementation Pilot projects, system adaption, release Production & Maintenance
General Approach • Definition of domain concepts • Grouping • cross-domain • NA & BoP • NA specific • Coding • Draft DSD • Review
CL Constraints Reporting matrix into SDMX artefacts Data Flow Concept Scheme Code Lists Data Structure Definitions
Comparison: Use a single "Global DSD" • "Not applicable" code in all dimensions • Constraints for sub-setting code lists • "Entry gate" problem • Push: validate selection of data flow • Pull: queries more complex • Complex validation
Comparison: Using multiple derived DSDs • No direct reference to"Global DSD" • to concept scheme and code lists • Multiple files / identifiers • Push: DSD ↔ data flow • Pull: direct query • Maintenance • On DSD level instead of complex mechanisms
Use case: reference multiple code lists • Currently not possible in SDMX 2.1 • to extend code lists by reference • to reference multiple code lists by concept • to use hierarchical code lists for reporting • Current solution • build domain code lists based on COG
Messages • "SDMX Implementation" ≠"Global DSD" • Data flows Concepts Reporting matrix / code lists • Best practise: domain & SDMX experts from the start • A single global DSD per domain is not sufficient • Harmonise reporting needs as far as possible • Additional intelligence around the DSD needed • Derive DSDs, but handle with care • Some technical limitations • Common way of using existing possibilities • Foresee in next version of standard