Changes for page 12 Validation and Transformation Language (VTL)
Last modified by Artur on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -78,8 +78,10 @@ 78 78 * if the [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] is a [[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]], TimeDimension, [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] or DataAttribute (the object-id is the name of one of the [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]] above, which are data structure components) 79 79 * if the [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]] is a (% style="color:#e74c3c" %)Concept(%%) (the object-id is the name of the (% style="color:#e74c3c" %)Concept(%%)) 80 80 81 -For example, by using the URN, the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformation that sums two [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]] DF1 and DF2 and assigns the result to a third persistent [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] DFR, assuming that DF1, DF2 and DFR are the maintainedobject-id of the three [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]], that their (% style="color:#e74c3c" %)version(%%) is 1.0.0 and their Agency is AG, would be written as {{footnote}}Since these references to SDMX objects include non-permitted characters as per the VTL ID notation, they need to be included between single quotes, according to the VTL rules for irregular names.{{/footnote}}:81 +For example, by using the URN, the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformation that sums two [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]] DF1 and DF2 and assigns the result to a third persistent [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] DFR, assuming that DF1, DF2 and DFR are the maintainedobject-id of the three [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]], that their (% style="color:#e74c3c" %)version(%%) is 1.0.0 and their Agency is AG, would be written as 82 82 83 +{{footnote}}Since these references to SDMX objects include non-permitted characters as per the VTL ID notation, they need to be included between single quotes, according to the VTL rules for irregular names.{{/footnote}}: 84 + 83 83 > 'urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=AG:DFR(1.0.0)' <- 84 84 > 'urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=AG:DF1(1.0.0)' + 85 85 > 'urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=AG:DF2(1.0.0)' ... ... @@ -207,7 +207,7 @@ 207 207 When transforming **from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]**, this method consists in leaving the [[components>>doc:sdmx:Glossary.Component.WebHome]] unchanged and maintaining their names and roles, according to the following table: 208 208 209 209 (% style="width:468.294px" %) 210 -|(% style="width:196px" %)**SDMX**|(% style="width:269px" %)**VTL** 212 +|(% style="width:196px" %)**[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]**|(% style="width:269px" %)**[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]** 211 211 |(% style="width:196px" %)[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]|(% style="width:269px" %)(Simple) Identifier 212 212 |(% style="width:196px" %)TimeDimension|(% style="width:269px" %)(Time) Identifier 213 213 |(% style="width:196px" %)[[Measure>>doc:sdmx:Glossary.Measure.WebHome]]|(% style="width:269px" %)[[Measure>>doc:sdmx:Glossary.Measure.WebHome]] ... ... @@ -241,7 +241,7 @@ 241 241 The summary mapping table of the "pivot" mapping from [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] to [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] for the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data structures that contain a MeasureDimension is the following: 242 242 243 243 (% style="width:739.294px" %) 244 -|(% style="width:335px" %)**SDMX**|(% style="width:400px" %)**VTL** 246 +|(% style="width:335px" %)**[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]**|(% style="width:400px" %)**[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]** 245 245 |(% style="width:335px" %)[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]]|(% style="width:400px" %)(Simple) Identifier 246 246 |(% style="width:335px" %)TimeDimension|(% style="width:400px" %)(Time) Identifier 247 247 |(% style="width:335px" %)MeasureDimension & one [[Measure>>doc:sdmx:Glossary.Measure.WebHome]]|(% style="width:400px" %)One [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] for each [[Code>>doc:sdmx:Glossary.Code.WebHome]] of the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] MeasureDimension ... ... @@ -281,7 +281,7 @@ 281 281 Mapping table: 282 282 283 283 (% style="width:470.294px" %) 284 -|(% style="width:262px" %)**VTL**|(% style="width:205px" %)**SDMX** 286 +|(% style="width:262px" %)**[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]**|(% style="width:205px" %)**[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]** 285 285 |(% style="width:262px" %)(Simple) Identifier|(% style="width:205px" %)[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] 286 286 |(% style="width:262px" %)(Time) Identifier|(% style="width:205px" %)TimeDimension 287 287 |(% style="width:262px" %)[[Measure>>doc:sdmx:Glossary.Measure.WebHome]]|(% style="width:205px" %)[[Measure>>doc:sdmx:Glossary.Measure.WebHome]] ... ... @@ -314,7 +314,7 @@ 314 314 The summary mapping table of the **unpivot** mapping method is the following: 315 315 316 316 (% style="width:638.294px" %) 317 -|(% style="width:200px" %)**VTL**|(% style="width:435px" %)**SDMX** 319 +|(% style="width:200px" %)**[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]**|(% style="width:435px" %)**[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]** 318 318 |(% style="width:200px" %)(Simple) Identifier|(% style="width:435px" %)[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] 319 319 |(% style="width:200px" %)(Time) Identifier|(% style="width:435px" %)TimeDimension 320 320 |(% style="width:200px" %)All [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] [[Components>>doc:sdmx:Glossary.Component.WebHome]]|(% style="width:435px" %)MeasureDimension (having one [[Code>>doc:sdmx:Glossary.Code.WebHome]] for each [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[measure>>doc:sdmx:Glossary.Measure.WebHome]] [[component>>doc:sdmx:Glossary.Component.WebHome]]) & one [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] ... ... @@ -341,7 +341,7 @@ 341 341 The mapping table is the following: 342 342 343 343 (% style="width:467.294px" %) 344 -|(% style="width:214px" %)VTL|(% style="width:250px" %)SDMX 346 +|(% style="width:214px" %)[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]|(% style="width:250px" %)[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] 345 345 |(% style="width:214px" %)(Simple) Identifier|(% style="width:250px" %)[[Dimension>>doc:sdmx:Glossary.Dimension.WebHome]] 346 346 |(% style="width:214px" %)(Time) Identifier|(% style="width:250px" %)TimeDimension 347 347 |(% style="width:214px" %)Some [[Measures>>doc:sdmx:Glossary.Measure.WebHome]]|(% style="width:250px" %)[[Measure>>doc:sdmx:Glossary.Measure.WebHome]] ... ... @@ -444,8 +444,10 @@ 444 444 445 445 Under these hypothesis, such derived [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] [[Data Sets>>doc:sdmx:Glossary.Data set.WebHome]] can be (% style="color:#e74c3c" %)mapped(%%) to DF2(1.0.0) by declaring the DimensionComponents INDICATOR and COUNTRY as (% style="color:#e74c3c" %)mapping(%%) [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]]{{footnote}}The mapping dimensions are defined as FromVtlSpaceKeys of the FromVtlSuperSpace of the VtlDataflowMapping relevant to DF2(1.0).{{/footnote}}. 446 446 447 -The corresponding [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformations, assuming that the result needs to be persistent, would be of this kind :{{footnote}}the symbol of the VTL persistent assignment is used (<-){{/footnote}}449 +The corresponding [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] Transformations, assuming that the result needs to be persistent, would be of this kind 448 448 451 +:{{footnote}}the symbol of the VTL persistent assignment is used (<-){{/footnote}} 452 + 449 449 > ‘DF2(1.0.0)/INDICATORvalue.COUNTRYvalue’ <- expression 450 450 451 451 Some examples follow, for some specific values of INDICATOR and COUNTRY: ... ... @@ -485,7 +485,7 @@ 485 485 With reference to the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] “model for Variables and Value domains”, the following additional mappings have to be considered: 486 486 487 487 (% style="width:706.294px" %) 488 -|(% style="width:257px" %)VTL|(% style="width:446px" %)SDMX 492 +|(% style="width:257px" %)[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]|(% style="width:446px" %)[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] 489 489 |(% style="width:257px" %)**[[Data Set>>doc:sdmx:Glossary.Data set.WebHome]] [[Component>>doc:sdmx:Glossary.Component.WebHome]]**|(% style="width:446px" %)Although this abstraction exists in [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]], it does not have an explicit definition and correspond to a [[Component>>doc:sdmx:Glossary.Component.WebHome]] (either a DimensionComponent or a [[Measure>>doc:sdmx:Glossary.Measure.WebHome]] or a DataAttribute) belonging to one specific [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]^^43^^ 490 490 |(% style="width:257px" %)**Represented Variable**|(% style="width:446px" %)(% style="color:#e74c3c" %)**Concept**(%%) with a definite [[Representation>>doc:sdmx:Glossary.Representation.WebHome]] 491 491 |(% style="width:257px" %)**Value Domain**|(% style="width:446px" %)((( ... ... @@ -564,8 +564,7 @@ 564 564 The following table describes the default mapping for converting from the [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data types to the [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] basic scalar types. 565 565 566 566 (% style="width:583.294px" %) 567 -|(% style="width:360px" %)SDMX data type 568 -(BasicComponentDataType)|(% style="width:221px" %)Default VTL basic scalar type 571 +|(% style="width:360px" %)[[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]] data type (BasicComponentDataType)|(% style="width:221px" %)Default [[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]] basic scalar type 569 569 |(% style="width:360px" %)((( 570 570 String 571 571 (string allowing any character) ... ... @@ -600,8 +600,7 @@ 600 600 Short 601 601 (corresponds to XML Schema xs:short datatype; between -32768 and -32767 (inclusive)) 602 602 )))|(% style="width:221px" %)integer 603 -|(% style="width:360px" %)[[Decimal>>doc:sdmx:Glossary.Decimals.WebHome]] 604 -(corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:221px" %)number 606 +|(% style="width:360px" %)[[Decimal>>doc:sdmx:Glossary.Decimals.WebHome]] (corresponds to XML Schema xs:[[decimal>>doc:sdmx:Glossary.Decimals.WebHome]] datatype; subset of real numbers that can be represented as [[decimals>>doc:sdmx:Glossary.Decimals.WebHome]])|(% style="width:221px" %)number 605 605 |(% style="width:360px" %)((( 606 606 Float 607 607 (corresponds to XML Schema xs:float datatype; patterned after the IEEE single-precision 32-bit floating point type)