Wiki source code of 13 Validation and Transformation Language
Last modified by Helena on 2025/09/10 11:19
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
6.2 | 1 | {{box title="**Contents**"}} |
| 2 | {{toc/}} | ||
| 3 | {{/box}} | ||
| |
2.1 | 4 | |
| 5 | == {{id name="_Toc371081"/}}13.1 Introduction == | ||
| 6 | |||
| |
12.1 | 7 | This [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] model package supports the definition of Transformations, which are algorithms to calculate new data starting from already existing ones, written using the [[Validation and Transformation Language>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] ([[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]){{footnote}}The Validation and Transformation Language is a standard language designed and published under the SDMX initiative. VTL is described in the VTL User and Reference Guides available on the SDMX website [[https://sdmx.org]].{{/footnote}}. |
| |
2.1 | 8 | |
| 9 | The purpose of this model package is to enable the: | ||
| 10 | |||
| |
10.1 | 11 | * definition of validation and transformation algorithms by means of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]], in order to specify how to calculate new [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data from existing ones; |
| 12 | * exchange of the definition of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] algorithms, also together the definition of the data structures of the involved data (for example, exchange the data structures of a reporting framework together with the validation rules to be applied, exchange the input and output data structures of a calculation task together with the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations describing the calculation algorithms); | ||
| 13 | * execution of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] algorithms, either interpreting the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations or translating them in whatever other computer language is deemed as appropriate; | ||
| |
2.1 | 14 | |
| |
10.1 | 15 | This model package does not explain the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] language or any of the content published in the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] guides. Rather, this is an illustration of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] classes and [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]] that allow defining [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations applied to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]]. |
| |
2.1 | 16 | |
| |
12.2 | 17 | The [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] model represented below is consistent with the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] 2.0 specification. However, the former uses the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] terminology and is a model at technical level (from which the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] implementation [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] for defining [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations are built), whereas the latter uses the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] terminology and is at conceptual level. The guidelines for mapping these terminologies and using the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] in the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] context can be found in a dedicated chapter (“//[[Validation and Transformation Language>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]//”) of the Section 6 of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Standards (“//[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Technical Notes//”), often referenced below. |
| |
2.1 | 18 | |
| 19 | == {{id name="_Toc371082"/}}13.2 Model - Inheritance view == | ||
| 20 | |||
| 21 | === {{id name="_Toc371083"/}}13.2.1 Class Diagram === | ||
| 22 | |||
| 23 | [[image:SDMX_2-1_SECTION_2_InformationModel_2020-07_4f832b90.jpg||height="337" width="613"]] | ||
| 24 | |||
| 25 | **Figure 44: Class inheritance diagram in the Transformations and Expressions Package** | ||
| 26 | |||
| 27 | === {{id name="_Toc371084"/}}13.2.2 Explanation of the Diagram === | ||
| 28 | |||
| 29 | ==== 13.2.2.1 Narrative ==== | ||
| 30 | |||
| |
10.1 | 31 | The model [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] TransformationScheme, RulesetScheme, UserDefinedOperatorScheme, NamePersonalisationScheme, CustomTypeScheme, and VtlMappingScheme inherit from ItemScheme |
| |
2.1 | 32 | |
| |
10.1 | 33 | These schemes inherit from the //ItemScheme //and therefore have the following [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]]: |
| |
2.1 | 34 | |
| |
6.2 | 35 | * id |
| 36 | * uri | ||
| 37 | * urn | ||
| 38 | * version | ||
| 39 | * validFrom | ||
| 40 | * validTo | ||
| |
2.1 | 41 | * isExternalReference |
| 42 | * registryURL | ||
| 43 | * structureURL | ||
| 44 | * repositoryURL | ||
| |
6.2 | 45 | * final |
| 46 | * isPartial | ||
| |
2.1 | 47 | |
| |
10.1 | 48 | The model [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] Transformation, Ruleset, UserDefinedOperator, NamePersonalisation, //VtlMapping//, CustomType inherit the [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]] and associations of Item which itself inherits from NameableArtefact. They have the following [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]]: |
| |
2.1 | 49 | |
| 50 | * id | ||
| 51 | * uri | ||
| 52 | * urn | ||
| 53 | |||
| 54 | The multi-lingual name and description are provided by the relationship to InternationalString from NameableArtefact. | ||
| 55 | |||
| 56 | == {{id name="_Toc371085"/}}13.3 Model - Relationship View == | ||
| 57 | |||
| 58 | === {{id name="_Toc371086"/}}13.3.1 Class Diagram === | ||
| 59 | |||
| 60 | [[image:SDMX_2-1_SECTION_2_InformationModel_2020-07_3d240eb0.jpg||height="745" width="613"]] | ||
| 61 | |||
| 62 | **Figure 45: Relationship diagram in the Transformations and Expressions Package** | ||
| 63 | |||
| 64 | === {{id name="_Toc371087"/}}13.3.2 Explanation of the Diagram === | ||
| 65 | |||
| 66 | ==== 13.3.2.1 Narrative - Overview ==== | ||
| 67 | |||
| 68 | **Transformation Scheme** | ||
| 69 | |||
| |
10.1 | 70 | A TransformationScheme is a set of Transformations aimed at obtaining some meaningful results for the user (e.g. the validation of one or more [[Data Sets>>doc:sdmx:Glossary.Data set.WebHome]]). This set of Transformations is meant to be executed together (in the same run) and may contain any number of Transformations in order to produce any number of results. Therefore, a TransformationScheme can be considered as a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] program. |
| |
2.1 | 71 | |
| |
12.2 | 72 | The TransformationScheme must include the [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] vtlVersion expressed as a string (e.g. “2.0”), as the version of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] determines which syntax is used in defining the transformations of the scheme. |
| |
2.1 | 73 | |
| |
10.1 | 74 | A Transformation consists of a statement which assigns the outcome of the evaluation of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] expression to a result (an [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Information Model, which in the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] context can be a persistent or non-persistent Dataflow{{footnote}}Or a part of a Dataflow, see also the chapter “Validation and Transformation Language” of the Section 6 of the SDMX Standards (“SDMX Technical Notes”), paragraph “Mapping dataflow subsets to distinct VTL data sets”.{{/footnote}}). |
| |
2.1 | 75 | |
| |
10.1 | 76 | For example, assume that D1, D2 and D3 are [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]] (called [[Data Sets>>doc:sdmx:Glossary.Data set.WebHome]] in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]) containing information on some goods, specifically: D3 the current stocks, D1 the stocks of the previous date, D2 the flows in the last period. A possible [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformation aimed at checking the consistency between flows and stocks is the following: |
| |
2.1 | 77 | |
| 78 | Dr := If ( (D1 + D2) = D3, then “true”, else “false”) | ||
| 79 | |||
| 80 | In this Transformation: | ||
| 81 | |||
| |
7.2 | 82 | [[image:1747906180020-120.png]] |
| |
2.1 | 83 | |
| |
10.1 | 84 | The Transformation model [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] contains three [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]]: |
| |
2.1 | 85 | |
| |
7.2 | 86 | ~1. result |
| |
10.1 | 87 | The left-hand side of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement, which specifies the [[Artefact>>doc:sdmx:Glossary.Artefact.WebHome]] to which the outcome of the expression is assigned. An [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] cannot be result of more than one Transformation. |
| |
2.1 | 88 | |
| |
7.2 | 89 | 2. isPersistent |
| |
2.1 | 90 | An assignment operator, which specifies also the persistency of the left-hand side. The assignment operators are two, namely **:=** for non-persistent assignment (the result is non-persistent) and **<-** for persistent assignment (the result is persistent). |
| 91 | |||
| |
7.2 | 92 | 3. expression |
| |
10.1 | 93 | The right-hand side of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement, which is the expression to be evaluated. An expression consists in the invocation of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] operators in a certain order. When an operator is invoked, for each input parameter, an actual argument is passed to the operator, which returns an actual argument for the output parameter. An expression is simply a text string written according the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] grammar. |
| |
2.1 | 94 | |
| |
10.1 | 95 | Because an [[Artefact>>doc:sdmx:Glossary.Artefact.WebHome]] can be the result of just one Transformation and a Transformation belongs to just one TransformationScheme, it follows also that a derived [[Artefact>>doc:sdmx:Glossary.Artefact.WebHome]] (e.g. a new [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]) is produced in just one TransformationScheme. |
| |
2.1 | 96 | |
| |
10.1 | 97 | The result of a Transformation can be input of other Transformations. The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] assumes that non-persistent results are maintained only within the same TransformationScheme in which they are produced. Therefore, a non-persistent result of a Transformation can be the operand of other Transformations of the same TransformationScheme, whereas a persistent result can be operand of transformations of any TransformationScheme{{footnote}}Provided that the VTL consistency rules are accomplished (see the “Generic Model for Transformations” in the VTL User Manual and its sub-section “Transformation Consistency”).{{/footnote}}. |
| |
2.1 | 98 | |
| 99 | The TransformationScheme has an association to zero of more RulesetScheme, zero or more UserDefinedOperatorScheme, zero or one NamePersonalisationScheme, zero or one VtlMappingScheme, and zero or one CustomTypeScheme | ||
| 100 | |||
| |
12.2 | 101 | The RulesetScheme, UserDefinedOperatorScheme NamePersonalisationScheme and CustomTypeScheme have an [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] vtlVersion. Thus, a TransformationScheme using a specific version of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] can be linked to such schemes only if they are consistent with the same [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] version. |
| |
2.1 | 102 | |
| |
10.1 | 103 | The VtlMappingScheme associated to a TransformationScheme must contain the mappings between the references to the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] from the TransformationScheme and the structured identifiers of these [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]]. |
| |
2.1 | 104 | |
| 105 | **Ruleset Scheme** | ||
| 106 | |||
| |
10.1 | 107 | Some [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Operators can invoke rulesets, i.e., sets of previously defined rules to be applied by the Operator. Once defined, a Ruleset is persistent and can be invoked as many times as needed. The knowledge of the rulesets’ definitions (if any) is essential for understanding the actual behaviour of the Transformation that use them: this is achieved through the RulesetScheme model [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]]. The RulesetScheme is the container for one or more |
| |
2.1 | 108 | |
| 109 | Ruleset. | ||
| 110 | |||
| |
10.1 | 111 | The Ruleset model [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] contains the following [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]]: |
| |
2.1 | 112 | |
| |
10.1 | 113 | 1. **rulesetType** – the type of the ruleset according to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] ([[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] 2.0 allows two types: “datapoint” and “hierarchical” ruleset); |
| |
12.2 | 114 | 1. **rulesetScope** – the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] on which the ruleset is defined; [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] 2.0 allows rulesets defined on Value Domains, which correspond to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Codelists>>doc:sdmx:Glossary.Code list.WebHome]], or to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Concept Schemes>>doc:sdmx:Glossary.Concept scheme.WebHome]] and rulesets defined on Variables, which correspond to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] (% style="color:#e74c3c" %)[[Concepts>>doc:sdmx:Glossary.Concept.WebHome]](%%) for which a definite [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] is assumed; |
| |
10.1 | 115 | 1. **rulesetDefinition** – the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement that defines the ruleset according to the syntax of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] definition language. |
| |
2.1 | 116 | |
| |
10.1 | 117 | The RulesetScheme can have an association with zero or more VtlMappingScheme. These mappings define the correspondence between the references to the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] contained in the rulesetDefinition and the structured identifiers of these [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]]. |
| |
2.1 | 118 | |
| |
12.2 | 119 | The rulesets defined on Value Domains reference [[Codelists>>doc:sdmx:Glossary.Code list.WebHome]] or ConceptSchemes (the latter in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] are considered as the Value Domains of the variables corresponding to the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]). The rulesets defined on Variables reference (% style="color:#e74c3c" %)[[Concepts>>doc:sdmx:Glossary.Concept.WebHome]](%%) (for which a definite [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] is assumed). In conclusion, in the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] rulesets there can exist mappings for three kinds of [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]]: [[Codelists>>doc:sdmx:Glossary.Code list.WebHome]], ConceptSchemes and (% style="color:#e74c3c" %)[[Concepts>>doc:sdmx:Glossary.Concept.WebHome]](%%). |
| |
2.1 | 120 | |
| 121 | **User Defined Operator Scheme** | ||
| 122 | |||
| |
10.1 | 123 | The UserDefinedOperatorScheme is a container for zero of more UserDefinedOperator. The UserDefinedOperator is defined using [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] standard operators. This is essential for understanding the actual behaviour of the Transformations that invoke them. |
| |
2.1 | 124 | |
| |
10.1 | 125 | The [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] operatorDefinition contains the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement that defines the operator according to the syntax of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] definition language. |
| |
2.1 | 126 | |
| |
10.1 | 127 | Although the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] user defined operators are conceived to be defined on generic operands, so that the specific [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] to be manipulated are passed as parameters at the invocation, it is also possible that they reference specific [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] like [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]], Codelists and |
| |
2.1 | 128 | |
| |
10.1 | 129 | ConceptSchemes. Therefore, the UserDefinedOperatorScheme can link to zero or one VtlMappingScheme, which must contain the mappings between the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] references and the structured URN of the corresponding [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] (see also the “//[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] mapping//” section below). |
| |
2.1 | 130 | |
| |
10.1 | 131 | The definition of a UserDefinedOperator can also make use of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] rulesets; therefore, the UserDefinedOperatorScheme can link to zero, one or more RulesetScheme, which must contain the definition of these Rulesets (see also the “//Ruleset Scheme//” section above). |
| |
2.1 | 132 | |
| 133 | **Name Personalisation Scheme** | ||
| 134 | |||
| |
10.1 | 135 | In some operations, the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] assigns by default some standard names to some [[measures>>doc:sdmx:Glossary.Measure.WebHome]] and/or [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]] of the data structure of the result{{footnote}}For example, the check operator produces some new components in the result called by default bool_var, errorcode, errorlevel, imbalance. These names can be personalised if needed.{{/footnote}}. The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] allows also to personalise the names to be assigned. The knowledge of the personalised names (if any) is essential for understanding the actual behaviour of the Transformation: this is achieved through the NamePersonalisationScheme. A NamePersonalisation specifies a personalised name that will be assigned in place of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default name. The NamePersonalisationScheme is a container for zero or more NamePersonalisation. |
| |
2.1 | 136 | |
| 137 | **VTL Mapping** | ||
| 138 | |||
| |
10.1 | 139 | The mappings between [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] and [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] can be relevant to the names of the [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] and to the methods for converting the data structures from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] and vice-versa. These features are achieved through the VtlMappingScheme, which is a container for zero or more VtlMapping. |
| |
2.1 | 140 | |
| |
10.1 | 141 | The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] assumes that the operands are directly referenced through their actual names (unique identifiers). In the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations, rulesets, user defined operators, the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] are referenced through [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] aliases. The alias can be the complete URN of the [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]], an abbreviated URN, or another user-defined name, as described in the Section 6 of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Standards.{{footnote}}SDMX Technical Notes, chapter “Validation and Transformation Language”, section “References to SDMX artefacts from VTL statements”.{{/footnote}} |
| |
2.1 | 142 | |
| |
12.2 | 143 | The //VTLmapping// defines the correspondence between the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] alias and the structured identifier of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]], for each referenced [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]]. This correspondence is needed for four kinds of [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]]: [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]], [[Codelists>>doc:sdmx:Glossary.Code list.WebHome]], ConceptSchemes and (% style="color:#e74c3c" %)[[Concepts>>doc:sdmx:Glossary.Concept.WebHome]](%%). Therefore, there are four corresponding mapping subclasses: VtlDataflowMapping; VtlCodelistMapping; VtlConceptSchemeMapping; VtlConceptMapping. |
| |
2.1 | 144 | |
| |
10.1 | 145 | As for the [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]], it is also possible to specify the method to convert the Data Structure of the [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]. This kind of conversion can happen in two directions, from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] when a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] is accessed by a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformation (toVtlMappingMethod), or from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] when a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] derived [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] is calculated through [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] (fromVtlMappingMethod).{{footnote}}For a more thorough description of these conversions, see the Section 6 of the SDMX Standards (“SDMX Technical Notes”), chapter “Validation and Transformation Language”, section “Mapping between SDMX and VTL”.{{/footnote}} |
| |
2.1 | 146 | |
| |
10.1 | 147 | The default mapping method from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] is called “Basic”. Three alternative mapping methods are possible, called “Pivot”, “Basic-A2M”, “Pivot-A2M” (“A2M” stands for “[[Attributes>>doc:sdmx:Glossary.Attribute.WebHome]] to [[Measures>>doc:sdmx:Glossary.Measure.WebHome]]”, i.e. the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Data [[Attributes>>doc:sdmx:Glossary.Attribute.WebHome]] become [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[Measures>>doc:sdmx:Glossary.Measure.WebHome]]). |
| |
2.1 | 148 | |
| |
10.1 | 149 | The default mapping method from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] is also called “Basic”, and the two alternative mapping methods are called “Unpivot” and “M2A” (“M2A” stands for “[[Measures>>doc:sdmx:Glossary.Measure.WebHome]] to [[Attributes>>doc:sdmx:Glossary.Attribute.WebHome]]”, i.e. one [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] becomes the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] PrimaryMeasure and the other [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[Measures>>doc:sdmx:Glossary.Measure.WebHome]] become a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] DataAttribute). |
| |
2.1 | 150 | |
| |
10.1 | 151 | In both the mapping directions, no specification is needed if the default mapping method (Basic) is used. When an alternative mapping method is applied for some [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]], this has to be specified in toVtlMappingMethod or fromVtlMappingMethod. |
| |
2.1 | 152 | |
| 153 | **ToVtlSubspace, ToVtlSpaceKey, FromVtlSuperspace, FromVtlSpaceKey** | ||
| 154 | |||
| |
12.2 | 155 | Although in general one [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] is mapped to one [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] and vice-versa, it is also allowed to map distinct parts of a single [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] to distinct [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[data sets>>doc:sdmx:Glossary.Data set.WebHome]] according to the rules and conventions described in the Section 6 of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Standards.{{footnote}}SDMX Technical Notes, chapter “Validation and Transformation Language”, section “Mapping dataflow subsets to distinct VTL data sets”.{{/footnote}} |
| |
2.1 | 156 | |
| |
12.2 | 157 | In the direction from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]], this is achieved by fixing the values of some predefined [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Data Structure: all the observations having such combination of values are mapped to one corresponding [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] (the [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] having fixed values are not maintained in the Data Structure of the resulting [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]]). The ToVtlSubspace and ToVtlSpaceKey classes allow to define these [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]. When one [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] is mapped to just one [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] these classes are not used. |
| |
2.1 | 158 | |
| |
12.2 | 159 | Analogously, in the direction from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]], it is possible to map more calculated [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] to distinct parts of a single [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]], as long as these [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] have the same Data Structure. This can be done by providing, for each [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]], distinct values for some additional [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] that are not part of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] data structure. The FromVtlSuperspace and FromVtlSpaceKey classes allow to define these [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]. When one [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] is mapped to just one [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] these classes are not used. |
| |
2.1 | 160 | |
| 161 | **Custom Type Scheme** | ||
| 162 | |||
| |
10.1 | 163 | As already said, a Transformation consists of a statement which assigns the outcome of the evaluation of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] expression to a result, i.e. an [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Information Model, which in the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] context can be a persistent or non-persistent [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]{{footnote}}Or a part of a Dataflow, as described in the previous paragraph.{{/footnote}}. Therefore, the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] data type of the outcome of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] expression has to be converted into the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data type of the resulting [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]. A default conversion table from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data types is assumed{{footnote}}The default conversion table from VTL to SDMX is described in the the Section 6 of the SDMX Standards (“SDMX Technical Notes”), chapter “Validation and Transformation Language”, section “Mapping VTL basic scalar types to SDMX data types”.{{/footnote}}. The CustomTypeScheme allows to specify custom conversions that override the default conversion table. The CustomTypeScheme is a container for zero or more CustomType. A CustomType specifies the custom conversion from a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] scalar type that will override the default conversion. The overriding [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data type is specified by means of the dataType and outputFormat [[attributes>>doc:sdmx:Glossary.Attribute.WebHome]] (the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data type assumes the role of external [[representation>>doc:sdmx:Glossary.Representation.WebHome]] in respect to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]{{footnote}}About VTL internal and external representations, see also the VTL User Manual, section “Basic scalar types”, p.53.{{/footnote}}). |
| |
2.1 | 164 | |
| |
10.1 | 165 | Moreover, the CustomType allows to customize the default format of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] literals and the (possible) [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] value to be produced when a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[measure>>doc:sdmx:Glossary.Measure.WebHome]] or [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] is NULL. |
| |
2.1 | 166 | |
| |
10.1 | 167 | [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] expression can contain literals, i.e. specific values of a certain [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] data type written according to a certain format. For example, consider the following Transformation that extracts from the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] D1 the observations for which the “reference_date” belongs to the years 2018 and 2019: |
| |
2.1 | 168 | |
| |
8.1 | 169 | > Dr := D1 [ filter between (reference_date, 2018-01-01, 2019-12-31)] |
| |
2.1 | 170 | |
| |
10.1 | 171 | In this expression, the two values 2018-01-01 and 2019-12-31 are literals of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] “date” scalar type expressed in the format YYYY-MM-DD. |
| |
2.1 | 172 | |
| |
10.1 | 173 | The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] literals are assumed to be written in the same [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] format specified in the default conversion table mentioned above, for the conversion from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data types. If a different format is used for a certain [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] scalar type, it must be specified in the vtlLiteralFormat [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] of the CustomType |
| |
2.1 | 174 | |
| |
10.1 | 175 | Regarding the management of NULLs, in the conversions between [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] and [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]], by default a missing value in [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] in converted in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] NULL and vice-versa, for any [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] scalar type. If a different value is needed, after the conversion from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]], proper [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] operators can be used for obtaining it. In the conversion from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] the desired value can be declared in the nullValue [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]] (separately for each [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] basic scalar type). |
| |
2.1 | 176 | |
| |
11.1 | 177 | ==== 13.3.2.2 Definitions ==== |
| |
2.1 | 178 | |
| |
7.1 | 179 | (% style="width:1077.29px" %) |
| 180 | |(% style="width:254px" %)**Class**|(% style="width:230px" %)**Feature**|(% style="width:591px" %)**Description** | ||
| 181 | |(% style="width:254px" %)Transformation Scheme|(% style="width:230px" %)((( | ||
| |
2.1 | 182 | Inherits from |
| 183 | //ItemScheme// | ||
| |
7.1 | 184 | )))|(% style="width:591px" %)Contains the definitions of transformations meant to produce some derived data and be executed together |
| |
12.2 | 185 | |(% style="width:254px" %) |(% style="width:230px" %)vtlVersion|(% style="width:591px" %)The version of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] language used for defining transformations |
| |
7.1 | 186 | |(% style="width:254px" %)Transformation|(% style="width:230px" %)((( |
| |
2.1 | 187 | Inherits from |
| 188 | //Item// | ||
| |
10.1 | 189 | )))|(% style="width:591px" %)A [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement which assigns the outcome of an expression to a result. |
| 190 | |(% style="width:254px" %) |(% style="width:230px" %)result|(% style="width:591px" %)The left-hand side of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement, which identifies the result [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]]. | ||
| 191 | |(% style="width:254px" %) |(% style="width:230px" %)isPersistent|(% style="width:591px" %)A boolean that indicates whether the result is permanently stored or not, depending on the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] assignment operator. | ||
| 192 | |(% style="width:254px" %) |(% style="width:230px" %)expression|(% style="width:591px" %)The right-hand side of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement that is the expression to be evaluated, which includes the references to the operands of the Transformation. | ||
| |
7.1 | 193 | |(% style="width:254px" %)RulesetScheme|(% style="width:230px" %)((( |
| |
2.1 | 194 | Inherits from |
| 195 | //ItemScheme// | ||
| |
7.1 | 196 | )))|(% style="width:591px" %)Container of rulesets. |
| |
12.2 | 197 | |(% style="width:254px" %) |(% style="width:230px" %)vtlVersion|(% style="width:591px" %)The version of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] language used for defining the rulesets |
| |
7.1 | 198 | |(% style="width:254px" %)Ruleset|(% style="width:230px" %)((( |
| |
2.1 | 199 | Inherits from |
| 200 | //Item// | ||
| |
10.1 | 201 | )))|(% style="width:591px" %)A persistent set of rules which can be invoked by means of appropriate [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] operators. |
| 202 | |(% style="width:254px" %) |(% style="width:230px" %)rulesetDefinition|(% style="width:591px" %)A [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement for the definition of a ruleset (according to the syntax of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] definition language) | ||
| 203 | |(% style="width:254px" %) |(% style="width:230px" %)rulesetType|(% style="width:591px" %)The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] type of the ruleset (e.g., in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] 2.0, datapoint or hierarchical) | ||
| 204 | |(% style="width:254px" %) |(% style="width:230px" %)rulesetScope|(% style="width:591px" %)The model [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] on which the ruleset is defined (e.g., in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] 2.0, valuedomain or variable) | ||
| |
7.1 | 205 | |(% style="width:254px" %)UserDefinedOperator Scheme|(% style="width:230px" %)((( |
| |
2.1 | 206 | Inherits from |
| 207 | //ItemScheme// | ||
| |
7.1 | 208 | )))|(% style="width:591px" %)Container of user defined operators |
| |
12.2 | 209 | |(% style="width:254px" %) |(% style="width:230px" %)vtlVersion|(% style="width:591px" %)The version of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] language used for defining the user defined operators |
| |
7.1 | 210 | |(% style="width:254px" %)UserDefinedOperator|(% style="width:230px" %)((( |
| |
2.1 | 211 | Inherits from |
| 212 | //Item// | ||
| |
10.1 | 213 | )))|(% style="width:591px" %)Custom [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] operator (not existing in the standard library) that extends the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] standard library for specific purposes. |
| 214 | |(% style="width:254px" %) |(% style="width:230px" %)operatorDefinition|(% style="width:591px" %)A [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] statement for the definition of a new operator: it specifies the operator name, its parameters and their data types, the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] expression that defines its behaviour. | ||
| |
2.1 | 215 | |
| 216 | ((( | ||
| |
7.1 | 217 | (% style="width:1078.29px" %) |
| 218 | |(% style="width:254px" %)**Class**|(% style="width:230px" %)**Feature**|(% style="width:591px" %)**Description** | ||
| 219 | |(% style="width:254px" %)NamePersonalisation Scheme|(% style="width:230px" %)((( | ||
| |
2.1 | 220 | Inherits from |
| 221 | //ItemScheme// | ||
| |
7.1 | 222 | )))|(% style="width:591px" %)Container of name personalisations. |
| |
12.2 | 223 | |(% style="width:254px" %) |(% style="width:230px" %)vtlVersion|(% style="width:591px" %)The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] version which the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default names to be personalised belong to. |
| |
7.1 | 224 | |(% style="width:254px" %)NamePersonalisation|(% style="width:230px" %)((( |
| |
2.1 | 225 | Inherits from |
| 226 | //Item// | ||
| |
10.1 | 227 | )))|(% style="width:591px" %)Definition of personalised name to be used in place of a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default name. |
| 228 | |(% style="width:254px" %) |(% style="width:230px" %)vtlArtefact|(% style="width:591px" %)[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] model [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] to which the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default name to be personalised refers, e.g. variable, value domain. | ||
| 229 | |(% style="width:254px" %) |(% style="width:230px" %)vtlDefaultName|(% style="width:591px" %)The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default name to be personalised. | ||
| 230 | |(% style="width:254px" %) |(% style="width:230px" %)personalisedName|(% style="width:591px" %)The personalised name to be used in place of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] default name. | ||
| |
7.1 | 231 | |(% style="width:254px" %)VtlMappingScheme|(% style="width:230px" %)((( |
| |
2.1 | 232 | Inherits from |
| 233 | //ItemScheme// | ||
| |
10.1 | 234 | )))|(% style="width:591px" %)Container of [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] mappings. |
| |
7.1 | 235 | |(% style="width:254px" %)VtlMapping|(% style="width:230px" %)((( |
| |
2.1 | 236 | Inherits from |
| 237 | //Item// | ||
| 238 | Sub classes are: | ||
| 239 | VtlDataflowMapping | ||
| |
7.1 | 240 | VtlCodelistMapping VtlConceptSchemeMapping |
| |
2.1 | 241 | VtlConceptMapping |
| |
10.1 | 242 | )))|(% style="width:591px" %)Single mapping between the reference to a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] made from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] transformations, rulesets, user defined operators and the corresponding [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] structure identifier. |
| 243 | |(% style="width:254px" %)VtlDataflowMapping|(% style="width:230px" %)Inherits from //VtlMapping//|(% style="width:591px" %)Single mapping between the reference to a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] and the corresponding [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] structure identifier | ||
| 244 | |(% style="width:254px" %) |(% style="width:230px" %)dataflowAlias|(% style="width:591px" %)Alias used in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to reference a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] (it can be the URN, the abbreviated URN or a user defined alias). The alias must be univocal: different [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] cannot have the same [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] alias. | ||
| 245 | |(% style="width:254px" %) |(% style="width:230px" %)toVtlMappingMethod|(% style="width:591px" %)Custom specification of the mapping method from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] data structures for the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] (overriding the default “basic” method). | ||
| 246 | |(% style="width:254px" %) |(% style="width:230px" %)fromVtlMappingMethod|(% style="width:591px" %)Custom specification of the mapping method from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data structures for the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] (overriding the default “basic” method). | ||
| 247 | |(% style="width:254px" %)VtlCodelistMapping|(% style="width:230px" %)Inherits from //VtlMapping//|(% style="width:591px" %)Single mapping between the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] reference to a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] codelist and the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] structure identifier of the codelist. | ||
| 248 | |(% style="width:254px" %) |(% style="width:230px" %)codelistAlias|(% style="width:591px" %)Name used in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to reference a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] codelist. The name/alias must be univocal: different [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] cannot have the same [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] alias. | ||
| 249 | |(% style="width:254px" %)VtlConceptSchemeMap ping|(% style="width:230px" %)Inherits from //VtlMapping//|(% style="width:591px" %)Single mapping between the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] reference to a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[concept scheme>>doc:sdmx:Glossary.Concept scheme.WebHome]] and the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] structure identifier of the [[concept scheme>>doc:sdmx:Glossary.Concept scheme.WebHome]]. | ||
| 250 | |(% style="width:254px" %) |(% style="width:230px" %)conceptSchemeAlias|(% style="width:591px" %)Name used in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to reference a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[concept scheme>>doc:sdmx:Glossary.Concept scheme.WebHome]]. The name/alias must be univocal: different [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] cannot have the same [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] alias. | ||
| |
12.2 | 251 | |(% style="width:254px" %)VtlConceptMapping|(% style="width:230px" %)Inherits from //VtlMapping//|(% style="width:591px" %)Single mapping between the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] reference to a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] (% style="color:#e74c3c" %)[[concept>>doc:sdmx:Glossary.Concept.WebHome]](%%) and the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] structure identifier of the (% style="color:#e74c3c" %)[[concept>>doc:sdmx:Glossary.Concept.WebHome]](%%). |
| 252 | |(% style="width:254px" %) |(% style="width:230px" %)conceptAlias|(% style="width:591px" %)Name used in [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to reference a [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] (% style="color:#e74c3c" %)[[concept>>doc:sdmx:Glossary.Concept.WebHome]](%%). The name/alias must be univocal: different [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] cannot have the same [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] alias. | ||
| 253 | |(% style="width:254px" %)ToVtlSubspace|(% style="width:230px" %) |(% style="width:591px" %)Subspace of the [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] used to identify the parts of the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] to be mapped to distinct [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] | ||
| 254 | |(% style="width:254px" %)ToVtlSpaceKey|(% style="width:230px" %) |(% style="width:591px" %)A [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] that contributes to identify the parts of the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] to be mapped to distinct [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] | ||
| 255 | |(% style="width:254px" %) |(% style="width:230px" %)Key|(% style="width:591px" %)The identity of the [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] in the [[data structure definition>>doc:sdmx:Glossary.Data structure definition.WebHome]] of the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] that contributes to identify the parts of the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] to be mapped to distinct [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] | ||
| |
10.1 | 256 | |(% style="width:254px" %)FromVtlSuperspace|(% style="width:230px" %) |(% style="width:591px" %)Superspace composed of the [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] to be added to the data structure of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] result [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] in order to obtain the data structure of the derived [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] (in case the latter is a superset of distinct [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[datasets>>doc:sdmx:Glossary.Data set.WebHome]] calculated independently) |
| 257 | |(% style="width:254px" %)FromVtlSpaceKey|(% style="width:230px" %) |(% style="width:591px" %)A [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] to be added to the data structure of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] result [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] in order to obtain the data structure of the derived [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] | ||
| 258 | |(% style="width:254px" %) |(% style="width:230px" %)Key|(% style="width:591px" %)The identity of the [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] to be added to the data structure of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] result [[dataset>>doc:sdmx:Glossary.Data set.WebHome]] in order to obtain the data structure of the derived [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] | ||
| |
2.1 | 259 | ))) |
| 260 | |||
| 261 | ((( | ||
| |
7.1 | 262 | (% style="width:1078.29px" %) |
| 263 | |(% style="width:256px" %)**Class**|(% style="width:232px" %)**Feature**|(% style="width:587px" %)**Description** | ||
| 264 | |(% style="width:256px" %)CustomTypeScheme|(% style="width:232px" %)((( | ||
| |
2.1 | 265 | Inherits from |
| 266 | //ItemScheme// | ||
| |
10.1 | 267 | )))|(% style="width:587px" %)Container of custom specifications for [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] basic scalar types. |
| |
12.2 | 268 | |(% style="width:256px" %) |(% style="width:232px" %)vtlVersion|(% style="width:587px" %)The [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] version which the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] scalar types belong to. |
| |
7.1 | 269 | |(% style="width:256px" %)CustomType|(% style="width:232px" %)((( |
| |
2.1 | 270 | Inherits from |
| 271 | //Item// | ||
| |
10.1 | 272 | )))|(% style="width:587px" %)Custom specification for a [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] basic scalar type. |
| 273 | |(% style="width:256px" %) |(% style="width:232px" %)vtlScalarType|(% style="width:587px" %)[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] scalar type for which the custom specifications are given. | ||
| 274 | |(% style="width:256px" %) |(% style="width:232px" %)outputFormat|(% style="width:587px" %)Custom specification of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] formatting mask needed to obtain to the desired [[representation>>doc:sdmx:Glossary.Representation.WebHome]], i.e. the desired [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] format (e.g. YYYY-MMDD, see also the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] formatting mask in the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Reference Manual and the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] Technical Notes). If not specified, the “Default output format” of the default conversion table from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] is used.{{footnote}}See “Mapping VTL basic scalar types to SDMX data types” in the SDMX Technical Notes, chapter “Validation and Transformation Language”.{{/footnote}} | ||
| 275 | |(% style="width:256px" %) |(% style="width:232px" %)datatype|(% style="width:587px" %)Custom specification of the external ([[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]) data type in which the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] data type has to be converted (e.g. the GregorianDay). If not specified, the “Default [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data type” of the default conversion table from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] is used.{{footnote}}See “Mapping VTL basic scalar types to SDMX data types” in the SDMX Technical Notes, chapter “Validation and Transformation Language”.{{/footnote}} | ||
| 276 | |(% style="width:256px" %) |(% style="width:232px" %)nullValue|(% style="width:587px" %)Custom specification of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] value to be produced for the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] NULL values, with reference to the vtlScalarType specified above. If no value is specified, no value is produced. | ||
| |
7.1 | 277 | |(% style="width:256px" %) |(% style="width:232px" %)vtlLiteralFormat|(% style="width:587px" %)((( |
| |
10.1 | 278 | Custom specification of the format of the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] literals belonging to the vtlScalarType used in the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] program (e.g. YYYY-MM-DD){{footnote}}See also the VTL formatting mask in the VTL Reference Manual and the SDMX Technical Notes.{{/footnote}}. If not specified, the “Default output format” of the default conversion table from [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] is assumed.{{footnote}}See “Mapping VTL basic scalar types to SDMX data types” in the SDMX Technical Notes, chapter “Validation and Transformation Language.{{/footnote}} |
| |
2.1 | 279 | ))) |
| 280 | ))) | ||
| |
6.2 | 281 | |
| |
8.1 | 282 | ---- |
| 283 | |||
| |
6.2 | 284 | {{putFootnotes/}} |