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
-
... ... @@ -14,8 +14,10 @@ 14 14 15 15 The VTL language can be applied to SDMX artefacts by mapping the SDMX IM model artefacts to the model artefacts that VTL can manipulate{{footnote}}In this chapter, in order to distinguish VTL and SDMX model artefacts, the VTL ones are written in the Arial font while the SDMX ones in Courier New{{/footnote}}. Thus, the SDMX artefacts can be used in VTL as inputs and/or outputs of Transformations. It is important to be aware that the artefacts do not always have the same names in the SDMX and VTL IMs, nor do they always have the same meaning. The more evident example is given by the SDMX Dataset and the VTL "Data Set", which do not correspond one another: as a matter of fact, the VTL "Data Set" maps to the SDMX "Dataflow", while the SDMX "Dataset" has no explicit mapping to VTL (such an abstraction is not needed in the definition of VTL Transformations). A SDMX "Dataset", however, is an instance of a SDMX "Dataflow" and can be the artefact on which the VTL transformations are executed (i.e., the Transformations are defined on Dataflows and are applied to Dataflow instances that can be Datasets). 16 16 17 -The VTL programs (Transformation Schemes) are represented in SDMX through the TransformationScheme maintainable class which is composed of Transformation (nameable artefact). Each Transformation assigns the outcome of the evaluation of a VTL expression to a result.17 +The VTL programs (Transformation Schemes) are represented in SDMX through the TransformationScheme maintainable class which is composed of 18 18 19 +Transformation (nameable artefact). Each Transformation assigns the outcome of the evaluation of a VTL expression to a result. 20 + 19 19 This section does not explain the VTL language or any of the content published in the VTL guides. Rather, this is a description of how the VTL can be used in the SDMX context and applied to SDMX artefacts. 20 20 21 21 == 12.2 References to SDMX artefacts from VTL statements == ... ... @@ -241,7 +241,7 @@ 241 241 242 242 AttributeRelationship is not specified (i.e. the DataAttribute does not depend on any DimensionComponent and therefore is at data set level), or if it refers to a set (or a group) of dimensions which does not include the MeasureDimension; 243 243 244 -* 246 +* 245 245 ** Otherwise, if, according to the SDMX AttributeRelationship, the values of the DataAttribute depend on the MeasureDimension, the SDMX DataAttribute is mapped to one VTL Attribute for each possible Code of the SDMX MeasureDimension. By default, the names of the VTL Attributes are obtained by concatenating the name of the SDMX DataAttribute and the names of the correspondent Code of the MeasureDimension separated by underscore. For example, if the SDMX DataAttribute is named DA and the possible Codes of the SDMX MeasureDimension are named C1, C2, …, Cn, then the corresponding VTL Attributes will be named DA_C1, DA_C2, …, DA_Cn (if different names are desired, they can be achieved afterwards by renaming the Attributes through VTL operators). 246 246 ** Like in the Basic mapping, the resulting VTL Attributes are considered as dependent on all the VTL identifiers (i.e. "at data point / observation level"), because VTL does not have the SDMX notion of Attribute Relationship. 247 247 ... ... @@ -578,10 +578,8 @@ 578 578 579 579 Therefore, it is important to be aware that some VTL operations (for example the binary operations at data set level) are consistent only if the components having the same names in the operated VTL Data Sets have also the same representation (i.e. the same Value Domain as for VTL). For example, it is possible to obtain correct results from the VTL expression 580 580 581 -DS_c := DS_a + DS_b (where DS_a, DS_b, DS_c are VTL Data Sets) 583 +DS_c := DS_a + DS_b (where DS_a, DS_b, DS_c are VTL Data Sets) if the matching components in DS_a and DS_b (e.g. ref_date, geo_area, sector …) refer to the same general representation. In simpler words, DS_a and DS_b must use the same values/codes (for ref_date, geo_area, sector … ), otherwise the relevant values would not match and the result of the operation would be wrong. 582 582 583 -if the matching components in DS_a and DS_b (e.g. ref_date, geo_area, sector …) refer to the same general representation. In simpler words, DS_a and DS_b must use the same values/codes (for ref_date, geo_area, sector … ), otherwise the relevant values would not match and the result of the operation would be wrong. 584 - 585 585 As mentioned, the property above is not enforced by construction in SDMX, and different representations of the same Concept can be not compatible one another (for example, it may happen that geo_area is represented by ISO-alpha-3 codes in DS_a and by ISO alpha-2 codes in DS_b). Therefore, it will be up to the definer of VTL 586 586 587 587 Transformations to ensure that the VTL expressions are consistent with the actual representations of the correspondent SDMX Concepts. ... ... @@ -598,8 +598,7 @@ 598 598 599 599 [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_e3df33ae.png||height="543" width="483"]] 600 600 601 -(% class="wikigeneratedid" id="HFigure222013VTLDataTypes" %) 602 -**Figure 22 – VTL Data Types** 601 +==== Figure 22 – VTL Data Types ==== 603 603 604 604 The VTL scalar types are in turn subdivided in basic scalar types, which are elementary (not defined in term of other data types) and Value Domain and Set scalar types, which are defined in terms of the basic scalar types. 605 605 ... ... @@ -606,12 +606,131 @@ 606 606 The VTL basic scalar types are listed below and follow a hierarchical structure in terms of supersets/subsets (e.g. "scalar" is the superset of all the basic scalar types): 607 607 608 608 609 -**Figure 23 – VTL Basic Scalar Types** 610 610 611 611 ((( 612 - 610 +//n// 611 + 612 +//a// 613 + 614 +//e// 615 + 616 +//l// 617 + 618 +//o// 619 + 620 +//o// 621 + 622 +//B// 623 + 624 +//n// 625 + 626 +//o// 627 + 628 +//i// 629 + 630 +//t// 631 + 632 +//a// 633 + 634 +//r// 635 + 636 +//u// 637 + 638 +//D// 639 + 640 +//d// 641 + 642 +//o// 643 + 644 +//i// 645 + 646 +//r// 647 + 648 +//e// 649 + 650 +//p// 651 + 652 +//_// 653 + 654 +//e// 655 + 656 +//m// 657 + 658 +//i// 659 + 660 +//T// 661 + 662 +//e// 663 + 664 +//t// 665 + 666 +//a// 667 + 668 +//D// 669 + 670 +//e// 671 + 672 +//m// 673 + 674 +//i// 675 + 676 +//T// 677 + 678 +//r// 679 + 680 +//e// 681 + 682 +//g// 683 + 684 +//e// 685 + 686 +//t// 687 + 688 +//n// 689 + 690 +//I// 691 + 692 +//r// 693 + 694 +//e// 695 + 696 +//b// 697 + 698 +//m// 699 + 700 +//u// 701 + 702 +//N// 703 + 704 +//g// 705 + 706 +//n// 707 + 708 +//i// 709 + 710 +//r// 711 + 712 +//t// 713 + 714 +//S// 715 + 716 +//r// 717 + 718 +//a// 719 + 720 +//l// 721 + 722 +//a// 723 + 724 +//c// 725 + 726 +//S// 727 + 728 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_82d45833.gif||alt="Shape6" height="231" width="184"]] 613 613 ))) 614 614 731 +==== Figure 23 – VTL Basic Scalar Types ==== 732 + 615 615 === 12.4.2 VTL basic scalar types and SDMX data types === 616 616 617 617 The VTL assumes that a basic scalar type has a unique internal representation and can have more external representations. ... ... @@ -634,159 +634,204 @@ 634 634 635 635 The following table describes the default mapping for converting from the SDMX data types to the VTL basic scalar types. 636 636 637 -(% style="width:823.294px" %) 638 -|(% style="width:509px" %)**SDMX data type (BasicComponentDataType)**|(% style="width:312px" %)**Default VTL basic scalar type** 639 -|(% style="width:509px" %)((( 755 +|SDMX data type (BasicComponentDataType)|Default VTL basic scalar type 756 +|((( 640 640 String 758 + 641 641 (string allowing any character) 642 -)))| (%style="width:312px" %)string643 -|( % style="width:509px" %)(((760 +)))|string 761 +|((( 644 644 Alpha 763 + 645 645 (string which only allows A-z) 646 -)))| (%style="width:312px" %)string647 -|( % style="width:509px" %)(((765 +)))|string 766 +|((( 648 648 AlphaNumeric 768 + 649 649 (string which only allows A-z and 0-9) 650 -)))| (%style="width:312px" %)string651 -|( % style="width:509px" %)(((770 +)))|string 771 +|((( 652 652 Numeric 773 + 653 653 (string which only allows 0-9, but is not numeric so that is can having leading zeros) 654 -)))| (%style="width:312px" %)string655 -|( % style="width:509px" %)(((775 +)))|string 776 +|((( 656 656 BigInteger 778 + 657 657 (corresponds to XML Schema xs:integer datatype; infinite set of integer values) 658 -)))| (% style="width:312px" %)integer659 -|( % style="width:509px" %)(((780 +)))|integer 781 +|((( 660 660 Integer 661 -(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647 (inclusive)) 662 -)))|(% style="width:312px" %)integer 663 -|(% style="width:509px" %)((( 783 + 784 +(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647 785 + 786 +(inclusive)) 787 +)))|integer 788 +|((( 664 664 Long 665 -(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and +9223372036854775807 (inclusive)) 666 -)))|(% style="width:312px" %)integer 667 -|(% style="width:509px" %)((( 790 + 791 +(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and 792 + 793 ++9223372036854775807 (inclusive)) 794 +)))|integer 795 +|((( 668 668 Short 797 + 669 669 (corresponds to XML Schema xs:short datatype; between -32768 and -32767 (inclusive)) 670 -)))| (% style="width:312px" %)integer671 -| (% style="width:509px" %)Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:312px" %)number672 -|( % style="width:509px" %)(((799 +)))|integer 800 +|Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|number 801 +|((( 673 673 Float 803 + 674 674 (corresponds to XML Schema xs:float datatype; patterned after the IEEE single-precision 32-bit floating point type) 675 -)))| (% style="width:312px" %)number676 -|( % style="width:509px" %)(((805 +)))|number 806 +|((( 677 677 Double 808 + 678 678 (corresponds to XML Schema xs:double datatype; patterned after the IEEE double-precision 64-bit floating point type) 679 -)))| (% style="width:312px" %)number680 -|( % style="width:509px" %)(((810 +)))|number 811 +|((( 681 681 Boolean 682 -(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of binary-valued logic: {true, false}) 683 -)))|(% style="width:312px" %)boolean 684 684 685 -(% style="width:822.294px" %) 686 -|(% colspan="2" style="width:507px" %)((( 814 +(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of 815 + 816 +binary-valued logic: {true, false}) 817 +)))|boolean 818 + 819 +| |(% colspan="2" %)((( 687 687 URI 821 + 688 688 (corresponds to the XML Schema xs:anyURI; absolute or relative Uniform Resource Identifier Reference) 689 -)))|(% colspan=" 1"style="width:311px"%)string690 -|(% colspan="2" style="width:507px"%)(((823 +)))|(% colspan="2" %)string 824 +| |(% colspan="2" %)((( 691 691 Count 826 + 692 692 (an integer following a sequential pattern, increasing by 1 for each occurrence) 693 -)))|(% colspan=" 1"style="width:311px"%)integer694 -|(% colspan="2" style="width:507px"%)(((828 +)))|(% colspan="2" %)integer 829 +| |(% colspan="2" %)((( 695 695 InclusiveValueRange 831 + 696 696 (decimal number within a closed interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue) 697 -)))|(% colspan=" 1"style="width:311px"%)number698 -|(% colspan="2" style="width:507px"%)(((833 +)))|(% colspan="2" %)number 834 +| |(% colspan="2" %)((( 699 699 ExclusiveValueRange 836 + 700 700 (decimal number within an open interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue) 701 -)))|(% colspan=" 1"style="width:311px"%)number702 -|(% colspan="2" style="width:507px"%)(((838 +)))|(% colspan="2" %)number 839 +| |(% colspan="2" %)((( 703 703 Incremental 841 + 704 704 (decimal number the increased by a specific interval (defined by the interval facet), which is typically enforced outside of the XML validation) 705 -)))|(% colspan=" 1"style="width:311px"%)number706 -|(% colspan="2" style="width:507px"%)(((843 +)))|(% colspan="2" %)number 844 +| |(% colspan="2" %)((( 707 707 ObservationalTimePeriod 846 + 708 708 (superset of StandardTimePeriod and TimeRange) 709 -)))|(% colspan=" 1"style="width:311px"%)time710 -|(% colspan="2" style="width:507px"%)(((848 +)))|(% colspan="2" %)time 849 +| |(% colspan="2" %)((( 711 711 StandardTimePeriod 712 -(superset of BasicTimePeriod and ReportingTimePeriod) 713 -)))|(% colspan="1" style="width:311px" %)time 714 -|(% colspan="2" style="width:507px" %)((( 851 + 852 +(superset of BasicTimePeriod and 853 + 854 +ReportingTimePeriod) 855 +)))|(% colspan="2" %)time 856 +| |(% colspan="2" %)((( 715 715 BasicTimePeriod 858 + 716 716 (superset of GregorianTimePeriod and DateTime) 717 -)))|(% colspan=" 1"style="width:311px"%)date718 -|(% colspan="2" style="width:507px"%)(((860 +)))|(% colspan="2" %)date 861 +| |(% colspan="2" %)((( 719 719 GregorianTimePeriod 863 + 720 720 (superset of GregorianYear, GregorianYearMonth, and GregorianDay) 721 -)))|(% colspan=" 1"style="width:311px"%)date722 -|(% colspan="2" style="width:507px"%)GregorianYear (YYYY)|(% colspan="1"style="width:311px"%)date723 -|(% colspan="2" style="width:507px"%)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="1"style="width:311px"%)date724 -|(% colspan="2" style="width:507px"%)GregorianDay (YYYY-MM-DD)|(% colspan="1"style="width:311px"%)date725 -|(% colspan="2" style="width:507px"%)(((865 +)))|(% colspan="2" %)date 866 +| |(% colspan="2" %)GregorianYear (YYYY)|(% colspan="2" %)date 867 +| |(% colspan="2" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="2" %)date 868 +| |(% colspan="2" %)GregorianDay (YYYY-MM-DD)|(% colspan="2" %)date 869 +| |(% colspan="2" %)((( 726 726 ReportingTimePeriod 727 -(superset of RepostingYear, ReportingSemester, ReportingTrimester, ReportingQuarter, ReportingMonth, ReportingWeek, ReportingDay) 728 -)))|(% colspan="1" style="width:311px" %)time_period 729 -|(% colspan="2" style="width:507px" %)((( 871 + 872 +(superset of RepostingYear, ReportingSemester, 873 + 874 +ReportingTrimester, ReportingQuarter, 875 + 876 +ReportingMonth, ReportingWeek, ReportingDay) 877 +)))|(% colspan="2" %)time_period 878 +| |(% colspan="2" %)((( 730 730 ReportingYear 880 + 731 731 (YYYY-A1 – 1 year period) 732 -)))|(% colspan=" 1"style="width:311px"%)time_period733 -|(% colspan="2" style="width:507px"%)(((882 +)))|(% colspan="2" %)time_period 883 +| |(% colspan="2" %)((( 734 734 ReportingSemester 885 + 735 735 (YYYY-Ss – 6 month period) 736 -)))|(% colspan=" 1"style="width:311px"%)time_period737 -|(% colspan="2" style="width:507px"%)(((887 +)))|(% colspan="2" %)time_period 888 +| |(% colspan="2" %)((( 738 738 ReportingTrimester 890 + 739 739 (YYYY-Tt – 4 month period) 740 -)))|(% colspan=" 1"style="width:311px"%)time_period741 -|(% colspan="2" style="width:507px"%)(((892 +)))|(% colspan="2" %)time_period 893 +| |(% colspan="2" %)((( 742 742 ReportingQuarter 895 + 743 743 (YYYY-Qq – 3 month period) 744 -)))|(% colspan=" 1"style="width:311px"%)time_period745 -|(% colspan="2" style="width:507px"%)(((897 +)))|(% colspan="2" %)time_period 898 +| |(% colspan="2" %)((( 746 746 ReportingMonth 900 + 747 747 (YYYY-Mmm – 1 month period) 748 -)))|(% colspan="1" style="width:311px" %)time_period 749 -|(% colspan="2" style="width:507px" %)ReportingWeek|(% colspan="1" style="width:311px" %)time_period 750 -|(% colspan="1" style="width:507px" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" style="width:312px" %) 751 -|(% colspan="1" style="width:507px" %)((( 902 +)))|(% colspan="2" %)time_period 903 +| |(% colspan="2" %)ReportingWeek|(% colspan="2" %)time_period 904 +| |(% colspan="2" %) |(% colspan="2" %) 905 +| |(% colspan="2" %) |(% colspan="2" %) 906 +|(% colspan="2" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" %) | 907 +|(% colspan="2" %)((( 752 752 ReportingDay 909 + 753 753 (YYYY-Dddd – 1 day period) 754 -)))|(% colspan="2" style="width:312px"%)time_period755 -|(% colspan=" 1"style="width:507px"%)(((911 +)))|(% colspan="2" %)time_period| 912 +|(% colspan="2" %)((( 756 756 DateTime 914 + 757 757 (YYYY-MM-DDThh:mm:ss) 758 -)))|(% colspan="2" style="width:312px"%)date759 -|(% colspan=" 1"style="width:507px"%)(((916 +)))|(% colspan="2" %)date| 917 +|(% colspan="2" %)((( 760 760 TimeRange 919 + 761 761 (YYYY-MM-DD(Thh:mm:ss)?/<duration>) 762 -)))|(% colspan="2" style="width:312px"%)time763 -|(% colspan=" 1"style="width:507px"%)(((921 +)))|(% colspan="2" %)time| 922 +|(% colspan="2" %)((( 764 764 Month 924 + 765 765 (~-~-MM; speicifies a month independent of a year; e.g. February is black history month in the United States) 766 -)))|(% colspan="2" style="width:312px"%)string767 -|(% colspan=" 1"style="width:507px"%)(((926 +)))|(% colspan="2" %)string| 927 +|(% colspan="2" %)((( 768 768 MonthDay 929 + 769 769 (~-~-MM-DD; specifies a day within a month independent of a year; e.g. Christmas is December 25^^th^^; used to specify reporting year start day) 770 -)))|(% colspan="2" style="width:312px"%)string771 -|(% colspan=" 1"style="width:507px"%)(((931 +)))|(% colspan="2" %)string| 932 +|(% colspan="2" %)((( 772 772 Day 934 + 773 773 (~-~--DD; specifies a day independent of a month or year; e.g. the 15^^th^^ is payday) 774 -)))|(% colspan="2" style="width:312px"%)string775 -|(% colspan=" 1"style="width:507px"%)(((936 +)))|(% colspan="2" %)string| 937 +|(% colspan="2" %)((( 776 776 Time 939 + 777 777 (hh:mm:ss; time independent of a date; e.g. coffee break is at 10:00 AM) 778 -)))|(% colspan="2" style="width:312px"%)string779 -|(% colspan=" 1"style="width:507px"%)(((941 +)))|(% colspan="2" %)string| 942 +|(% colspan="2" %)((( 780 780 Duration 944 + 781 781 (corresponds to XML Schema xs:duration datatype) 782 -)))|(% colspan="2" style="width:312px"%)duration783 -|(% colspan=" 1"style="width:507px"%)XHTML|(% colspan="2"style="width:312px"%)Metadata type – not applicable784 -|(% colspan=" 1"style="width:507px"%)KeyValues|(% colspan="2"style="width:312px"%)Metadata type – not applicable785 -|(% colspan=" 1"style="width:507px"%)IdentifiableReference|(% colspan="2"style="width:312px"%)Metadata type – not applicable786 -|(% colspan=" 1"style="width:507px"%)DataSetReference|(% colspan="2"style="width:312px"%)Metadata type – not applicable946 +)))|(% colspan="2" %)duration| 947 +|(% colspan="2" %)XHTML|(% colspan="2" %)Metadata type – not applicable| 948 +|(% colspan="2" %)KeyValues|(% colspan="2" %)Metadata type – not applicable| 949 +|(% colspan="2" %)IdentifiableReference|(% colspan="2" %)Metadata type – not applicable| 950 +|(% colspan="2" %)DataSetReference|(% colspan="2" %)Metadata type – not applicable| 787 787 788 -(% class="wikigeneratedid" id="HFigure142013MappingsfromSDMXdatatypestoVTLBasicScalarTypes" %) 789 -**Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types** 952 +==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ==== 790 790 791 791 When VTL takes in input SDMX artefacts, it is assumed that a type conversion according to the table above always happens. In case a different VTL basic scalar type is desired, it can be achieved in the VTL program taking in input the default VTL basic scalar type above and applying to it the VTL type conversion features (see the implicit and explicit type conversion and the "cast" operator in the VTL Reference Manual). 792 792 ... ... @@ -794,32 +794,39 @@ 794 794 795 795 The following table describes the default conversion from the VTL basic scalar types to the SDMX data types . 796 796 797 -(% style="width:1073.29px" %) 798 -|(% style="width:207px" %)((( 799 -**VTL basic scalar type** 800 -)))|(% style="width:462px" %)((( 801 -**Default SDMX data type (BasicComponentDataType)** 802 -)))|(% style="width:402px" %)**Default output format** 803 -|(% style="width:207px" %)String|(% style="width:462px" %)String|(% style="width:402px" %)Like XML (xs:string) 804 -|(% style="width:207px" %)Number|(% style="width:462px" %)Float|(% style="width:402px" %)Like XML (xs:float) 805 -|(% style="width:207px" %)Integer|(% style="width:462px" %)Integer|(% style="width:402px" %)Like XML (xs:int) 806 -|(% style="width:207px" %)Date|(% style="width:462px" %)DateTime|(% style="width:402px" %)YYYY-MM-DDT00:00:00Z 807 -|(% style="width:207px" %)Time|(% style="width:462px" %)StandardTimePeriod|(% style="width:402px" %)<date>/<date> (as defined above) 808 -|(% style="width:207px" %)time_period|(% style="width:462px" %)((( 960 +|((( 961 +VTL basic 962 + 963 +scalar type 964 +)))|((( 965 +Default SDMX data type 966 + 967 +(BasicComponentDataType 968 + 969 +) 970 +)))|Default output format 971 +|String|String|Like XML (xs:string) 972 +|Number|Float|Like XML (xs:float) 973 +|Integer|Integer|Like XML (xs:int) 974 +|Date|DateTime|YYYY-MM-DDT00:00:00Z 975 +|Time|StandardTimePeriod|<date>/<date> (as defined above) 976 +|time_period|((( 809 809 ReportingTimePeriod 978 + 810 810 (StandardReportingPeriod) 811 -)))|( % style="width:402px" %)(((980 +)))|((( 812 812 YYYY-Pppp 982 + 813 813 (according to SDMX ) 814 814 ))) 815 -| (% style="width:207px" %)Duration|(% style="width:462px" %)Duration|(% style="width:402px" %)(((985 +|Duration|Duration|((( 816 816 Like XML (xs:duration) 987 + 817 817 PnYnMnDTnHnMnS 818 818 ))) 819 -| (% style="width:207px" %)Boolean|(% style="width:462px" %)Boolean|(% style="width:402px" %)Like XML (xs:boolean) with the values "true" or "false"990 +|Boolean|Boolean|Like XML (xs:boolean) with the values "true" or "false" 820 820 821 -(% class="wikigeneratedid" id="HFigure142013MappingsfromSDMXdatatypestoVTLBasicScalarTypes-1" %) 822 -**Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types** 992 +==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ==== 823 823 824 824 In case a different default conversion is desired, it can be achieved through the CustomTypeScheme and CustomType artefacts (see also the section Transformations and Expressions of the SDMX information model). 825 825 ... ... @@ -873,7 +873,7 @@ 873 873 |N|fixed number of digits used in the preceding textual representation of the month or the day 874 874 | | 875 875 876 -The default conversion, either standard or customized, can be used to deduce automatically the representation of the components of the result of a VTL Transformation. In alternative, the representation of the resulting SDMX Dataflow can be given explicitly by providing its DataStructureDefinition. In other words, the representation specified in the DSD, if available, overrides any default conversion {{footnote}}The representationgiven in theDSDshouldobviouslybecompatible withtheVTLdata type.{{/footnote}}.1046 +The default conversion, either standard or customized, can be used to deduce automatically the representation of the components of the result of a VTL Transformation. In alternative, the representation of the resulting SDMX Dataflow can be given explicitly by providing its DataStructureDefinition. In other words, the representation specified in the DSD, if available, overrides any default conversion^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^42^^>>path:#sdfootnote42sym||name="sdfootnote42anc"]](%%)^^. 877 877 878 878 === 12.4.5 Null Values === 879 879 ... ... @@ -891,8 +891,10 @@ 891 891 892 892 A different format can be specified in the attribute "vtlLiteralFormat" of the CustomType artefact (see also the section Transformations and Expressions of the SDMX information model). 893 893 894 -Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain VTL basic scalar type, if a value is found for the vtlLiteralFormat attribute of the CustomType of such VTL basic scalar type. The overriding assumption is applied for all the literals of a related VTL TransformationScheme.1064 +Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain VTL basic scalar type, if a value is found for the vtlLiteralFormat attribute of the CustomType of such VTL basic scalar type. The overriding assumption is applied for all the literals of a related VTL 895 895 1066 +TransformationScheme. 1067 + 896 896 In case a literal is operand of a VTL Cast operation, the format specified in the Cast overrides all the possible otherwise specified formats. 897 897 898 898 {{putFootnotes/}}