Changes for page 12 Validation and Transformation Language (VTL)
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -206,20 +206,18 @@ 206 206 207 207 The main mapping method from SDMX to VTL is called **Basic **mapping. This is considered as the default mapping method and is applied unless a different method is specified through the VtlMappingScheme and VtlDataflowMapping classes. When transforming **from SDMX to VTL**, this method consists in leaving the components unchanged and maintaining their names and roles, according to the following table: 208 208 209 -|**SDMX**|**VTL** 210 -|Dimension|(Simple) Identifier 211 -|TimeDimension|(Time) Identifier 209 +(% style="width:529.294px" %) 210 +|(% style="width:151px" %)**SDMX**|(% style="width:375px" %)**VTL** 211 +|(% style="width:151px" %)Dimension|(% style="width:375px" %)(Simple) Identifier 212 +|(% style="width:151px" %)TimeDimension|(% style="width:375px" %)(Time) Identifier 213 +|(% style="width:151px" %)Measure|(% style="width:375px" %)Measure 214 +|(% style="width:151px" %)DataAttribute|(% style="width:375px" %)Attribute 212 212 213 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape4" height="1" width="192"]] 214 - 215 -|Measure|Measure 216 -|DataAttribute|Attribute 217 - 218 218 The SDMX DataAttributes, in VTL they are all considered "at data point / observation level" (i.e. dependent on all the VTL Identifiers), because VTL does not have the SDMX AttributeRelationships, which defines the construct to which the DataAttribute is related (e.g. observation, dimension or set or group of dimensions, whole data set). 219 219 220 220 With the Basic mapping, one SDMX observation^^27^^ generates one VTL data point. 221 221 222 - **12.3.3.2 Pivot Mapping**220 +==== 12.3.3.2 Pivot Mapping ==== 223 223 224 224 An alternative mapping method from SDMX to VTL is the **Pivot **mapping, which makes sense and is different from the Basic method only for the SDMX data structures that contain a Dimension that plays the role of measure dimension (like in SDMX 2.1) and just one Measure. Through this method, these structures can be mapped to multimeasure VTL data structures. Besides that, a user may choose to use any Dimension acting as a list of Measures (e.g., a Dimension with indicators), either by considering the “Measure” role of a Dimension, or at will using any coded Dimension. Of course, in SDMX 3.0, this can only work when only one Measure is defined in the DSD. 225 225