Home

SAE Editor User Guide

1. Artefacts Child Count 3 Total 4 Registry DEMO http localhost 49828 TinyRegistry_1_0 Repository asmx State Ok 7 1 2 Agency Data Provider and Data Consumer detail The tree reflects the defined hierarchy in case of hierarchic Agencies data Providers or Data Consumers The detail of agency or provider is developed in two tabs as follow FMR Val de Travers Page 36 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 1 3 en tab Agency ld Parent Agency Parent Description Version Valid From Valid To 1 0 Name 36 dition z Description L association a pour but des activit s d dition de publication et de diffusion dans les domaines de w la litt rature du th tre de la po sie de la philosophie des arts plastiques de la photographie de la musique et de toutes les formes d art plundisciplinaires www_edition 36 net URN Is Extemal Ref Contacts For details see Additionnal Tab Maintenance Disseminator Others Guenat Laurent Auderset Patrick Collector Reporter j The tab allows specifying the element attributes In case of hierarchy the parent information is given as read only information If any link is given in textual information the link can be activated A summary of contacts is also displayed in this tab 7 1 4 Contacts Detail tab Organisation Contacts A g Contacts a
2. Name a Full Target Identifier Identifier Components Partial Target Identifiers SE amp CATEGORY ax 1 Organisation Schemes y Component ee 5 Partial target ID D fase 2 AGENCY CategorySchemes Q Codelists Name HierarchicalCodelists Agency Concept Schemes ee Metadata Structure Definitions SDDS CONTACT INFO SDDS Contact Info Text n def M Targetidentifiers COMPONENT PRIMARY CONTACT REPORT COMPONENT S PRIMARY CONTACT REPORT CATEGORY R E CONTACT_REPORT_COMPONENT Report for F CONTACT_REPORT_CATEGORY Report for Pri Data Structure Definition 7 Structure Sets 7 Processes ul DataSet 8 Metadata Set Component References Assigned METADATAFLOW DATA_PROVIDER The partial keys defined are listed on the left of the detail view The right area is used to edit detail of selected key in list A dual list is available to assign the subset of full target identifiers associated to the partial key The dual list reflects the available identifier components A tool bar is available to operate on partial targets Creates a new key in partial identifiers list Deletes selected key in partial identifiers list FMR Val de Travers Page 55 75 www sdmx ch wr d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 7 3 Report The target Report detail view is comp
3. n Target Attributes Values 5 ame 5 Oo Target Ref 4 1 Organisation Schemes FT FULL ESMS Dataflows of Metadataflows Target Value CategorySchemes oa Target List J ConceptSchemes H Metadata Structure Definitions 7 Data Structure Definition of J StructureSets J Processes fl DataSet TIME_PERIOD Time Dimension E MetadataSet ESMS_LIKE_MSD REPORT_FULL Component Target Value DATAFLOW DATA_PROVIDER DataProvider The Row detail screen is composed of two tabs The first one groups the target keys values defined to identify the row During row creation the Target ref is automatically added according to associated report information The data grid displays the key values and the selected row in grid is editable via the target ref control This control is presented as a drop down if a code list or a category is associated to the key Otherwise it is a simple text box See below the sample Target value selection for the Data provider key _Target Ref w FULL_ESMS a Target Value oa Swiss Federal Statistical Office Swiss Federal Statistical Office Schweizerische Nationalbank Switzerland CH3 Direction generale des douanes Switzerland CH4 Swiss Federal Finance Administration Switzerland La Cl2 Banque Centrale des Etats de Afrique de l Ouest BCEA Cl4 Ministere de l Economie et des Finances Cote d Ivoire CL2 Banco Central
4. EIRE Dimensions 7 TIME_PERIOD Date of the observat E FREG Frequency ca OBS VALUE Date of the observation L FLAGS_AGR STANDARD FLAG FLAGS KEYT e DIM_MonthlyCollection Monthly Milk P SVALUES_AGR SPECIAL VALUES SPECIAL A Measures Za Fe Attributes VALUE_OWNER value owner M PRECEDINGVALUE preceding value gt ESTIMATED_VALUE estimated value ESTIMATED_FLAG estimated flag I JESTIMATED_VALUE_OWNER estimated val _ COMMENT FROM comment from x FAT I x E Proceed as follow 1 In scheme combo box selects conceptScheme holding concepts to use Check concepts to distribute in a DSD domain Dimensions measures or attributes Transfers them by activating corresponding domain button Proceeds for all domains and all schemes required In DSD Tree reorders concepts with dragging function possibility D M a oe oN Optionally defines Time Dimension concept select it in dimensions and press time dimension button Fills DSD attributes ID Agency ID etc Press Generate button The DSD skeleton artefact is created and can be refined in main editor gt The concept schemes to use should be loaded in memory before using wizard If none available an error message is displayed FMR Val de Travers Page 34 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT No Conceptscheme loaded in memory _
5. recognize the plugins This minimal set of method is achieved by making this interface which declares the methods that are to be implemented by the plugins lt summary gt public interface Plugin lt summary gt An event generator to notify a SDMX ML document is to be consumed by the main application lt summary gt event PluginEvent PluginEventExposed lt summary gt this method will be called when the plugin is activated if RequiresInit is set to true lt summary gt lt param name xDoc gt null or an XML SDMX ML document representing the artefact selected in the main application lt param gt lt param name obExtend gt Reserved lt param gt void Init XmlDocument xDoc object obExtend lt summary gt VisualComponent allows the main application to retrieve the Visual control of the plugin and to incorporate it in the reserved area or as a dislog box lt summary gt lt returns gt the user control implementing this interface lt returns gt UserControl VisualComponent If true the Init method of the plugin is called when activated if false the Init method is not called bool ReguiresInit get The event architecture offers a mechanism for an event generator to notify an event consumer that something happened The event generator does not need to know anything about the consumer Instead it publishes a method de
6. SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 9 PLUG IN 13 9 1 Plug in installation 73 9 1 1 Required annotations 73 9 2 Plug in demo 74 9 3 Interface definition 75 FMR Val de Travers Page 5 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 1 Overview This application is created to manage statistical metadata through SDMX ML documents It is currently used in our NSI It was developed in my free time and is enhanced according to our needs The application is composed of the SAE SDMX ML editor Windows Form NET of an artefact repository Web service and of a Restful service for easy consultation deployment SAE Tool execution environment N execution environment IIS Server gandard syntax for Windows Client SDM X ML ressources 5 access RESTservice 5 NSI plug in Rest Wrapper module hasto implement SDMX SAE Editor Repository Plugin Tiny Re gistry SDMX Artefactsj eee a LA as SMX ML files Producing SDMX document through Database and XML XSLT transformation is quite easy so the goal of this application is mainly to be an integration and navigation tool for non IT people This application is oriented on SDMX ML V 2 0 Structure Artefacts The idea is to hide XML complexity and to illustrate how statistical metadata are integrated in SDMX ML Framework The application adds artefacts in project by reading di
7. SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT SAE Editor User Guide V 0 9 9 30 11 SDMX Structure Artefact Editor SAE An SDMX ML Structure 2 0 Editor ii Copyright C 2009 2012 Philippe Prati ae Ti This program is free software you can redistribute it and or modify ee it under the terms of the GNU General Public License as published by FT the Free Software Foundation either version 3 of the License or yi at your option any later version A This program is distributed in the hope that it will be useful Zi but WITHOUT ANY WARRANTY without even the implied warranty of Fi MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE See the ii GNU General Public License for more details ee ce You should have received a copy of the GNU General Public License if along with this program If not see lt http www gnu org licenses gt es a Contact sdmx nextsoft ch Download http www sdmx ch Acknowledgement Excel Support Free library to generate Excel Workbooks using XML http www carlosag net Tools ExcelXmlWriter Fast Excel file reader with basic functionality by Messir Alex http www codeproject com KB office Excel DataReader aspx PDF Support iTextSharp for PDF generation as GNU Library http sourceforge net projects itextsharp RTF Support NET RTF Writer Library in C as GNU Library http sourceforge net projects netrtfwriter CSV fast Reader MIT License http
8. SDDS Contact Info SDDS Camies SOL argetidentifiers COMPONENT PRIMARY_CONTACT_REPORT_COMPONENT Description PRIMARY_CONTACT_REPORT_CATEGORY F Text n def v CONTACT_REPORT_COMPONENT Report for CONTACT_REPORT_CATEGORY Report for Pri 4 Data Structure Definition 27 Structure Sets URN URI Processes GH DataSet MetadataSet Representation Scheme Category 1 0 SDDS_CATEGORY_SCHEME IMF e The defined keys are listed on the left of the detail view The right area is used to edit detail of selected key in list Name and Description support multi language edition e The items in the list can be reordered through drag and drop operation FMR Val de Travers Page 54 75 www sdmx ch wer x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT A tool bar is available to operate on full targets Creates a new key in identifiers list Deletes selected key in identifiers list Raises a dialog box to edit the Representation scheme associated to the identifier a Edit Reference Type Type Category x Reference Id Agency Version and Name SDDS CATEGORY _SCHE w IMF 1 0 Navigates to representation scheme artefact according to reference given Artefact must be loaded in memory Partial target Identifier Tab This panel is used to define the partial target identifiers These are based on full identifiers m id
9. 1 Measures Codelist Detected Model Linear Rows Attributes DSD Chunked file NO Chunks Not in DSD CSV Data gt 000001 ee NL 66 MILK MMO01 2009 10 970 5 a 00000 M ILKA Cows milk collected 455 000003 M ILK MMOO01 2009 11 4 56 0000 M ILK MMOO01 2005 12 000006 lv ILK MMO001 2009 10 When the cursor is placed in a cell it displays the content name for cell containing code and the header cell concept name for header cell From the selected cell it is possible to directly navigate in editor detail view of associated item for concept code list or DSD item 6 5 Menu Utilities 6 5 1 Copy Artefact Ref This function creates in the MS Window clipboard the urn reference of the artefact or its sub item selected in the tree view The urn can be copied as text or as annotation of type ARTEFACT_ URN Sample of urn urn sdmx org sdmx infomodel codelist Code ESTAT CL_GEOf 7 1 T FMR Val de Travers Page 33 75 www sdmx ch er x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 6 5 2 DSD Wizard This function allows quick creation of a DSD skeleton Optionally it creates also associated code list for Cross sectional measures if any A modeless box is displayed in order to select concepts to associate to the DSD Name Copy references to codelists Create Cross Measure codelist T found in associated concept EDAMIS CONCEPTS Edamis domain concept scheme 2 1
10. access to referred code lists FMR Val de Travers Page 29 75 www sdmx ch er x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 6 3 1 Sub menus definition This functionality allows creating entries to different category schemes that represents view point to the metadata material held in registry See menu sample below registry support V 0 98 87 Categories Data Utilities Help Federal Statictics Multi Annual Programme Statistical products and subproducts Metadata sources references Cross Domains Classifications The sub menu items must be defined in a SDMX codelist located in the repository The code list reference is given in the application configuration file under the tag CategoryRootFullld Example lt add key CategoryRootFulliId value CH1 SMS CL CAT ENTRIES 1 0 gt Each code of the code list represents a menu item entry The name of the code is used as text of the menu item The URI field must contains an SDMX reference to the artifact to load from the repository when this item is activated File Repository Find Import Export Categories Data Utilities Help w x ff B jen 2 Federal Statictics Multi Annual Programme tt SDMA 20 Statistical products and subproducts Id Name Metadata sources references SS Cross Domains Classifications _ Organisation Schemes a s NETT Dataflows aile _ Metadataflows E Federal Statictics Multi Annual Pr
11. jierarchicalCodelists COVERAGE P P p social security schemes social protection expenditure etc Artefact type ALL Specifies artefact type by selecting it in combo box Annotation title unspecified Specifies title to look for Wildchars allowed at start and end of specification Annotation URN unspecified Specifies urn in annotation to look for Wildchars allowed at start and end of specification Annotation Type unspecified Specifies type of annotation to look for Wildchars allowed at start and end of specification Annotation Text unspecified Specifies text in annotation to look for The text is searched for currently selected language Wildchars allowed at start and end of specification FMR Val de Travers Page 27 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT The non modal dialog box grid is then filled with all references found in project memory It is then possible to activate automatically the detailed view of the artefact item holding the selected reference to annotation aw This button activates a search of annotations matching the criteria Activates detail view of the artefact item holding the annotation The dialog box remains open so multiple references can be browsed easily To look for another annotation reference simply change the search criteria and reactivate the search reference function The dialog box is refreshed with the
12. re _TI S ESMS_MSD Euro SDMX Metadata Structure Defini BASE PER Name Metadata Targets sma UNIT_MEASURE STAT_CONC_DEF Statistical Concepts and Definitions li OR og REF_PERIOD ESMS_REPORT_FULL Euro SDMX Metadata ESMS ST_MANDATE eae Bonet ee ee Data Structure Definition H a NF atistical concepts definitions refers to the definition of the statistical B concept under measure e the statistical domain and the ables C sructuresets J a REL POLICY seers ne a C7 Reporting Taxonomies nme FREQ_DISS The type of variable provided raw fiqures annual growth f CG DataSet ACCESS_DOC L Is Multi Codes editable fag Metadata Set a QUALITY_MGMNT Codelist reference t a RELEVANCE Codlist Id ml Version and Name Sq ACCURACY t Eai r Aine irre mines x This panel displays a tree representation of the defined concepts hierarchy On the left side of the hierarchy tree a set of controls allows to edit the selected attribute in the hierarchy tree The text format control can be used to specify details about the attribute text format According to the usage defined the tree reflects a different icon colour A concept reference is associated to the attribute An optional code list reference can also be given References on memory loaded artefacts can be edited A tool bar is available to operate on attributes FMR Val de Travers Page 56 75 www sdmx ch SAE SDMX ML
13. www codeproject com KB database CsvReader aspx Special thanks to Jean Francois Fracheboud Petko Yanev Olivier Rutti and Michel Meyer for their suggestions and support FMR Val de Travers Page 1 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT TABLE OF CONTENTS 1 OVERVIEW 2 OPERATING MODES 2 1 Standalone mode 2 2 Repository basic mode 2 3 Repository with ownership management 2 4 Multiple independent repositories 2 5 Multiplexed Repositories 3 SAE GUI 3 1 Areas 3 2 Menu 3 2 1 File Menu 3 2 2 Repository Menu 3 2 3 Find Menu 3 2 4 Import Menu 3 2 5 Export Menu 3 2 6 Categories Menu 3 2 7 Data Menu 3 2 8 Utilities Menu 3 2 9 Help Menu 3 3 Toolbar 3 3 1 File Menu shortcuts 3 3 2 Repository shortcuts 3 3 3 Active language 3 3 4 Expands Collapses selected tree item 3 3 5 Navigation functions 3 4 Tree view 3 4 1 Quick search 3 4 2 Popup Menu 3 5 Annotations View 3 5 1 Functionalities 3 6 Status bar 3 6 1 Tree Childs count 3 6 2 Registry connection status 3 7 Detail view 3 7 1 Read Only 4 INTERNATIONALIZATION SUPPORT 4 1 Language set definition FMR Val de Travers Page 2 75 10 10 10 11 11 11 11 11 11 12 12 12 12 12 13 13 14 14 15 16 16 16 16 16 17 17 18 18 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 4 2 Multi Language edition 5 MENU REPOS
14. ConceptSchemes d ddi Q9 Artefacts DataSets FMR Val de Travers Page 17 75 www sdmx ch wer 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 4 Internationalization support The application is designed to work with a set of defined languages for artefact texts The display of the language can be modified on the fly through the toolbar functions 4 1 Language set definition The set supported by the application is defined in the configuration file of the application All languages codes of the supported set are defined separated by semi column in the following configuration tag lt add key SupportedLanguages value en de fr it gt The language abbreviation reflects the SDMX xml lang attribute The first language code of the set is used by default during application start Language can be switched on the fly by selecting it in the toolbar language combo box SL SAE SdmxML Structure Editor with Tiny registry Export Categorie File Repository Import h LA I 1 Name Ay Organisation Schemes 4 2 Multi Language edition During text editing the text in the current language can be typed directly in the text box if other languages must be captured too the text box offers a button on its right to expand edition to all supported languages Current language edition Multi Language activated ID AgencylD Version Valid From Vali
15. E Concept Reference Scheme Reference Agency Version and Name CENSUSHUB_CONCE ESTAT 1 2 CensusHub domain concept scheme Name Time format code Codelist reference Codlist Id Agency Version and Name CL_TIME FORMAT ESTAT 1 0 Time Format Text Format Cross Sect Attachement Role Assignement Status Attachement Level The attributes are grouped in a data grid view The selected row of the grid can be edited with the controls of the middle panel The annotation s associated to the selected attribute are reflected in the annotation panel The attributes can be reordered with drag and drop function in the grid For group attachment the group to use can be selected in the attachment dual box Available Assigned This dual box is also used for observation level attachment Assignement Status Attachement Level Available Assigned FMR Val de Travers Page 46 75 www sdmx ch ar ad SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 5 Category scheme 7 5 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition 5 ID AgencylD w Version Valid From Valid To S SDMXStatSubMatDomainsWD1 SDMX 10 5 CategorySchemes E 0 SDMXStat SubMatDomainsWD1 z no C1 Is Final A1 Categories amp SDMX Statistical Subject Matter Domains v CE D Gris El a ei 1 Demographic and
16. E CL_SEX Sex a i 7 Agency H E CL_MARITALSTATUS Marital status 3 0 CL_SEPARATION CH1_RE ms Cc Pa a al T BS e Separation Name fel odes T EE mi URN of concept or Codelist to look for ES gq umisdmcorg sdmcinfomodel code st CodeList CH1_RE CL_SEPARATION 1 0 E Replace by URN Select tems where replacement has to be done H ea E um sdmec org sdmx infomodel codelist CodeList CH1_RE CL_SEPARATION A0 H 7 H A Sel RefType ID Name a E Concept SEPARATION Separation um sdmecorg sdmx infomodel cond ES ta E Concept SEPARATION Separation um sdmx org sdra infomodel cond DSD SEPARATION Personenstatistik BO um sdm org sdmx infomodel data l Ea af 4 SEPARATION Personenstatistik um sdmx org sdmx infomodel data fe El fa ES EJ 3 H E CL NATIONSPOUSEPARTNEROFFOREIGR II L z H E CL_NATIONALITYCATEGORY NationalityC Mania H E CL TYPEACQUISITIONSWISS Type Acquis Df Annot A non modal dialog box is displayed with all references found in project memory in ConceptScheme HierarchicalCodelist DSD or MSD It is then possible to activate automatically the detailed view of the artefact item holding the selected reference Replacement of reference in selected items shown in displayed list is also possible This button activates a search of reference usage for concept or codelist specified in the urn textbox NOTE this is done automatically if the codelis
17. Final E ls Etemal Ref E Is Partial Description his code list provides coded information about the sensitivity and confidentiality status of the data URI Link te resource with additional information Code Value C Name Confidential statistical information Description Contidential statistical information primary confidentiality due to identifiable respondents Measures also should be taken to prevent not only direct access but also indirect deduction or calculation by other users and parties probably by considering and treating additional observations as confidential secondary contidentiality management URN URI Link to resource with additional information The detail screen manages the code attributes The code hierarchy if any is presented in the tree view part Parent information is also visible in the detail screen Code name supports multi language edition FMR Val de Travers Page 39 75 www sdmx ch 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT A Description box is provided in SDMX 2 0 it is persisted in the document as an annotation of type NOTE Others annotation s attached to selected code are visible on the annotation panel 7 2 3 Code hierarchy management e The hierarchy of code is managed with the tree popup menu Code can be added as child of selected item and can be removed with all associated children e Parent hierarchy
18. HeaderRowCount The dialog allows selecting the Excel document and work sheet to use The mapping between rows and columns of the Excel sheet and of the artefact attributes can be defined in the Mapping property editor This mapping can be saved in a file in order to reuse it later The created sdmx artefact is loaded on the application tree It is also possible to import only updated text for example for others languages if a same artefact is already loaded in main application tree and the Text only button is used in import dialog This function allows also importing annotations of different types one by one The dialog is a top window and it is possible to work in application when it is raised FMR Val de Travers Page 68 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT If only the items are part of the excel sheet the artefacts attributes can be edited manually by checking the following checkbox Edit Atefact Attributes manually The Dialog box displays an edition area for artefact attributes Select Artefact Type CodeLists Edit Artefact Attributes manually Artefact Attributes ID AgencylD Version Valid From Valid To Official Title E is Final Excel data Sheet 7 ER Read _ Excel Qo Create SDMX 8 2 Loading an Excel Worksheet This function opens a file open dialog box When the excel document is selected and loaded The sheet
19. HierarchicalCodelists ET Is Final C Is Etemal Ref E le Partial 7T 8 9 10 11 12 HCL_SAMPLE Sample Hierarchical Codelist 7 14 15 16 17 8 B E Codelist Ref Description a2 B M 2 26 HIERARCHY_CASE1 This is a sample Hierarchical Codelist j p se a PS C Aujourd hui 04 03 2011 J Metadata Structure Definitions ai Data Structure Definition URI Link to resource with additional information fe DEMOGRAPHY Data Structure Definition se E Dimensions C Reporting Taxonomies i foe BL FMR Val de Travers Page 49 75 www sdmx ch er 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 6 2 Code lists reference Codelist reference H Organisation Schemes z 1 Dataflows 7 Metadataflows E CategorySchemes zj a CodeLists CL_FREQ Codelist frequency CL_COUNTRY Codelist countn CL_SEX Sex codelist CL_DEMO code list demograpt CL_OBS_STATUS Codelist Ob Alias eee CL_DECI Codelist Decimals CL_AREAS ECB 10 CL_TIME_FORMAT Time Forma OE ete CL_UNIT Codelist Unit Codlist Id Agency Version and Name 1 0 Areas code aj CL COUNTRIES S CL COUNTRIES 1 0 Countries co Properties General CL_UNIT_MULT Codelist Unit BE CL_AREAS Areas code list cL AREAS km ECB 1 0 Areas code list CL_COUNTRIES Countries code CL_FREQ 1 0 Codelist frequency ESTAT H Codes s CL_COUNTRY 1 0 Codelist country ESTAT Hierar
20. REGISTRY SUPPORT Creates a set of mappings according to availables codes Deletes selected map item Mapping Edit M Hauptgruppe Warengruppe Indexposition wischenaggregat Ehebungsposition El Codes 1 Total _ 2 Haupiouppe 3 Warengruppe l 4 Indexposition 5 Zwischenaggregat 6 Ehebungsposition The mapping dialog box allows user to specify source and target items bs typing values in corresponding text boxes or by selecting value in codes trees The apply button record each mapping To terminate mapping creation the user activates the quit button The set of mapping is reflected in the grid of the map detail view The dialog box checks the submitted mapping and refuses it if it is already defined in the map FMR Val de Travers Page 67 75 www sdmx ch weer gt SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 8 Excel The application supports import of Excel document for artefacts like code list hierarchical code lists concepts and categories A simple mapping can be defined between excel worksheet columns and artefact attributes 8 1 Excel Import dialog Import from Excel document Select Atefact Type CodelLists Excel data Sheet H Artefact unused E Attributes unused Annotation Type ABBREV ColParent Mode DescriptionColumns NameColumns E Concept Col Text Format E Grouping keyff many aroupltg El Header Allinne Row
21. can also be redefined with popup menu functionality Id Name sneral Redefine Parent of items me 6 7 Missing value data not c _ 2 8 Missing value data undef gt Right click on desired new children then press Apply E 9 Missing value supressed Codes i 10 Break t 100 Transfer Types El CL TEKSMS_EVTCHG Records al Expiration deletion Merger 100 Transter Types 3 Take over E 1 Expiration deletion Breakdown gt E 2 Merger Split off E 3 Take over Transfer m E 4 Breakdown 7 Transfer with take over 2 ss E 5 Split off 8 Transfer with split off 6 Transfer Hierarchical transfer e 7 Transter with take over fF 10 Code change re 5 8 Transfer with split off 6 11 Name change E 9 Hierarchical transfer Z 10 Code change 11 Name change E I 5 CL TEKSMS_MSTATUS The sta 1 Complete E 2 Not valid 1 Activate the dialog box via the popup menu Select target parent in tree view and press button Set Parent Select items to place under the selected parent with right click in corresponding tree items Press button Apply to see the result Redo the operations for another parent or save the result with the save button Usage of the Cancel button discards all previous operations and closes also the dialog box Redefine Parent of items Se Restart with other Parent o
22. changing the artefact located in repository Simply answers Undo checkout only in the proposed dialog box 5 2 5 Menu Repository Submit aggregated Artefacts to Repository When ownership management is activated in TinyRegistry configuration only administrators can use this functionality It allows saving as a unique document the whole memory project lf some of the artefacts of the project are already present in repository as single document The artefact full ID that is used to identify the document in the repository is the one of the artefact currently selected in the tree view As it is not a standard operation a confirmation is required Caution Please confirm that the whole project all artefacts has to be P saved as a unique aggregated document Identified as MY_NSI D5D_GLOBAL 1 0 Annuler FMR Val de Travers Page 24 75 www sdmx ch wer 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 5 2 6 Menu Repository Update Texts of Finalized Artefact This command allows to update texts of an already finalized artefact located in registry Name and Description are updated for the artefact And for code list category scheme and concepts schemes name and description of embedded items are also updated The artefact with updated text must be selected in tree before activating the functionality The user has to be be the owner of the artefact 5 2 7 Menu Repository Impor
23. drop down is filled with the names of all excel worksheets Se em ZZ icdScm a The Grid displays the content of the first excel worksheet see below It is possible to select another worksheet with the drop down box As soon as another sheet is selected the grid is refreshed with the sheet content Rows and columns are numbered to help mapping process T ead The displayed cells can be edited if a small modification is to be done The application uses the free component ExcelDataReader of Alex Messir FMR Val de Travers Page 69 75 www sdmx ch wr d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Excel data Sheet Column 1 Column2 _ Column3 _ Column4 SCL Intemation Code Description Remark TOTAL Total ISCO1 TO 5 Non manual wak This aggregate in L 8 3 Mapping property editor The mapping properties are as follow 8 3 1 Internationalized text mapping For the texts that are defined in some of the supported languages of the application a column mapping must be given for each language The property editor displays a dropdown grid for specifying column index for languages to import For unused language sets the column index to zero If all columns are set to zero the property displays unused Note that a least one language for name column is required by SDMX specifications DescriptionColumns NameCol
24. identifiers information Id Name 5 ID Agenc verion Valid From Valid To 6 SDDS_CONTACT_INFO IMF sto a 3 Name E Is Final C Metadataflows SDDS Contact Info ae Lo FH bii Description 4 HierarchicalCodelists Text n def 1 ConceptSchemes amp 2 Metadata Structure Definitions SRE SDDS CONTACT_INFO SDDS Contact Info i E Targetidentifiers COMPONENT owe EE PRIMARY_CONTACT_REPORT_COMPONENT E PRI MARY_CONTACT_REPORT_CATEGORY F i E CONTACT_REPORT_COMPONENT Report for i CO NTACT_REPORT_CATEGORY Report for Pri 7 Data Structure Definition C Structure Sets 7 2 Target Identifiers The target identifiers detail view is composed of three panels Full target identifier Tab The first panel regroups full target identifier information attributes more or less similar to artefact attributes detail view Name and Description support multi language edition Identifier components Tab This panel is used to define the full target identifier keys Id oo Full Target Identifier Identifier Components Partial Target identifiers 6 METADATAFLOW xX 4 p 2 OrganisationSchemes 8 DATA_PROVIDER Component Dataflows 5 COMPONENT Component ID Metadataflows S ia Citos CATEGORY C Codelists Target Object Class C HierarchicalCodelists 4 ConceptSchemes Category ii 6 Metadata Structure Definitions Name SDDS_CONTACT_INFO
25. is the user responsibility to redefine eventual duplicated id after a parent redefining The full identification is used for display See Code detail paragraph for explanation about hierarchy redefinition dialog box e Categories can be reordered in current level with drag and drop operation in tree e Finally category scheme can be constructed with the Excel import functionality Note Some SDMX category artefact documents do not use the Composed identification convention in categories The application allows it but the tree display is a bit clumsy FMR Val de Travers Page 48 75 www sdmx ch er SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 6 Hierarchical Code List Hierarchical code list allows defining variant hierarchy on codes It also allows managing history of codes validity 7 6 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition The URI box allows a link to additional information When filled a navigation button is available The checkbox Is Partia has no meaning in SDMX 2 0 3 SAE SdmxML Editor with Tiny registry su Import Export Categories Utilities Options E Q HCcLSAMPLE encylD Version m Organisation Schemes 9 TN Name H Category Schemes M Coegnisdions Sample Hierarchical Codelist lun mar mer jeu ven sam dim H CodeLists 3167 2 3 4 5 EC
26. new material FMR Val de Travers Page 28 75 www sdmx ch 4 x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 6 2 Menu Import Export See Excel paragraph 6 3 Menu Categories lt is nice to have coherent navigation entry points For this the Categories menu allows you to define categories artefact to load from repository in order to navigate between artefacts through different views You can provide in the application configuration file some full ID to load specific categories designed for navigation like category for statistical activities category for transversal codelists Then by clicking on navigation arrows of the detail view you can directly load and access referred artefacts 3 O N SAE SdmxML Standalone Editor RO X File Import Export Categories Utilities Options Help A fd en v E Q 101 DEMS 2009 Year id 5 Name Category ID Version Parent Category Parent Description 2009 1 0 1 01 DEMS Demographic statistics 5 6 ORG_ESTAT Organisations Agencies DataProviders 7 DataConsumers C1 Dataflows H 6 DF_DEMOGRAPHY How Demography DSD 1 Metadataflows Properties General z el 3 M n 9 2 S Among the kinds of data that national leaders need are the demographic statistics of their population Records of births deaths mamiages immigration and emigration and a regular census of population provide information th
27. selected tree item This function allows a full expand or collapse of the selected item in tree Combined with navigation functions it allows a quick consultation on artefact items information 3 3 5 Navigation functions CLAISIFREFAREA These buttons allow navigating in the history of selected tree items There are also navigation buttons on detailed view associated to referenced artefacts By using them the referred artefact if in memory can be automatically selected in the tree FMR Val de Travers Page 13 75 www sdmx ch wer SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 4 Tree view The tree view presents the collection of artefacts loaded in memory These artefacts are ordered by types Each artefact is identified by its id name and version if other than 1 0 Sometimes items of artefacts are also presented in the tree w Organisation Schemes Dataflows i Metadataflows CategorySchemes 1 CodeLists HierarchicalCodelists Concept Schemes Metadata Structure Definitions 5 6 CENSUSHUB CensusHub Data Structure Defini E Dimensions E Measures E Attributes C Groups 7 StructureSets Processes ET Data Set a MetadataSet 3 4 1 Quick search Id Name Searching in tree for a specific ID or a specific name is done with the quick search area The search type is specified by a radio button The text to search is specified in th
28. the application the artefact selected in the grid Import A double mouse click on a grid item activates the same functionality Loads in the application the artefact selected in the grid The artefact is locked in the repository and only the actual user will be allowed to submit an Check Out update of this artefact to the repository This operation is password protected Remove selected artefact from Repository CAUTION uses appropriately X Delete Backup retrieval Artefact backup selection Select backup version to load in project memory When submitting an artefact to the registry it is possible to preserve the previous content already present in the ee ors registry as a backup So if some backup of selected artefact is available it is reflected in the Artefact backup count information box Clicking on the backup count raises a dialog box that allows the user to select the backup to load instead of the current content of the selected artefact 5 2 3 Menu Repository Reserve Artefact check out It is also possible to reserve an artefact of the repository through this menu if it is already present in memory This avoids using the repository list dialog The system asks if replacement of artefact is needed FMR Val de Travers Page 22 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT A Artefact is already in memory refresh it with Repository Ve
29. this case ColParentKey is not required 8 3 3 Header rows This information indicates the number of rows to skip in the excel sheet before importing items codes and texts 8 3 4 Artefact main attributes lf artefact main attributes are placed in one horizontal row of the excel sheet they can also be imported during the import process If not uses the manual edition check box E Artefact Attributes E used Row 2 CollD 1 ColAgencylD 2 NameColumns EE ColVersion 7 DescriptionColumns unused Attrihidtes 8 4 Artefact creation 8 4 1 Function create co This function operates the conversion of the Excel worksheet content to the Create Specified artefact type according to the specified mapping If some of the required SDMX artefact attributes are missing the application opens the manual edit box and raises a warning message Simply fills missing info and reactivates function FMR Val de Travers Page 71 75 www sdmx ch wr d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT amp Excel Import Select Artefact Type CodeLists V Edit Artefact Attributes manually Artefact Attributes ID Version Valid From Valid To ISCO88 a 10 Official Title SCL Intemational Standard Classification of Occupations for European Unionp _ Is Final X Artefact ID AgencylD and Name are required Maan ISCO1_TO_5 Non manual work This aggregate in 8 4 2 Function u
30. tree Removes selected item and all associated children Remove Selected Item A confirmation is requested Redefines the parents hierarchy of the Artefact items Redefine Parent Examples are code list categories and concepts Same as in utility menu This creates in the MS Window Copy Artefact Reference clipboard the urn reference of the artefact or its sub item selected in the tree view Save selected artefact as an SDMX document Save as SDMX document If an artefact type container is selected all artefacts held by the container are included in the created document New Artefact version Creates a copy of the selected artefact The copy has its version number updated FMR Val de Travers Page 15 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 5 Annotations View The annotation view displays annotation s attached on the selected item of the tree view or of the detail view Annotations can be managed through the annotation view buttons T Annotations BES Title Text Um The Census European Hub is the proposal of a conceptually new system to achieve the dissemination of the 2011 the Eurostat website he SDMX standards besides defining standard formats for data and metadata also define an architecture for data exchange SDMX provides guidelines and tools to support the pull mode of data sharing where the collecting organisation retrieves the data CONCEPT from the p
31. x oe 1 S o S S n 12 13 14 15 16 17 18 19 20 21 22 23 24 2 26 27 28 29 30 1 2 3 4 5 6 7 8 9 Aujourd hui 02 04 2010 This panel displays The Levels definition FMR Val de Travers Page 52 75 Valid To 2008 12 31 Code in codelist History Nb code Standard code Artefact type Codelist Hierarchical Codelist Generate www sdmx ch y SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Information Hierarchy Levels Levels Id Order Coding M 1 le ty el Undefined 2 First level Undefined M 3 5 Second level Undefined Order Coding Type fi Undefined Name Text Type Top level i _ Is Sequence Description Min Length Max Length Text n def Start Value End Yalue URN Interval Time Interval Decimal es ed ae The central panel allows editing the level selected in the levels grid Name and Description support multi language edition The coding type edit control is presented in an activated state It allows specifying details about coding type FMR Val de Travers Page 53 75 www sdmx ch eg x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 7 MSD 7 7 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition All defined reports are presented as child of the MDS as well as target
32. 7 Groups 7 StructureSets of Processes gg DataSet a8 Metadata Set 7 Role Concept Cross Att Name Codelist Text Type 7 TIME Group Time period or range Year JE a lie CLAGE Unie Current activity status CL_CAS Undefined Properties General cont Observation Geographical area CL Undefined HO Observation Sex CL_SEX Undefined EE FREQ Group Frequency ICLFREQ Undefined i p Concept Reference Scheme Reference Agency Version and Name CENSUSHUB_CO NCE ESTAT 1 2 CensusHub domain concept scheme Concept Id Name GEO Geographical area Codelist reference Codlist Id Agency Version and Name CL_GEO vy ESTAT 1 1 Geographical code list Text Format Cross Sect Attachement Role undid omaten r ens Dimension from the geographic selection This was chosen as simple as possibile one national level one regional level and each subsequent level must feature only two sub areas The dimensions are grouped in a data grid view The selected row of the grid can be edited with the controls of the middle panel The annotation s associated to the selected dimension are reflected in the annotation panel The dimensions can be reordered with drag and drop function in the grid It is the user responsibility to order them correctly The time dimension is not part of the collection of dimension in the SDMX document so its order is meaningless The vert
33. AL Report Structure ESMS_LIKE_MSD Sample meta data structure c URI Er b Targetidentifiers FULL_ESMS Ref S M OCDNOT ERM Ganis face f 7 9 2 Reference The Application can only work on artefact attributes and on references The categories Tab support is not implemented id 7 oa Name O MSD reference C Datel E Reference Id Agency Version and Name ataflows PeTo EGN A 3 1 0 OFS Initial SDMX Metadata Structure Definition 5 6 WD_MD_INITIAL Initial refrerence metadata NITIAL_ESMS_MSD 1 0 OFS Initial SDMX Metadata Structure Definitior OFS E 5 INITIAL ESMS MSD V 1 0 OFS ail ESMS_LIKE_ MSD 5 0 Sample meta data structure definition using ESTA ESTAT one Colca a SDDS_CONTACT_INFO 1 0 SDDS Contact Info IMF CodeLists 2 HierarchicalCodelists aC Concept Schemes Metadata Structure Definitions al A S INITIAL ESMS MSD OFS Initial SDMX Metada FMR Val de Travers Page 62 75 www sdmx ch er w SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 10 Reporting Taxonomy 7 10 1 Artefact detail Reporting Taxonomy is very similar to category scheme artefact except that it holds data and metadata flows references in the artefact itself 3 SdmxML Standalone Editor File Import Export Categories Data Help 4 S amp S en B OQ Undefined Tetn de ld pe Name ID Version Valid From Valid To RT_GROUP_TR1 v 10 Organ
34. C1 Structure Sets 5 Reporting Taxonomies amp RT_GROUP_TR1 Group Trial URI a Por F oai ter Undefined Text n def LL J 0 pisses 7 11 2 Process Step detail The Process steps can be hierarchic if required Steps are mainly descriptive At each step it can be given a name a description and Computation text information lt is also possible to refer input and output artefact type objects that are concerned by the siep id S C Name T Ss 6 Step Id Parent Step Parent Name c OrganisationSchemes EJ STEP1 E ORG_STF Institutions soumises la N ORG_EDI Federal Department of Ho E ORG_ESTAT Organisations Step Name gt G 1 Agencies AA S 1 DataProviders Sn sl Step Descr a Computation A computation x Input Output CI Mania TE Add ey H 6 MSD_ACTIVITY Reference metadat an x Ca Data Structure Definition en F Pince ts ane Codelis O StructureSets Cone dG Reporting Taxonomies ae l 9 Processes S P_TEST Test 1 1 rs mponent ProcessStep Anno KeyDescriptor fey STEP1 Step Name Measure Descriptor Fer STEP 1 1 Sith Stan Type AtinbuteDescnptor GroupKeyDescriptor Dimension ep Annotation Time Dimension Meaci ire FMR Val de Travers Page 64 75 www sdmx ch er 2 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 11 3
35. Codelist for PSSO16 P 033 CL_CATI_QUEST_Psuivi_c 1 0 OFS_BS_EKL_SILC Codelist for P suivi_cad CL_CATI_QUEST_Psuivi_c 1 1 OFS_BS_EKL_SILC 2008 12 31 Codelist for P Ssuivi_cad CL_CATI_QUEST_Psuivi_c 1 2 OFS_BS_EKL_SILC 2003 12 31 Codelist for P Ssuivi_cad E CL_CATI_QUEST_Psuivi_c OFS_BS_EKL_SILC 2010 01 01 2010 12 31 Codelist for P suivi_cad CL_CATI_QUEST_Psuivi_c 1 OFS_BS_EKL SILC 2011 01 01 Codelist for PS Ssuivi_cad CL_CATI_QUEST_PSUIVI_ 1 OFS_BS_EKL_SILC TEL_EMAIL_CONFIRM 4 ul O O Geo ojojojojojo C ORIC COC OCC eo The grid content reflects the different information s managed by the repository The type of artefact to list can be selected through the Artefact type combo box lf some backup of selected artefact exists it is reflected in the Artefact backup count information box FMR Val de Travers Page 21 75 www sdmx ch wer SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT It is also possible to redefine repository source from this dialog Dialog Menu Repository Source Grid functions B List Activate the list request used at first demand and to obtain a filtered list Note when the type of artefact is changed the list action is automatically called Redefines diffusion status Default is Internal Diffusion Select Diffusion Status New diffusion status E Internal No diffusion Public Internal Loads in
36. H R_SILC_CATI SILC HOUSE R_SILC_CATI 1 0 Report for SILC CATI questionnaire eE HOSBO80 2009 H E HO9B090 2009 H HOSH15 2009 H Moi L HO9H16 2009 H H09H17 2009 H H09H18 2009 H HO9H 20 2009 H 2 MHDS 2009 H HE HOSHO20 2009 H HOSHO310 2009 H CA computer assisted telephone interview HO9HO31T 2009 H E HOSHO31F 2009 H za AI Tae od Il Title Text Child Count 144 Registry http localhost 50095 TinyRegistry Repository asmx State Ok The Set Id Agency Id and version are not part of the SDMX 2 0 standard they are added to provide enough information to the TinyRegistry for managing generic metadata document This information is stored as an annotation of type SetiD in the document An internationalized title name can be given and reference to metadata structure definition and report can be selected from those in memory lf metadata structure is not available in memory a red icon signals it FMR Val de Travers Page 57 75 www sdmx ch er SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Metadata Reference _ Scheme Reference Agency MSD SDMX HD Report Id Name RS Rows of metadata can then be created by the popup menu new child or by the create row function button New rows can only be created if the metadata structure and report information is available in memory 7 8 2 Artefact row detail
37. IN_MANDATE Name ly CONF Frequency of dissemination ly REL_POL Context Info e FREQ_DISS The rate to which dissemination happens or is repeated Hy DISS_FORMAT Eo Ha ACCESS_DOC According to the associated concept text type the attribute value can be selected from a list edited in different languages or written in a simple numeric or text box See below sample for an internationalized attribute value FMR Val de Travers Page 59 75 www sdmx ch Attributes Values 5 FULL_ESMS Er E CONTACT CONTACT_ORGANISATI CONTACT_UNIT CONTACT_NAME CONTACT_JOB_TITLE CONTACT_MAIL_ADDRE CONTACT_EMAIL CONTACT_PHONE CONTACT_FAX META UPDATE DATA_PRES UNIT_MEASURE REF_PER IN_MANDATE 7 8 4 Attribute value This is an intemationalized metadata value SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT X E OQ contactorcar Includes Concept context in report en This is an intemationalized metadata value fr Fes est une m tadonn e intemationalis e report of metadata embedding HTML A specialized view can be activated to display edit attribute values that uses embedded HTML See below sample of an item of an ESMS report H E 05 01 Consumer Price Index CPI E E 05 02 Swiss construction output price inc E E 05 03 Producer and Import Price Index F _ E E 05 04 Purchasing Power Parties PPP H E 05 06 Health insurance premium index I 5 05 08 Harmo
38. ITORY 5 1 Introduction 5 2 Usage from SAE Editor 5 2 1 Menu Repository Define repository WS source 5 2 2 Menu Repository Get Artefact 5 2 3 Menu Repository Reserve Artefact check out 5 2 4 Menu Repository Submit Artefact check in 5 2 5 Menu Repository Submit aggregated Artefacts to Repository 5 2 6 Menu Repository Update Texts of Finalized Artefact 5 2 7 Menu Repository Import local Image copy 6 OTHER MENUS 6 1 Menu Find 6 1 1 Locate References 6 1 2 Find Annotations 6 2 Menu Import Export 6 3 Menu Categories 6 3 1 Sub menus definition 6 4 Menu Data 6 4 1 SQL 6 4 2 CSV 6 5 Menu Utilities 6 5 1 Copy Artefact Ref 6 5 2 DSD Wizard 7 ARTEFACTS DETAIL VIEW 7 1 Organization Scheme 7 1 1 Artefact detail 7 1 2 Agency Data Provider and Data Consumer detail 7 1 3 Organisation tab 7 1 4 Contacts Detail tab Tez Code Lists 7 2 1 Artefact detail 7 2 2 Code detail 7 2 3 Code hierarchy management 7 3 Concept Scheme 7 3 1 Artefact detail 7 3 2 Stand Alone concepts 7 3 3 Concept detail 7 3 4 Concept hierarchy management 7 4 DSD 74 1 Artefact detail 7 4 2 Dimensions 74 3 Measures 7 4 4 Attributes FMR Val de Travers Page 3 75 www sdmx ch 18 20 20 20 20 21 22 23 24 25 25 25 25 25 2 29 29 30 31 31 31 33 33 34 36 36 36 36 37 37 39 39 39 40 41 41 41 42 42 43 43 44 45 46 wr SAE SDMX ML STRUC
39. L_INFO eg REL_POL_US_ACT a FREQ_DISS MIS PAnR at FMR Val de Travers m CONF D CONF POLICY 431 01 Loi du 9 octobre 1992 sur la statistique f d rale LSF 431 011 Ordonnance du 30 juin 1993 concernant l organisation de la statistique f d rale 431 012 1 Ordonnance du 30 juin 1993 concernant l ex cution des relev s statistiques f d raux Ordonnance sur les relev s statistiques CONF DATA TR Religions niveau de protection des donn es 3 donn es personnelles sensibles Contrat de protection des donn es avec mandataires externes z POLICY REL_PC REL CAL POLICY Au plus tard 1 an apr s l enqu te Disponible pr ciser Tous les canaux pr vus par DIAM pr ciser Page 61 75 www sdmx ch er 2 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 9 Data flow and Metadata flow 7 9 1 Artefact detail ld e Name 5 ID AgencylD Version Valid From Valid To ND_MD_INITIAL OFS 10 H E OrganisationSchemes EI Name ls Final a Dataflows SS o 6 Metadataflows amp initial refrerence metadata nip 0 6 ID MD_INITIAL Initial refrerence metadata a aie or ge Des INITIAL_ESMS_MSD V 1 0 OFS eee a CategorySchemes CodeLists 7 HierarchicalCodelists aC Concept Schemes a C1 Metadata Structure Definitions amp INITIAL_ESMS_MSD OFS Initial SDMX Metada URN i Targetidentifiers INITIAL_ESMS ESMS_REPORT_INITI
40. Lnit_F3 INDIVIDUAL tems asked at indiy E _DURABLES Durables 2 BASIC_NEEDS Basic needs Ll J Text EE E Unmet nee The target variables relate to three different types of units UNMET_NEEDS Un Th bl hree diff of LEISURE_SOC_ACT Leisure 1 ancy A The irate idee sn ss he de HUE environment financial stress and durables except possession ass ge as an lof mobile phones are asked at household level and refer to 5 C_BASIC_NEEDS Basic nee the household as a whole E EDUC _OR_LEISURE_NEED E MEDICAL NEEDS Medical r aie on the 7 a sages r phone basic needs unmet needs as well as leisure an 2 sen nel social activities in the category adult items must be provided a structure Definition CONTEXT for each current household member or if applicable for all ZE Structure Sets ke selected respondents aged 16 and over OO Reporting Taxonomies 3 Child Children s items relate to all household members aged under 16 to be compatible with the data collection defined in the EU SILC Framework Regulation Export ConceptScheme information as PDF document It includes associated code lists 7 3 2 Stand Alone concepts Note Stand alone concepts are not managed by the application If such an SDMX document is loaded the global concepts will be grouped in a simulated scheme This can create errors if global concepts of different agencies or version are in the document See sample belo
41. Maintenance Others Contact 9 mm Name E Hr 9 Disseminator H Reporter S E Others Department Auderset Patrick 36 Tricet de Karapus Guenat Laurent D Role Co Fondateur Email edition edition 26 net Contacts are displayed in a tree The detail of a contact reflects the selected item in the contact tree As Others contact can be a collection of contact A group box allows to create or remove others contacts FMR Val de Travers Page 37 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Tel Email Fax URI A grid groups these attributes They can be created as follow X400 Edit selected row of the group information A specialized dialog box is open in order to specify the group row attributes Creates a new row for information group x Deletes selected row in group FMR Val de Travers Page 38 75 www sdmx ch ar VA 7 2 Code Lists 7 2 1 Artefact detail SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT The detail screen manages the standard artefact attributes Name and Description support multi language edition The URI box allows a link to additional information When filled a navigation button is available The checkbox s Partial has no meaning in SDMX 2 0 Id J Metadataflows 7 CategorySchemes LS Plug in Ce General i 6E CL_CURRENCY code lis
42. Please load them and press refresh button Matching items Please Select Concept Type ESTIMATED VALUE estimated value Concept Type ESTIMATED FLAG estimated flag Concept Type ESTIMATED VALUE OWNER estimated value owner FMR Val de Travers Page 35 75 www sdmx ch 4 x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 Artefacts detail view 7 1 Organization Scheme 7 1 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition The Service Ref Tab is provided for future SDMX 2 1 SL SAE SdmxML Structure Editor with Tiny registry support V 0 97 File Repository Import Export Categories Data Utilities Help ex EP Best E O 05 M3 6 Organisation SDMX Target SDMX2 0 AgencylD Version Valid From Valid To E Organisation Scheme a rganisation Schemes OS M3 TES 10 E 5 5 O5_M36 Organisation Altemative BL Agencies if DataProviders Name Organisation Altemative fa Mure E ls Final E ls Extemal Ref E ls Partial 1 CategorySchemes m C Categorisations Desci iption BS oe f Sous le nom 36 dition est constitu e au sens des articles 60 et suivants du Code Civil Suisse une J HierarchicalCodelists association qui a son si ge Ste Croix Sa dur e est illimit e 2 C ConceptSchemes 1 Metadata Structure Definitions URI Link to resource with additional information
43. Process Step Transitions Transition to next step can be documented with a list of next step ID and a condition documentation internationalized text Transitions This describes the Condition and next step in a transition The Condition text is informational The TargetStep holds the id of the next step in the process if H 6 ORG_STF Institutions soumises a the condition is met H E ORG_EDI Federal Department of ORG_ESTAT Organisations H E Agencies ESI a 6 DataProviders Code value 3 Mutable of Codelist CL_STATE of OFS 4 DataConsumers Agency Properties General ana of Codeist CL_STATE 21 CategorySchemes 7 CodeLists 7 HierarchicalCodelists C ConceptSchemes o Metadata Structure Definitions amp MSD_ACTIVITY Reference meta Ca Data Structure Definition C StructureSets i ane Loos Text rocesses 7 5 8 P TEST Test 1 1 REMARK ne a fork sub state for code 3 of 2 ProcessStep Fer STEP Step Name fes STEP1 1 Sub Step Lauber STEP Newt 7 11 4 Functionalities Edit selected transition in a specialized internationalised dialog box Creates a new transition attached to selected step item Deletes selected transition FMR Val de Travers Page 65 75 www sdmx ch er 2 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 12 Structure Sets 7 12 1 Artefact detail The detail screen manage
44. Repository tiny Registry In this mode the metadata are managed through a repository web service Owner groups Agencies are defined with authorized users according to windows identity A group can only manage metadata of its agency System administrators can manage everything FMR Val de Travers Page 7 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 2 4 Multiple independent repositories In this mode the metadata are managed through a set of repositories web service Each repository contains a coherent set of metadata all references located in same repository They can be managed with or without ownership support The selection of working registry is done manually in the editor by the users B2B 2 5 Multiplexed Repositories B2B a en 9 sm consume REST Common Facade Pattern The set of repositories constitutes a single pool of coherent metadata References can cross repository border Agency groups are assigned to one of the registry Ownership management is required combined with group to registries assignation FMR Val de Travers Page 8 75 www sdmx ch wr gt SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 SAE GUI 3 1 Areas The application screen is divided in the following areas The functionality of each area is described in the next paragraph Menu Bar Main Toolbar Quick Search in tree Detail Vi
45. SOM standards besides defining standard formats for data and metadata also define an architecture for data exchange SOM provides guidelines and tools to support the pull mode of data sharing where the collecting organisation CONCEPT retneves the data from the providers web servers The data may be made available for download in a SOMX conformant file or they may be retrieved from a database in response to an SOMX canfomant query In both cases the data are made available to any organisation requiring them in formats which ensure that the data are consistently described by a LAA appropriate metadata whose meaning is common to all 49 Artefacts parties in the exchange This architecture often includes also fia Metadata Set Child Count Export DSD information as PDF document It includes associated code lists And concepts information Extract of PDF export ie two sub areas_ Identification ESTAT CL GECH1 1 IT Italy IE Ireland FT Frnrenal FMR Val de Travers Page 43 75 www sdmx ch wer SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 4 2 Dimensions ee OrganisationSchemes wf Dataflows 77 Metadataflows J CategorySchemes 4 CodeLists 7 HierarchicalCodelists amp ConceptSchemes 7 Metadata Structure Definiti CJ Data Structure Definition CENSUSHUB Cens E Dimensions Measures Lo Attributes
46. STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 4 Creates a new attribute after the selected item in the attributes hierarchy tree Creates a new attribute as child of the selected item in the attributes hierarchy tree Deletes selected attribute and all its children A confirmation dialog box is used H FREQ_DISS Navigation toolbar functions operate on attribute tree 7 8 Metadata set The Application reads and allows creation of metadata set information For creating metadata set rows the referred metadata structure and report need to be loaded in memory The metadataset document should be of type generic metadataset 7 8 1 Artefact detail SL SAE SdmxML Editor with Tiny registry support V 0 9 5 Export Categories Utilities Options Help E Q MDS QHH RSILCC SDMX Target SDMX20 Set ID AgencylD MDS_Q_HH SAE H Concepts CS_CATI MG CATI Meta Quest H Concepts J Metadata Structure Definitions MD_SILC_CATI Metadata structure for SILC H E Tangetidentifiers FT_QUEST_VAR H I Reports Name SILC HOUSEHOLD Validity Publication Reporting Valid From Valid To x Year Period Begin Date E E Le Plug in Cy General Metadata Reference Reporting Taxonomies Scheme Reference Agency Version and Name a MD_SILC_CATI OFS_SI_CODAM_SMS 1 0 Metadata structure for SILC CATI wad T atase SEET Metadata Set Report Id Name Ee MDS_Q_H
47. TURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 5 Category scheme 7 5 1 Artefact detail 7 5 2 Category detail 7 5 3 Category hierarchy management 7 6 Hierarchical Code List 7 6 1 Artefact detail 7 6 2 Code lists reference 7 6 3 Information Tab details 7 6 4 Hierarchy Tab details 7 6 5 Level Tab details 7 7 MSD 7 7 1 Artefact detail 7 7 2 Target Identifiers 7 7 3 Report 7 8 Metadata set 7 8 1 Artefact detail 7 8 2 Artefact row detail 7 8 3 Row Attributes values 7 8 4 report of metadata embedding HTML 7 8 5 Sample report of metadata set row 7 9 Data flow and Metadata flow 7 9 1 Artefact detail 7 9 2 Reference 7 10 Reporting Taxonomy 7 10 1 Artefact detail 7 11 Processes 7 11 1 Artefact detail 7 11 2 Process Step detail 7 11 3 Process Step Transitions 7 11 4 Functionalities 7 12 Structure Sets 7 12 1 Artefact detail 1 12 2 Maps detail 8 EXCEL 8 1 Excel Import dialog 8 2 Loading an Excel Worksheet 8 3 Mapping property editor 8 3 1 Internationalized text mapping 8 3 2 Hierarchy mapping 8 3 3 Header rows 8 3 4 Artefact main attributes 8 4 Artefact creation 8 4 1 Function create 8 4 2 Function update text 8 4 3 Samples 8 5 Excel Export FMR Val de Travers Page 4 75 www sdmx ch 47 47 47 48 49 49 50 50 50 52 54 54 54 56 57 57 58 59 60 61 62 62 62 63 63 64 64 64 65 65 66 66 66 68 68 69 70 70 70 71 71 71 71 72 72 72 wr
48. Type of adjustment used represented by a code Core Representation Codlist Id Version and Name Agency Text Format Undefined URN um sdmcc org sdmx infomodel conceptscheme Concept SDMX CROSS_DOMAIN_CONCEPTS 1 0 ADJUST_CODED H E COVERAGE Coverage CURRENCY Currency E COLL_METHOD Data Collection Method DATA_COMP Data Compilation DISS_ORG Data Dissemination Agency DATA_EDITING Data Editing H E DATA_PRES Data Presentation 7 Tile Ted Um E DATA_PROVIDER Data Provider DATA_REV Data Revision DSI Data Set Identifier mr ls Etemal D Ref In data messages adjustments are identified by a code related to the type of adjustment used e g trading day adjustment working day adjustment seasonal adjustment or trend cycle adjustment CONTEXT amp Artefacts Registry http localhost 59699 TinyRegistry Repository asmx State Ok The detail screen manages the standard artefact attributes Text and Description support multi language edition A text format can be specified See Text format paragraph for detail A code list present in memory can be selected as core representation The ESC key in combo box allows erasing any reference Paste Code list urn The core representation is given by pasting a previously copied codelist urn Navigation button Navigate to in memory referred code list or loads it from repository if not yet present Concept h
49. a a Concept Reference Scheme Reference Agency Version and Name CENSUSHUB_ CONCE ESTAT 1 2 CensusHub domain concept scheme The measure presents the primary measure in the grid as well as the cross sectional measures if any Cross sectional measures og Properties General D cone a am oeo om e a O ee x1399 tee ee amp 1 CodeLists HierarchicalCodelists ce amp 1 ConceptSchemes Metadata Structure Definitions d C1 Data Structure Definition B S EX_DSD Example DSD Concept Reference Scheme Reference Agency VARSCHEME vy OFS The set of cross sectional measures is no more created in one shot according to codelist s defined in measure dimension s it is now managed independently Distinguish direct references and references given through concept lf a reference to codelist or a text format is not defined in DSD the corresponding information if any given in concept are used instead In order to highlight this the grid display differs Slightly for each case Indirect references are preceded by a marker indicating coming from concept Name Codelist Text Type FMR Val de Travers Page 45 75 www sdmx ch ar SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 4 4 Attributes Attributes X 5 5 J Time format code CL_TIME_ FORMAT Mandatory g Observation value CL_OBS_STATUS Conditional 5 5
50. an be pasted in concept or DSD edition for code list or concept reference it can also be copied as text or as annotation urn Sample of urn urn sdmx org sdmx infomodel codelist Code ESTAT CL_GEO 1 1 1T DSD Wizard This function allows quick creation of a DSD skeleton It creates also associated codelist for Cross sectional measures See 5 2 3 3 2 9 Help Menu User Manual This command provides access to this document Documentation SMS Provides an access to NSI documents located in the SMS sub directory of the editor Documentation SDMX Provides an access to SDMX documents located in the SDMX sub directory of the editor Send feed back lt raises your mail system to send a feedback or question about this tool About It raises the About dialog box 3 3 Toolbar 3 3 1 File Menu shortcuts Append SDMX File Write All artefacts loaded in tree view as a unique SDMX Document Save selected Artefact as a SDMX Document 3 3 2 Repository shortcuts Load dialog for selecting artefact from repository Reserve lock selected artefact in repository Be Submit selected artefact to repository 3 3 3 Active language fr The combo box allows selecting the language to use for displaying internationalized information A dynamic refresh is executed on displayed texts FMR Val de Travers Page 12 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 3 4 Expands Collapses
51. as to be an SDMX ML XML Document Plug in are loaded under the associated tab in the detail view Each instantiated plug in matches a tab page in the plug in view E GEWO ATTRIB T a Z o plug in x plug in 2 4 Ei Concepts 5 see E VARNAME amid a EJ OTYPE fe WORDER 9 1 Plug in installation The installation instructions are given in a sdmx codelist document this document is named CL_SAE_PLUGIN xmlf and must be placed under the sub directory Plugin of the editor Each plug in to install is described as one code of the code list For each code two annotations are mandatory and one is optional The code id is used for form tab naming Name and description are used to document the plug in 9 1 1 Required annotations Ann Type Ann Title Description Holds the name of the DLL that is to be loaded by editor This library must be located in subdirectory Plugin or the annotation Plugindll dll DLL_DIR has to be provided for specifying the dil directory Holds the name of the class to be instantiated Namespace classname This class derives from UserControl class and implements the Plugin interface DLL DIR FullDirectory Optional Indicates the directory to use for locating the DL if not provided in sub directory Plugin FMR Val de Travers Page 73 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT File Import Export Categori
52. at is key to making sound decisions about national policy z 1 CategorySchemes see http en wikipedia o wiki Demogra hic statistics l SEON 5 CAT_STAT_ACTIVITIES Multi Annual Programn useful summary of such data is the population pyramid It provides data about the sex and age distribution of the me a ais population in an accessible graphical format B taj 1 Demographic and social statistics 1 on E taj 1 01 Population B A 1 01 DEMS Demographic statist URI Di 1 01 DEMS 2009 Year 2009 F K ee 1 01 DEMS 2010 Year 201 i a 1 04 Health MetaData Flow Data Flow 1 06 Economic and social situation c AgencylD i ID AgencyiD Ve E oa rage mue IN DF_DEMOGRAP NSI POP DEM 1 f ay 2 Economic statistics E 2 02 Economic accounts E 2 04 Sectoral statistics EJ 2 04 02 Energy FE 2 04 03 Construction and housir Lf 2 04 05 Tourism E 2 07 Prices ET af 2 14 Industry and services Sy 1 CodeLists 4 6 CL_FREQ Codelist frequency 12 2 H 6 CL_COUNTRY Codelist country H 6 CL_SEX Sex codelist fF Cl DEMO ende liet demanranhy tu _ i m ata aks HZ Artefacts DataSets Direct access to referred MSD via flow Direct access to referred DSD via Direct access to any flow Artefact in Repository Via annotation urn member that holds an artifact reference and concepts schemes And from there
53. chicalCodelists CL_SEX 1 0 Sex codelist ESTAT HCL_ SAMPLE Sample Hierarchi CL_DEMO 1 0 code list demography ESTAT 3 Codelist Ref CL_OBS_STATUS 1 0 Codelist Observation status ESTAT cos HIERARCHY CASE CL_DECI 1 0 Codelist Decimals ESTAT HIERARCHY _CASE2 CL_TIME_FORMAT 1 0 Time Format ESTAT Ca 7 ps CL_UNIT 1 0 Codelist Unit ESTAT 5 nceptochemes CL_UNIT_MULT 1 0 Codelist Unit multiplier ESTAT C3 Metadata Structure Definitions CL AREAS 1 0 Areas code list ECB EC Data Sirte Defeatinn CL_COUNTRIES 1 0 Countries code list ECB References can be selected from the set of in memory code list artefacts Navigation to referred code list can be done with navigation button Hierarchy details are presented in a tabbed detail view composed of three panels 7 6 3 Information Tab details The first panel regroups hierarchy information attributes more or less similar to artefact attributes detail view Name and Description support multi language edition 7 6 4 Hierarchy Tab details This panel displays a tree representation of the defined hierarchy On the left side of the hierarchy tree a set of controls allows to edit the selected item in the hierarchy tree FMR Val de Travers Page 50 75 www sdmx ch 4 d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT ld p E O Name DS i HIERARCHY_CASE2 Al i 2 OrganisationSchemes D2 EU 15 fixed
54. composition Gr Information Hierarchy Levels ORG_ESTAT Organisations GR Greece Id REX H Agencies IE Ireland O Name z H DataProviders FR France C DataConsumers FI Finland Code ief Diaiaticws ES Span n Codelist Ref Alias Code Id C Metadataflows DK Denmark CL_COUNTRIES ECE LU C1 CategorySchemes DE Germany Level Ref Node Alias Id 2 CodeLists BE Belgium CL_COUNTRIES Countries code list AT Austria Codes SE Sweden Version Valid From Valid To CL_AREAS Areas code list PT Portugal UE ee 4 CL_SEX Sex of the person defined ac NL Netherlands i a 1 HierarchicalCodelists Luxembourg HCL_SAMPLE Sample Hierarchical C IT Italy Codelist Ref GB United Kingdom amp HIERARCHY_CASE1 D3 EU 25 fixed composition HIERARCHY_CASE2 LT Lithuania ConceptS chemes LU Luxembourg If the referred code lists are not loaded in memory the hierarchy tree will only displays code list reference and code value Id r O Name D3 2 Tes Information Hierarchy Levels _ amp HIERARCHY_CASE2 A OrganisationS chemes CL_AREAS ECB 10 D2 id ORG_ESTAT Organisations CL_COUNTRIES ECB 10 GR IS 1 Agencies CL_COUNTRIES ECB 10 IE O Name ____ 1 DataProviders CL_ COUNTRIES ECE 10 FR DataConsumets CL COUNTRIES ECB 10 Fl CodeRet Da
55. d To CL_UNIT_MULT ESTAT 10 2007 01 01 2007 12 31 ID AgencylD Version Valid From Valid To CL_UNIT_MULT ESTAT 10 2007 01 01 2007 12 31 a Properties General Name E Is Final Name F ls Final Wetebereich Maleinheitsvervielfacher v Wetebereich MaBeinheitsvervielfacher Bi Description en Fodelist Unit multiplier de Wetebereich Ma einheitsverviefacher es ssts sS ft Domaine de valeurs Multiplicateurdunit ss s it Settore di valori Moltiplicatore dell unit ssts lt s Ls e Ce Lj Properties General Functionalities amp Bal A Cut Copy Paste operations on Internationalized text The operation is on the whole set of languages This function duplicates text currently written only for one language in the others text boxes So the same text is assigned to all languages Holds Control Key to force overwriting FMR Val de Travers Page 18 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Convention When all texts are same the SDMX xml lang attribute is not reflected when saving the artefact document And during a read operation a text without xml lang attribute will be reflected in all language set This is the default mode of operation of the editor It can be changed if in the configuration file of the editor the tag lt add key TextLang value is defined The p
56. de Chile Ministerio de Hacienda Chile FMR Val de Travers Page 58 75 www sdmx ch wr x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 8 3 Row Attributes values The second tab presents a tree view with the defined concepts associated to attributes values According to selected tree item concept name description and eventual context annotation are displayed as information A tool bar is available to operate on attributes Remove all non filled non mandatory attributes of the row A confirmation dialog box is used Append all missing concepts of the metadata row according to report information H FREQ_DISS z Navigation toolbar functions operate on attribute tree Generate a sample Word report This illustrates the possibility to use transformation like XSLT to generate HTML documents from metadata set If the checkbox Includes concepts info is checked concept context info are added Target Attributes Values r oH FULL_ESMS X FOO roos E Elm CONTACT es i CONTACT ORGANISATII Includes Concept context in report CONTACT_UNIT Attribute value CONTACT_NAME CONTACT JOB TITLE CONTACT_MAIL_ADDRE CONTACT_EMAIL CONTACT_PHONE oS D g a a Annual Daily business week Daily 6666666 CONTACT_FAX J Hg META_UPDATE 1 H DATA PRES og UNIT_MEASURE _ be REF PER cf be
57. e associated text box and the search function is activated by pressing Return or with the search button action The star character can precede and or follow the text to indicate wildcards FMR Val de Travers Page 14 75 www sdmx ch wer 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 4 2 Popup Menu A1 CodeLists CL_DECIMALS Code list for Decimals DECIMAL CL_FREQ Code list for Frequency FREQ OUMNH Lo Lic numere values such cases but missing values ir a Codes E A Annual The tree popup menu operates E eE ea on selected tree tem Menu D Day S New Child Ins choices are activated according bee Copy Item Ctrl C to the type of the selected item if N Minutel Q Quarter M Paste term Ctrl eE S Half Ye x Remove Selected Item Suppr i E W Wedi The popup is activated by r B CEL STAT Redefines Parent Ctrl P clicking the right button of the el 5 Codes a HierarchicaCodelits Save as SDMA Document Ctri 5 a Concept Schemes i New Artefact version Ctrl N T7 Metadata Structure Definitions a Data Structure Definition Creates a new Artefact item in selected artefact collection New Child or creates a new specialized item inside the selected artefact Copy Item Copy in memory the content of the selected item code concept category or process step Paste item The previously copied item is inserted after the selected item in
58. elists f Concept Schemes S f Metadata Structure Definitions C Data Structure Definition wf Structure Sets 2 mm Artefacts DataSets FMR Val de Travers Page 47 75 www sdmx ch wr gt SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT The detail screen manages the standard artefact attributes Text and Description support multi language edition Flow Attachment Data flows and metadata flows can be attached with the flow grid buttons MetaData Flow Data Flow ID AgencylD Version ID AgencylD vires 7 a Edit Artefact Reference mes 4 Reference ld Version and Name Annotations ID MD INITIA 1 0 initial refrerence metada Tye 1ID_MD_INITIAL 1 0 Initial refrerence metadata OFS yP SE MD INITIAL 1 0 Initial refrerence metadata OFS Module Edit selected reference in flow grid See reference editor dialog box Creates a new flow reference as a new grid row Deletes selected reference row in grid Navigate to artefact according to reference given in flow grid row Artefact must be loaded in memory 7 5 3 Category hierarchy management e The hierarchy of category is managed with the tree popup menu Category can be added as child of selected item and can be removed with all associated children e Parent hierarchy can also be redefined with popup menu functionality As the hierarchy allows same id to occur in different levels it
59. es General ms GR Greece vation z IE Ireland a a m Ka ER Crance a CodeRef PET Add Code Reference s _ tm Codelist Ref Alias Code CL AREAS ECB E10 Level Ref Node Alias Id Code value to add Version Valid From Valid To 1 0 Available codes 1A Intemational organisations Code Annotations 1B UN organisations E 1C Intemational Monetary Fund E Type Title 1N Wadd Trade Nrnanieatinn Specialized function that can be used if the hierarchy is managed as historical by using a history code in code list codes and by using valid from and valid to attributes in the code reference This function creates a SDMX artefact that is a snapshot of the codes hierarchy that are valid at the specified time zo ib ULOS 10181 10183 fl 10185 El 10186 12580 Ge 10191 Dista Fl 76 Gen ve rer Level Tab details D2 EU 15 fixed composition XE 000 LISUICI GE INEUCTNISIEN District de Boudry District du Locle District du Val de Ruz District du Val de Trave 10883 Travers 11487 Buttes i 11849 Boveresse 11943 Fleurier 12375 M tiers NE 12572 Noiraigue Generate SDMX Snapshot from Historical Hierarchy CodeRef Codelist Ref Alias GDE Level Ref Version Snapshot Code Id Node Alias Id Valid From 1 0 1960 01 01 4 avril 2010 b lun mar mer jeu ven sam dim 29 30 31 1 3 4
60. es Utilities Options Help Code Value PLUG_DEMO Name Demo of loading FSO Nomenclatures through plugin Dezcriniion The Swiss Federal Statistical Office FSO endorses the SDMX initiative by disseminating its statistical nomenclature cet an MI files These files may be freely downloaded atas Type Title T FA MetadataSet The DLL that is to be loaded by editor Must be Flugin Dema dll located in subdirectory Plugin or the annotation DLL_DIR must be provided The class to be instanciated This class derives PluginDemo Uec_SFS from UserControl class and inplements the Plugin The above screen presents a plug in instructions sample 9 2 Plug in demo A demonstration plug in is delivered with the editor It illustrates the event mechanism used to transmit SDMX ML documents to the main application The corresponding source code is located under PluginDemoSource sub directory Import Export Categories Utilities Options Help SDMX Target SDMX2 0 Demo FSO Nomenclatures in SDMX ML Format The Swiss Federal Statistical Office FSO endorses the SDMX initiative by disseminating its statistical nomenclature system in SDMX ML files These files may be freely downloaded below Note The plugin demo provides only a few of them Select nomenclature and press load button or double click The main tree will reflect the loaded nomenclature Q Plug in C General ISCO 88 COM Intemati
61. ew of selected element in tree view Alternate view is plug in view Artefacts Tree view pig Popup menu Annotations View Status Bar FMR Val de Travers Page 9 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 2 Menu 3 2 1 File Menu Open New Opens an SDMX structure or meta dataset document and clears previous memory content The user is prompted to select the document that should be loaded Append SDMX File Opens an SDMX structure or meta dataset document and appends it to the artefacts already in memory If the document contains artefacts that according to their identification are already in memory these artefacts are ignored The user is prompted to select the document that should be loaded Save All lt saves all SDMX structure artefacts currently in memory in a unique SDMX document For its activation uses tree popup or menu Save selected Artefact in order to save a specific artefact or a typed collection of artefacts Note Dataset and generic MetadataSet in memory are not affected by this saving They can also be saved through tree popup menu functionality Save selected Artefact Writes the artefact selected in tree as SDMX ML document If an artefact collection is currently selected in tree it saves the complete collection Clear All This command removes all artefacts currently in the project memory 3 2 2 Repository Menu All commands
62. fferent SDMX files documents or by creating them from scratch It can then submit or retrieve artefacts through the repository When an artefact is fetched from the repository the direct dependencies are also fetched For example Code Lists and Concepts Schemes referred by the requested DSD The user navigates between the artefacts of the project by using defined references or by manual selection The application allows creating complex SDMX documents files with different kinds of artefacts On the other side the repository holds single artefact documents A plug in mechanism is offered in order to add NSI specific functionalities inside the editor A Restful service wrapper allows easy consultation of repository content for others NSI tools FMR Val de Travers Page 6 75 www sdmx ch ee v SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 2 Operating modes 2 1 Standalone mode In this mode the metadata are managed only through XML files based on SDMX ML model 2 2 Repository basic mode B2B KO consumer gay Facade Pattern REST ee ee je Sia In this mode the metadata are managed through a repository web service The basic mode allows every one to manage every metadata of the repository 2 3 Repository with ownership management B2B x amp consumer CO O sen Fa ade Pattern REST igh Agency NSL GRP1 aos Agency NSI_GRP2 Administrators O
63. finition in the form of a delegate plus an event handle When the event happens the generator will call the unknown event handling method of the consumer through the event handle public class PluginEventArgs EventArgs public XmlDocument DocSdmxMl get set public PluginEventArgs XmlDocument xDoc DocSdmxMl xDoc lt summary gt Publishes the method definition in the form of a delegate lt summary gt lt param name sender gt lt param gt lt param name e gt PluginEventArgs instance lt param gt public delegate void PluginEvent object sender PluginEventArgs e FMR Val de Travers Page 75 75 www sdmx ch
64. ical size of the grid can be redefined by the horizontal split bar located below the grid area Navigation to referenced elements is possible if these artefacts are in memory Only one time dimension can be created When none are defined an additional button is displayed in grid area Grid functions Unused selected row can automatically be edited in middle panel Creates the time dimension It is visible only if no time dimension defined Creates a new dimension Deletes selected dimension Middle Panel References to concept and to code list can be done with artefacts loaded in memory Others combo boxes allow to characterize the dimension Sample of reference edition FMR Val de Travers Page 44 75 www sdmx ch y SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Codelist reference Codlist Id Agency Version and Name ml ESTAT 1 0 Age code list ER 1 0 Age code list 5 CL_CAS 1 0 Current activity status code list 1 1 Geographical code list 1 0 Sex code list 1 0 Time Format 1 0 Observation status code list CL_SEX CLTIME_FORMAT CL_OBS_STATUS 7 4 38 Measures Only Primary measure OBS VALUE Observation value O Metadataflows of CategorySchemes amp H CodeLists 7 HierarchicalCodelists amp _ ConceptSchemes 7 Metadata Structure Definiti a 9 Data Structure Definition CENSUSHUB Cens ked Cc 7 S
65. ierarchy management e The hierarchy of concepts is managed with the tree popup menu Concept can be added as child of selected item and concept can be removed with all associated children e Parent hierarchy can also be redefined with popup menu functionality See Code detail paragraph for explanation about hierarchy redefinition dialog box e Concepts can be reordered in current level with drag and drop operation in tree e Finally concepts and scheme can be constructed with the Excel import functionality FMR Val de Travers Page 42 75 www sdmx ch ve SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 4 DSD 7 4 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition Utilities Options Help Attributes ID AgencylD Version Valid From Valid To CENSUSHUB ESTAT 12 E Name CensusHub Data Structure Definition H CodeLists HierarchicalCodekste ls Final E Is Etemal Ref Is Partial Metadata Structure Definitions ae E Data Structure Definition Characteristics of the hypercube for the Census European Hub pilot B E CENSUSHUB CensusHub Data Structure HE Dimensions 3 Measures URI Link to resource with additional information E Attributes Text The Census European Hub is the proposal of a conceptually new system to achieve the dissemination of the 2011 Census data via the Eurostat website The
66. isation Schemes C7 Dataflows H Metadataflows f CategorySchemes a C7 CodeLists Description Lil HererchicalCodelats Tp P e Concept Schemes Metadata Structure Definitions URN B S MSD_ACTIVITY Reference metadata on activi Targetldentifiers MJP_FTI 6 REP_ACTIVITY Report on reference metac ra Data Structure Definition 7 Structure Sets Name Is Final Group Trial Properties General ls Etemal E Ref 5 1 Reporting Taxonomies i _AgencylD _ Ve 9 Undefined Text n def 1 Processes GH Data Set st Metadata Set II Artefacts DataSets Child Count 1 Please refer to Category schemes documentation for the categories management in this artefact FMR Val de Travers Page 63 75 www sdmx ch er SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 11 Processes 7 11 1 Artefact detail The detail screen manages the standard artefact attributes Name and Description support multi language edition ld Name ID AgencylD Version Valid From Valid To 6 P_TEST OFS 11 2010 01 01 gt ae S Name E Is Final f C HierarchicalCodelists Test v ConceptSchemes a G J Metadata Structure Definitions Description B S MSD_ACTIVITY Reference metadat Test description E E Targetidentifiers MJP_FTI pr iE REP_ACTIVITY Report on refere fon ga Data Structure Definition URN
67. lso the current connection to TinyRegistry with its state FMR Val de Travers Page 16 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 7 Detail view The detail view reflects the currently selected item in the tree According to the complexity of the content it can be a tabbed view or a simple view 3 7 1 Read Only If the artefact is signalled with the Is Final attribute the edit operations are not allowed It is possible to uncheck the attribute in order to edit attributes This is on the responsibility of the user When setting the IsFinal attribute the application performs an XML validation according to SDMX Structure schema Detected errors are reported an a dialog box Note to fully uses navigation possibilities the SDMX 2 0 schemas must be slightly modified to add some missing information like for example referred concept scheme version in DSD references 5 TUR Tourisme E OTH Autres CodeLists XSD Validation Error gt 5 CL_MARITALSTATUS Caution Artefact validation with XML schema detected some errors A1 Codes 1 1 C libataire L attribut value n est pas valide La valeur 1 1 n est pas valide selon 2 Mari e son type de donn es 0 3 Vef veuve http www SDMX org resources SDMXML schemas v2_0 common ID HE 4 Divorc e Type Echec de la contrainte Pattern 5 5 Non mar e 7 HierarchicalCodelists C
68. n All elements are separated by semi column Sample lt add key TinyRegistryUrl value Demo http localhost 59699 TinyRegistry Repository asmx gt lt Presented as usage http usage http gt lt add key TinyRegistryAlternateUrl1 value Metastat http meta admin ch TinyRegistry Repository asmx Harmonisa tion http edix in ch Harmo Repository asmx gt Note For a multiplexor mode distributing registries and owners between servers please contact us for more detail on installation processes 5 2 2 Menu Repository Get Artefact Through this menu a Repository browser dialog box is open It allows browsing the different artefacts available A basic filter mechanism is provided for the full id and name column As the dialog box is non modal it is also possible to operate on the main application screen at the same time for example to consult detail of imported artefact gig Get Artefact from SMS SILC P Repository Source Filter Artefact Type CodeLists Availability 338 Artefact backup count 2 ld Version Agency ValidFrom ValidTo Name ls Final Diffusion Lastm CL_CATI QUEST PLO30A 1 0 OFS_BS_EKL_SILC Main activity 2011 0 2011 0 2011 0 2011 0 2011 0 S CL_CATI_QUEST_PO06 1 0 OFS_BS_EKL_SILC 2007 01 01 2007 12 31 Who was the main breadwinner CL_CATI_QUEST_PO06 1 1 OFS_BS_EKL_SILC 2008 01 01 Who was the main breadwinner CL_CATI_QUEST_PO16_P 1 0 OFS_BS_EKL_SILC
69. ng manufacturing Fer 2 4 4 Transport Fey 2 4 5 Tourism Fe 2 4 6 Banking insurance fin ven et 2 5 Govemment finance fiscal a Ee 2 6 Intemational trade and balan Fey 2 7 Prices Fer 2 8 Labor cost Ee 2 9 Science technology and inn _ fer 3 Environment and multi domain stati fey 3 1 Environment Fey 3 2 Regional and small area stati fes 3 3 Multi domain statistics and in fey 3 3 1 Living conditions pove Fer 3 3 2 Gender and special po Fer 3 3 3 Information society Fer 3 3 4 Globalisation Fer 3 3 5 Indicators related to the Fer 3 3 6 Sustainable developme ole 3 3 7 Entrepreneurship Fey 3 4 Yearbooks and similar compe URI MetaData Flow Data Flow Agriculture forestry fisheries includes all agriculture forestry and fishery related statistics e g agricultural monetary statistics agricultural economic accounts agricultural structures farm structure trade in agricultural products agricultural labour input crop and animal production agricultural commodities agroindustry statistics including food production and safety organic farming and organic food govemment expenditure for agriculture fishing and forestry products source and use tables forest and forest product statistics forest resource assessment and forest fire trade in forest products fisheries Excludes agricultural and similar prices 2 7 rural development 3 2 wf J HierarchicalCod
70. nized Index of Consumer Pri ffl 05 08 HVPI Harmonized Index of Cor Tr oft 05 61 a Plug in E General B ESMS_MSD Euro SDMX Metadata Structure Definiti H Metadata Targets FMR Val de Travers 5 4 FULL_ESMS eeeeeeeeee CONTACT META_UPDATE STAT_PRES UNIT_MEASURE REF_PERIOD INST_MANDATE CONF REL_POLICY FREQ_DISS J DISS_FORMAT e ONLINE_DB a DISS_OTHER ACCESS_DOC QUALITY_MGMNT RELEVANCE ACCURACY TIMELINESS_PUNCT COMPARABILITY COHERENCE COST_BURDEN DATA_REV STAT_PROCESS COMMENT_DSET The HICP is published on the website of the Federal Statistical Office English site www_hicp_bfs admin ch German site www _hvpi bfs admin ch French sitewww ipch bfs admin ch The global result for the Swiss HICP is published in the press release concerning the CPI which is issued at the beginning of the month following the reference month More detailed results Refered Concept Name Context Information References to the most important data dissemination done through paper or ondine publications including a summary identification and information on availability of the Page 60 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 8 5 Sample report of metadata set row The image below illustrates a part of a sample report Ge yg CONF POLICY CONF DATA TR El REL_POL sg REL_CAL_POLICY a REL_CA
71. ogramme 1 CategorySchemes 5 Description _ Categorisations oil CodeLists Pe 8 6 CL_CAT_ENTRIES Editor Categories mel G9 Codes URN D RTE ES COUT CAT_PRODIMA Statistical produi E CAT_META_REF Metadata soun iE CAT_NOMEN Cross Domains Cle 2 HierarchicalCodelists L ConceptSchemes T Metadata Structure Definitions fea Mats Urha Moderne FMR Val de Travers Page 30 75 www sdmx ch wer 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 6 4 Menu Data 6 4 1 SQL Experimental 6 4 2 CSV This function raises a non modal dialog for binding CSV data to corresponding metadata ER CSV Data Viewer amp checket File Metadata Check Options Check Limits C Legends Limit on same column 20 i i mm Keys Time mion wete 100 ve Mn Detected Model Rows Attributes Chunked file Q Not in DSD Vanable Diagnostic Information a menu Lai Raise a dialog box to select CSV file to load on CSV grid Note csv reader is configurable see option menu Metadata Bind Bind CSV columns to corresponding DSD selected in main tree The column order is meaningless The binding is done according to CSV header matching concept ID Check Full Once correctly bind to metadata it is possible to check columns content according to codelist items hae ES chunk For huge files it checks only the chunk part of PUR le file tha
72. onal Standard Classification of Occupations ISCO 08 COM Intemational Standard Classification of Occupations SBN 1990 Schweizer Berufsnomenklatur Swiss Standard Classification of Occupations SBN 2000 Schweizer Berufsnomenklatur Swiss Standard Classification of Occupations Sprachen 2000 Languages 2000 Nomenklatur nach Sprachfamilien geordnet Sprachen 2010 Languages 2010 Nomenklatur nach Sprachfamilien geordnet Rechtsformen Legal forms V 2 0 Amtliches Gemeindeverzeichnis der Schweiz List of Swiss Communes Stand vom 21 11 2010 Sektorengliederung 1995 Classification of institutional sectors 1995 Kassifikation der Aktiva und Passiva 1995 Classification of assets 1995 Transaktionen und sonstige Str me 1995 Classification of transactions and other flows 1995 Allgemeine Systematik der Wirtschaftszweige 1995 General Classification of Economic Activities 1995 a smi manoir rm oem nr an s an ARARA m sP lt rane mi _ Registry http localhost 50095 TinyRegistry Repository asmx State Ok FMR Val de Travers Page 74 75 www sdmx ch ve SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 9 3 Interface definition namespace PluginInterface lt summary gt Contract for the implementation of a minimal set of methods by the plugins These methods are used by the main incorporating application to find and
73. osed of two panels Report Tab The first panel regroups report information attributes more or less similar to artefact attributes detail view Name and Description support multi language edition The target reference combo box allows selecting between full identifier or one of the optional partial target identifiers Report Metadata Attributes Report Id PRIMARY_CONTACT_REPORT_COMPONENT CATEGORY Report for Pimary Contact Information AGENCY Phones eneendi ane Meta data attributes Tab This panel is used to define the hierarchy of metadata attributes based on concepts selected from relevant concept schemes Id a a 5 Report H ESMS_REPORT_FULL Euro lt EJ Ge X B STAT CONCDEF Organisation Schemes A CONTACT I Meta Attribut 2 Dataflows Gre META_UPOATE oy Text Format A Metadataflows Se STAT_PRES ccurences 9 CategorySchemes b DATA_DESCR Pattem 1 n Mandatory g bd C3 Categorisations g CLASS_SYSTEM ID Le Saf Min M 1 1 2 Codelists COVERAGE_SECTOR Ey E is Presentational STAT CONC DE Le PRES SEE a STAT_UNIT Concept Reference amp SDMX_CDC SDMX Cross Domain Concept Scheme STAT_POP Scheme Reference Agency Version and Name B S ESTAT_ADD_CONCEPTS Eurostat additional cor cob SDMX_CDC ESTAT 2 2 SDMX Cross 6 Metadata Structure Definitions
74. ossible values are Signification Strict interprets texts without specified language as english serialize according to defined languages Text without a specified language are duplicated in all supported languages If text is same for all languages it is written without language specification Acts as if Expand Compress are selected FMR Val de Travers Page 19 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 5 Menu Repository 5 1 Introduction The SAE Editor can work with the TinyRegistry repository service This allows to navigate easily between artefacts and to manage them in a centralized manner The repository is a NET 2 0 web service application to deploy under IIS 5 1 or higher To uses the repository the SAE configuration file must contains the valid URL of the repository service page lt add key TinyRegistryUrl value gt If no URL value is specified the repository usage is ignored The repository manages structure artefacts by artefact type It supports internationalization and must be configured according to SAE editor internationalisation subset support Set of languages is specified when the repository is empty and cannot be changed once it is used A possibility exists for managing aggregated artefacts in a document The Full iD is the one of the artefact selected when submitting the whole project For more details about the services please consult JinyRegis
75. pdate text za This function checks that the same artefact is present in main tree memory and it Ted updates items texts and annotations content only 8 4 3 Samples This sample file shows how to import a simple code list that is internationalized The associated mapping file maps German French and Italian Note that Artefact ID and Agency must be written manually 05 Nomen Langue xls map05NomenLangue map Eurostat_CODELIST Sample xls maplsco88 map This sample file shows how to import a hierarchy s artefact using levels The Isco88 is located on the second worksheet of the excel document Note that Artefact Agency must be written manually 8 5 Excel Export Selected artefact can be exported as an Excel XML document The first worksheet contains the information about the artefact The next worksheet s contain the detail of artefact content included annotations Note to be able to use the document for an import after some corrections it must be saved as an excel document type Excel 2003 workbook FMR Val de Travers Page 72 75 www sdmx ch wer SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 9 Plug in The application supports the addition of plug in These components should be written in MS NET and implements the Plugin interface provided by SAE The class to instantiate must derive from a window form user control The plug in can exchange information to main program The information h
76. ptie se Fer 1 6 Social protection Fe 1 7 Human settlements andi en rer 1 8 Justice and crime Type Text Owner a l Biema T Lei 1 3 Culture H Social protection deals with s 1 6 Social prote Ref Heger 1 10 Political and other con Fer 1 11 Time use COVERAGE Sectoral statistics statistical a 2 4 Sectoral stat fer 2 Economic statistics COVERAGE Science technology and inno 2 9 Science te Her 3 Environment and multi domain B Cik COVERAGE Sustainable development wor 3 3 6 Sustainabl 4 0 CodeLists CONTEXT Sampling errors are distinct fro SAMPLING_ER H CL_CURRENCY code list for Currency Standard national accounts wa VALUATION Wa GE CL_AREA Code list for providing values 7 B CL DECIMALS Code list for Decimals DA H E CL_FREQ Code list for Frequency FRE i E CL_CONF_ STATUS code list for Confidentia CL OBS_STATUS Observation status ID Type Title Text Um aE CL_SEX Code list for Sex SEX Social protection deals with statistics on measures to protect o H 6 CL_TIME_FORMAT Code list for the Time Fe people against the risks of inadequate incomes associated with D CL UNIT MULT code list forthe Unit Multipl unemployment ill health invalidity old age parental j a a unl responsibilities or inadequate income following the loss of a H Codes nee A spouse or parent etc includes statistics on pension beneficiaries
77. r Save El Codes S E 100 Transfer Types 2 6 Transfer Apply 7 Transfer with take over 1 8 Transfer with split off Expiration deletion Merger Codes can be reordered in current level with drag and drop operation in tree This is valid for the main tree view and for the redefine parent dialog box tree Breakdown 3 Split off 2 9 Hierarchical transfer 10 Code change 11 Name change i 2 3 Take over 4 5 FMR Val de Travers Page 40 75 www sdmx ch ar SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 7 3 Concept Scheme 7 3 1 Artefact detail The detail screen manages the standard artefact attributes Text and Description support multi language edition File ch no Export Categories Utilities Options Help D E E CS EU SILC MATD 20 SDMX Target SDMX 2 AgencylD Version Valid From amp Valid To CS EU SILC MATD 2009 NSI INCOME 1 0 El Name Material Deprivation LS Plug in Cy General a rs E Is Final E Is Extemal Ref E Is Partial 27 HierarchicalCodelists fi a Concept Schemes Description Concepts for SILC 2009 Module on Material Deprivation z http eurtex europa eu Lex Uri Serw LexUriServ do un 0J L 2008 112 0001 0017 EN PDF HOUSEHOLD Household E HOUSING_ITEMS Housing i FINANCIAL STRESS Financ http Sepp eurostat ec europa eu statistics_eplained index php Category
78. roviders web servers TI ensus Gaia via The data may be made available for download in a SDMX conformant file or they may be retneved from a database in response to an SDMX conformant query In both cases the data are made available to any organisation requinng them in formats which ensure that the data are consistently described by appropriate metadata whose meaning is common to all parties in the exchange This architecture often includes also an SDMX registry that implements the general idea of a metadata registry for use with the SDMX standards The size of the annotation area can be redefined by the horizontal split bar located above the annotation title ff Annotations 3 5 1 Functionalities 2a Cut Copy Paste operations on Annotation The operation is on the whole annotation including the internationalized text Edit selected Annotation in a specialized internationalised dialog box Creates a new annotation attached to selected item Deletes selected annotation fa Creates an annotation of type ARTEFACT URN using the last urn copied 3 6 Status bar The Status bar delivers information according to context 3 6 1 Tree Childs count Child Count 1 Total 290 Registry Akko MbFs01SapptiSilciRepositors asmx State Ok According to selected item the status bar displays the count of children items sub level and total of sub items 3 6 2 Registry connection status It displays a
79. rsion 5 2 4 Menu Repository Submit Artefact check in In order to submit an artefact to the repository it is required if the ownership management is activated in TinyRegistry configuration to be member of the same agency group that the artefact agency or to be an administrator The submitted artefact is the one currently selected in the main tree view If the artefact is not yet in the repository it is automatically submitted If the artefact already exists in repository it must have been previously reserved check out by the same user Once successfully submitted the reservation is cleared A dialog box is raised if the artefact is already present in registry Save Artefact options Save Cancel reservation Indo chek byt WIN PHILIPPE PC WIN PHILIPPE lf the artefact refers others artefacts they must already be in registry in order to store it FMR Val de Travers Page 23 75 www sdmx ch wr d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Some artefact references are not present in Registry For coherence they are required List BIS_CONCEPTS BIS 1 0 CL_FREQ BIS 1 0 CL_JD_TYPE BIS 1 0 CL_BIS_IF_REF_AREA BIS 1 0 CL_BIS_OBS_CONF BIS 1 0 CL_OBS_STATUS BIS 1 0 CL_TIME_FORMAT BIS 1 0 CL_COLLECTION BIS 1 0 CL_AVAILABILITY BIS 1 0 CL_DECIMALS BIS 1 0 CL_BIS_UNIT BIS 1 0 CL_UNIT_MULT BIS 1 0 Note It is possible to cancel a previous reservation a check out without
80. s the standard artefact attributes Name and Description support multi language edition Id 5 Name AgencylD Version Valid Fro Valid Ti Fa E C1 Organisation Schemes eee m r Ea id To H E ORG_EDI Federal Department of Home At a a Y t Position comespondances CodeLists E Is Final E ls Etemal Ref E Is Partial 7 HierarchicalCodelists been fy Concept Schemes Description be ig Metadata Structure Definitions Been Data Structure Definition 2 El SET_PR_2723 Comespondances Plausi a 1 Structure ets fi Maps URI Link to resource with additional information MCE SET PR 2763 Position comespondances F amen E Maps jn 0 Reporting Taxonomies EA DataSet st Metadata Set ID Type Title Text Um 7 12 2 Maps detail Currently only Map for code list correspondences is implemented The source and target code list are specified first Then the link between codes can be specified through a specialized dialog box a O ey ment a f Source Ref Id Agency Version and Name CL_PR_6502 CHi PREIS 1 0 Positionstypen Target Ref Id Agency Version and Name CL_PR_6502 CHI_PREIS 1 0 Positionstypen lausi p ances A graphical view presents the mapped items corresponding to the currently selected value in map grid FMR Val de Travers Page 66 75 www sdmx ch 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY
81. social statistics ES Dsc i s G e 2 Economic statistics Fey 2 1 Macroeconomic statistics This is the canonical representation of the SDMX Content Guidelines for Statistical Subject Matter Domains v Fe 2 2 Economic accounts Fef 2 3 Business statistics O e 2 4 Sectoral statistics Fer 2 4 1 Agriculture forestry fisl i aiy ies 2 4 2 Energy URN Hte 2 4 3 Mining manufacturing Fer 2 4 4 Transport Fer 2 4 5 Tourism URI Fey 2 4 6 Banking insurance fin Fer 2 Gavemment finance fieral a 7 ls Etemal E Ref 7 5 2 Category detail The Category hierarchy is a different hierarchy than code list or concepts It allows same id to occur in different levels of the hierarchy The idea is to compose identification by grouping all levels id In sample screen the id of third level is 1 but its representation is 2 4 1 The tree view reflects this convention Category ID Version Parent Category Parent Description 1 1 0 2 4 Sectoral statistics SDMXStatSubMatDomainsWD1 SDMX Stati 2 Categories fey 1 Demographic and social statistics G fer 2 Economic statistics fey 2 1 Macroeconomic statistics fes 2 2 Economic accounts Fes 2 3 Business statistics fey 2 4 Sectoral statistics Agriculture forestry fis Name Agriculture forestry fisheries v Description Properties General Let PSA wd Fef 2 4 3 Mini
82. t for Currency CUR i CL_AREA Code list for providing values to c i 6 CL DECIMALS Code list for Decimals DECI H E CL_FREQ Code list for Frequency FREQ S68 CL_CONF_STATUS code list for Confidenti EHS Codes E C Confidential statistical information E D Secondary confidentiality set by th E F Free p iE N Not for publication restricted for in LE S Secondary confidentiality set and r i E CL_OBS_STATUS Observation status H E CL_SEX Code list for Sex SEX i E CL_TIME_FORMAT Code list for the Time Fr E CL_UNIT_MULT code list for the Unit Multip H A Codec x t 7 2 2 Code detail S CodeLists H E CL_CURRENCY code list for Currency CURR H E CL_AREA Code list for providing values to cor H E CL_DECIMALS Code list for Decimals DECIM H E CL_FREG Code list for Frequency FREQ J E CL_CONF_STATUS code list for Confidentialit B Codes MSC Confidential statistical information E D Secondary confidentiality set by the E F Free F E N Not for publication restricted for inte LS Secondary confidentiality set and mi i E CL_OBS STATUS Observation status H E CL_SEX Code list for Sex SEX H E CL_TIME_ FORMAT Code list for the Time Fon CL_UNIT_MULT code list for the Unit Muttiplie T1 Cndes mT j amp Plug in E General AgencylD Version Valid From Valid To CL_CONF_ STATUS SDMX l0 E Name code list for Confidentiality Status CONF_STATUS E Is
83. t is currently in memory F previous diagnostic Reload a diagnostic of checking previously done FMR Val de Travers Page 31 75 www sdmx ch wr 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Options CSV format Raise a dialog box used to specify CSV parameters as well as huge file detection limit It is currently required that the first row of the CSV file contains header with column name matching concept referred in DSD CSV Format menu CSV reader properties Chunk E Load Cfo Huge file size Mb HS Save Cfo Kb ess Chunk size 1000 Huge file size defines the maximum size of a CSV file that can be held in application memory For bigger files the application cut the source file as a set of chunk It is then possible to navigate between the chunks FMR Val de Travers Page 32 75 www sdmx ch wer 4 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Data Sample Load DSD information MILK_TABLEA_M ESTAT 2 1 xml contained in SampleFiles then activates Menu Data CSV and load csv file MILK_TABLEA_M_template_sdmx_data csv contained in SampleFiles data Then activates dialog menu Metadata Bind The grid reflects binding as follow CSV Data Viewer amp checker File Metadata Check Options Check Limits Counts Legends Navigate Limit on same column 20 eroe Columns 17 mum Keys Time Concept Limit on whole table 100 emo Matches
84. t local Image copy This command activates a dialog box where the user specifies the directory where the repository content has to be copied The specified directory must be empty The user can then activate the copy process The artefacts are copied and grouped by type in sub directories of the specified target Import local copy of Repository content Import parameters Destination folder C ArtefactsSDMXTEST Process artefact type Organisation Schemes Process artefact type Dataflows Process artefact type Metadataflows Process artefact type Category Schemes Process artefact type Categonsations Process artefact type CodeLists eee Get Artefact informations The process can be cancelled with the cancel button Note In multiplexed mode the import process differs and is done by Owner group refered metadata 6 Other Menus 6 1 Menu Find 6 1 1 Locate References This function locates the references of the code list or concept selected in main tree or given manually in the non modal dialog box URN field FMR Val de Travers Page 25 75 www sdmx ch 4 x SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT l Eea SAE SdmxML Structure Editor with Tiny registry support V 0 99 22 File Repository Find Import Export Categories Data Utilities Help expe 3 oe en E CLSEPARATION Sep SDMX Target SDMX20 H E Attributes Servi Name o Lir 7 ID encylD H
85. t or concept is selected in tree view before activating the menu Activates detail view of the artefact item holding the reference The dialog box remains open so multiple references can be browsed easily If the check box replace by URN is it is possible to select in list the references to modify by the new specified URN To obtain the urn of an item Replace as codelist concept or conceptScheme simply selects item in main tree and activates popup menu Copy artefact reference then uses CTRL V to paste item in URN textbox To look for another reference simply change the selection of concept or code list in tree view and reactivate the menu The dialog box is refreshed with the new material FMR Val de Travers Page 26 75 www sdmx ch wr d SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 6 1 2 Find Annotations This function locates the references of the annotations present in memory Annotations are selected according to specified criteria They are listed in the modeless dialog grid gE Metadataflows Eig Category Schemes 8 6 SDMXStatSubMatDomainsWD1 SOMX aJ Find in Annotations Categories Gi Fey 1 Demographic and social statig Artefact Type Annotation Title Annotation Um Fe 1 1 Population and migratia Fe 1 2 Labour Fer 1 3 Education Annotation Type Annotation Text Fe 1 4 Health CO 5 vee Fer 1 5 Income and consum
86. taflows CL_COUNTRIES ECB 10 ES OANRET ORRA C Metadataflows CL_COUNTRIES ECB 10 DK CL_COUNTRIES ECB LU C CategorySchemes CL_COUNTRIES ECB 10 DE TS TE R ay TEl S J CodeLists CL_COUNTRIES ECB 10 BE k CL_SEX Sex of the person defined ac CL_COUNTRIES ECB 10 AT a HierarchicalCodelists CL_COUNTRIES ECB 10 SE Version 1 From Valid To HCL_SAMPLE Sample Hierarchical Ci CL_COUNTRIES ECB 10 PT 1 0 Codelist Ref CL_COUNTRIES ECB 10 NL sai 255 HIERARCHY_CASE1 CL_COUNTRIES ECB 10 HIERARCHY CASE CL COUNTRIES ECR 10 IT The detail view contains also a tool bar that regroups functions to operate on the hierarchy Deletes selected code in the tree hierarchy All children items are also removed Navigation bar functions as in main tool bar but it operates on hierarchy tree This function is only available if referred code lists are loaded in memory It allows attaching some codes in the hierarchy according to the selected item This function opens a dialog box where user can select code list between referred ones and to select a subset of codes to attach in the hierarchy Codes can be attached to the same level of the tree selected code or as children of the selected code in hierarchy tree FMR Val de Travers Page 51 75 www sdmx ch VA 7 6 5 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Hierarchy Levels HIERARCHY_CASE2 A operti
87. try Repository service documentation 5 2 Usage from SAE Editor 5 2 1 Menu Repository Define repository WS source This menu activates a dialog box displaying the URL of the TinyRegistry service The current status is displayed as well as the URL It is possible to restart or reset the service proxy the status is updated accordingly A list of alternate repository can be defined in the application configuration file a en EF GO 0 SDMX Target SDMX20 d Repository Configuration Oo Ta Status Ok URL Htp Aocalhost 59699 TinyRegisty Repository asmx 7 Defined Sources Usage URL List Demo Alocalhost 59699 Tin Dema http localhost 59695 T iny Registr Repository asme Metastat http jmeta admin ch Tiny Registr Repository asm Harmonisation t ch Harmo Repository asm Restart proxy access to Repository service by using the url specified in configuration file Restart proxy access to Repository service by using the url specified by the user in the URL textbox FMR Val de Travers Page 20 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT URL List http local Metastat Harmonsa Selects another repository URL It is activated for the next accesses The optional list of alternate repository is given in configuration file with the tag TinyRegistryAlternateUrl Each alternate repository is given as two items usage ur
88. umns Concept E Grouping keyff many GroupCfg Header Defines the set of columns index 1 1 the Ss Fyi 1Mmare the item Name is given in each supported dtang Sets unav At the bottom of the property editor an information area gives explanation about the selected property 8 3 2 Hierarchy mapping If requested the hierarchy can be inserted in the SDMX artefact The hierarchy can be specified according to different methods E Attributes AbbreviationColumns unused ColKey 1 ColParent Key 2 ColParentMode DescriptionColumns NameColumns Level Concept Parentid E Grouping key if many DeducesFromCodeLen GroupCfg Header FMR Val de Travers Page 70 75 www sdmx ch SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT e ColKey specifies the column of the item ID code It is mandatory e ColParentKey specifies the column of the parent information This is optional or mandatory for some modes of the hierarchy e ColParentMode specifies the mode to use for determining the hierarchy o None hierarchy unused o Level Hierarchy constructed from item code level number In this case the ColParentKey information must indicate the level column o Parentld Hierarchy constructed from item code parent information In this case the ColParentKey information must indicate the parent id column o Deduces from code length The hierarchy id deduced from code size changes In
89. under this menu domain require a valid link with the TinyRegistry web services Define Repository WS source Provides a dialog box where an available instance of TinyRegistry source can be selected to work with Get Artefact This command provides a dialog box giving access to the Repository service From there all available artefacts can be searched and loaded Reserves Artefact Check out Reserves selected artefact in repository for unique usage of Windows Identity user Submit Artefact Check in Submit an update of selected artefact in repository or cancel previous reservation Submit Aggregated Artefacts Submit to the repository the whole memory project as an aggregated artefacts document Import local Image copy This command raises a dialog box allowing user to parameter a copy of the whole content of the repository in a given local directory FMR Val de Travers Page 10 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT 3 2 3 Find Menu Locate References This function locates the references of the code list or concept selected in main tree A non modal dialog box is displayed with all references found in project memory in Concept Scheme DSD or MSD It is then possible to activate automatically the detailed view of the artefact item holding the selected reference Replacement of reference s is also available Find in Annotations This menu provides a dialog bo
90. w for a simulated concept scheme The references in DSD are also updated to concept scheme i Loncept scnemes GlobalConcepts_IMF Simulated Concept Scheme from Global Concepts of IMF a Concepts E COUGRP Country amp Group ECONOMICCONCEPT Economic Concept DATASOURCE Data Source E STATUS Status E UNIT Unit E FREQUENCY Frequency E TIME Time OBS_STATUS Observation Status O Metadata Structure Definitions FMR Val de Travers Page 41 75 www sdmx ch wr 7 3 3 File Import a Gf en Concept detail Export Categories E QOO d Concepts iE ACCESSIBILITY Accessibility H E ACCURACY Accuracy ADJUSTMENT Adjustment iE ADJUST_CODED Adjustment coded ADJUST_DETAIL Adjustment detail E BASE_PER Base Period CIVIL_STATUS Civil Status E CLARITY Clarity CLASS SYSTEM Classification systems H E COHERENCE Coherence E COMMENT Comment H E COMPARABILITY Comparability i E COMPILING_ORG Compiling agency H E CONF Confidentiality H E CONTACT Contact H E COST_BURDEN Cost and Burden E VIS_AREA Counterpart Reference Area Data Utilities ADJUST_CODED Adj SOMX Target SDMX 2 0 SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT Options Help AS Plug in yy General Parent Name Adjustment Concept Id ADJUST_CODED Parent Concept ADJUSTMENT Name Adjustment coded Description eee
91. x for search criteria specification It is then possible to activate automatically the detailed view of the artefact item holding the selected annotation 3 2 4 Import Menu Excel Provides a dialog box where the artefact type and the fields mapping can be specified The Excel content can then be imported as an SDMX artefact SDMX ML by URN This command provides a dialog box to specify the URI locator of a SDMX ML document to append in project memory 3 2 5 Export Menu Excel Exports selected artefact as an Excel document CSV comma separated values Exports selected code list as an CSV document User can choose separator in submenu commands 3 2 6 Categories Menu lf configured it provides a set of entry points for navigation from Repository Full ID of artefacts to load must be defined in the configuration file of the application 3 2 7 Data Menu SQL Experimental Creates from a selected DSD a set of SQL commands for construction of Oracle tables dim and facts CSV Read CSV data file and bind it with DSD metadata a validity control is available It can operate on huge file through a chunking mechanism 3 2 8 Utilities Menu Copy Artefact Ref FMR Val de Travers Page 11 75 www sdmx ch wr SAE SDMX ML STRUCTURE ARTEFACT EDITOR WITH OPTIONAL TINY REGISTRY SUPPORT This function creates in the MS Window clipboard the urn reference of the artefact or its sub item selected in the tree view The urn c

SAE Editor User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents