Skip to Content
Last modified by Helena on 2025/09/10 11:19
From version 5.27
edited by Helena
on 2025/05/16 09:08
Change comment: There is no comment for this version
To version 5.25
edited by Helena
on 2025/05/16 09:01
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -243,7 +243,7 @@
243 243  
244 244  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;
245 245  
246 -*
246 +*
247 247  ** 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).
248 248  ** 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.
249 249  
... ... @@ -636,159 +636,204 @@
636 636  
637 637  The following table describes the default mapping for converting from the SDMX data types to the VTL basic scalar types.
638 638  
639 -(% style="width:823.294px" %)
640 -|(% style="width:509px" %)**SDMX data type (BasicComponentDataType)**|(% style="width:312px" %)**Default VTL basic scalar type**
641 -|(% style="width:509px" %)(((
639 +|SDMX data type (BasicComponentDataType)|Default VTL basic scalar type
640 +|(((
642 642  String
642 +
643 643  (string allowing any character)
644 -)))|(% style="width:312px" %)string
645 -|(% style="width:509px" %)(((
644 +)))|string
645 +|(((
646 646  Alpha
647 +
647 647  (string which only allows A-z)
648 -)))|(% style="width:312px" %)string
649 -|(% style="width:509px" %)(((
649 +)))|string
650 +|(((
650 650  AlphaNumeric
652 +
651 651  (string which only allows A-z and 0-9)
652 -)))|(% style="width:312px" %)string
653 -|(% style="width:509px" %)(((
654 +)))|string
655 +|(((
654 654  Numeric
657 +
655 655  (string which only allows 0-9, but is not numeric so that is can having leading zeros)
656 -)))|(% style="width:312px" %)string
657 -|(% style="width:509px" %)(((
659 +)))|string
660 +|(((
658 658  BigInteger
662 +
659 659  (corresponds to XML Schema xs:integer datatype; infinite set of integer values)
660 -)))|(% style="width:312px" %)integer
661 -|(% style="width:509px" %)(((
664 +)))|integer
665 +|(((
662 662  Integer
663 -(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647 (inclusive))
664 -)))|(% style="width:312px" %)integer
665 -|(% style="width:509px" %)(((
667 +
668 +(corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647
669 +
670 +(inclusive))
671 +)))|integer
672 +|(((
666 666  Long
667 -(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and +9223372036854775807 (inclusive))
668 -)))|(% style="width:312px" %)integer
669 -|(% style="width:509px" %)(((
674 +
675 +(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and
676 +
677 ++9223372036854775807 (inclusive))
678 +)))|integer
679 +|(((
670 670  Short
681 +
671 671  (corresponds to XML Schema xs:short datatype; between -32768 and -32767 (inclusive))
672 -)))|(% style="width:312px" %)integer
673 -|(% style="width:509px" %)Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:312px" %)number
674 -|(% style="width:509px" %)(((
683 +)))|integer
684 +|Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|number
685 +|(((
675 675  Float
687 +
676 676  (corresponds to XML Schema xs:float datatype; patterned after the IEEE single-precision 32-bit floating point type)
677 -)))|(% style="width:312px" %)number
678 -|(% style="width:509px" %)(((
689 +)))|number
690 +|(((
679 679  Double
692 +
680 680  (corresponds to XML Schema xs:double datatype; patterned after the IEEE double-precision 64-bit floating point type)
681 -)))|(% style="width:312px" %)number
682 -|(% style="width:509px" %)(((
694 +)))|number
695 +|(((
683 683  Boolean
684 -(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of binary-valued logic: {true, false})
685 -)))|(% style="width:312px" %)boolean
686 686  
687 -(% style="width:822.294px" %)
688 -|(% colspan="2" style="width:507px" %)(((
698 +(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of
699 +
700 +binary-valued logic: {true, false})
701 +)))|boolean
702 +
703 +| |(% colspan="2" %)(((
689 689  URI
705 +
690 690  (corresponds to the XML Schema xs:anyURI; absolute or relative Uniform Resource Identifier Reference)
691 -)))|(% colspan="1" style="width:311px" %)string
692 -|(% colspan="2" style="width:507px" %)(((
707 +)))|(% colspan="2" %)string
708 +| |(% colspan="2" %)(((
693 693  Count
710 +
694 694  (an integer following a sequential pattern, increasing by 1 for each occurrence)
695 -)))|(% colspan="1" style="width:311px" %)integer
696 -|(% colspan="2" style="width:507px" %)(((
712 +)))|(% colspan="2" %)integer
713 +| |(% colspan="2" %)(((
697 697  InclusiveValueRange
715 +
698 698  (decimal number within a closed interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue)
699 -)))|(% colspan="1" style="width:311px" %)number
700 -|(% colspan="2" style="width:507px" %)(((
717 +)))|(% colspan="2" %)number
718 +| |(% colspan="2" %)(((
701 701  ExclusiveValueRange
720 +
702 702  (decimal number within an open interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue)
703 -)))|(% colspan="1" style="width:311px" %)number
704 -|(% colspan="2" style="width:507px" %)(((
722 +)))|(% colspan="2" %)number
723 +| |(% colspan="2" %)(((
705 705  Incremental
725 +
706 706  (decimal number the increased by a specific interval (defined by the interval facet), which is typically enforced outside of the XML validation)
707 -)))|(% colspan="1" style="width:311px" %)number
708 -|(% colspan="2" style="width:507px" %)(((
727 +)))|(% colspan="2" %)number
728 +| |(% colspan="2" %)(((
709 709  ObservationalTimePeriod
730 +
710 710  (superset of StandardTimePeriod and TimeRange)
711 -)))|(% colspan="1" style="width:311px" %)time
712 -|(% colspan="2" style="width:507px" %)(((
732 +)))|(% colspan="2" %)time
733 +| |(% colspan="2" %)(((
713 713  StandardTimePeriod
714 -(superset of BasicTimePeriod and ReportingTimePeriod)
715 -)))|(% colspan="1" style="width:311px" %)time
716 -|(% colspan="2" style="width:507px" %)(((
735 +
736 +(superset of BasicTimePeriod and
737 +
738 +ReportingTimePeriod)
739 +)))|(% colspan="2" %)time
740 +| |(% colspan="2" %)(((
717 717  BasicTimePeriod
742 +
718 718  (superset of GregorianTimePeriod and DateTime)
719 -)))|(% colspan="1" style="width:311px" %)date
720 -|(% colspan="2" style="width:507px" %)(((
744 +)))|(% colspan="2" %)date
745 +| |(% colspan="2" %)(((
721 721  GregorianTimePeriod
747 +
722 722  (superset of GregorianYear, GregorianYearMonth, and GregorianDay)
723 -)))|(% colspan="1" style="width:311px" %)date
724 -|(% colspan="2" style="width:507px" %)GregorianYear (YYYY)|(% colspan="1" style="width:311px" %)date
725 -|(% colspan="2" style="width:507px" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="1" style="width:311px" %)date
726 -|(% colspan="2" style="width:507px" %)GregorianDay (YYYY-MM-DD)|(% colspan="1" style="width:311px" %)date
727 -|(% colspan="2" style="width:507px" %)(((
749 +)))|(% colspan="2" %)date
750 +| |(% colspan="2" %)GregorianYear (YYYY)|(% colspan="2" %)date
751 +| |(% colspan="2" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="2" %)date
752 +| |(% colspan="2" %)GregorianDay (YYYY-MM-DD)|(% colspan="2" %)date
753 +| |(% colspan="2" %)(((
728 728  ReportingTimePeriod
729 -(superset of RepostingYear, ReportingSemester, ReportingTrimester, ReportingQuarter, ReportingMonth, ReportingWeek, ReportingDay)
730 -)))|(% colspan="1" style="width:311px" %)time_period
731 -|(% colspan="2" style="width:507px" %)(((
755 +
756 +(superset of RepostingYear, ReportingSemester,
757 +
758 +ReportingTrimester, ReportingQuarter,
759 +
760 +ReportingMonth, ReportingWeek, ReportingDay)
761 +)))|(% colspan="2" %)time_period
762 +| |(% colspan="2" %)(((
732 732  ReportingYear
764 +
733 733  (YYYY-A1 – 1 year period)
734 -)))|(% colspan="1" style="width:311px" %)time_period
735 -|(% colspan="2" style="width:507px" %)(((
766 +)))|(% colspan="2" %)time_period
767 +| |(% colspan="2" %)(((
736 736  ReportingSemester
769 +
737 737  (YYYY-Ss – 6 month period)
738 -)))|(% colspan="1" style="width:311px" %)time_period
739 -|(% colspan="2" style="width:507px" %)(((
771 +)))|(% colspan="2" %)time_period
772 +| |(% colspan="2" %)(((
740 740  ReportingTrimester
774 +
741 741  (YYYY-Tt – 4 month period)
742 -)))|(% colspan="1" style="width:311px" %)time_period
743 -|(% colspan="2" style="width:507px" %)(((
776 +)))|(% colspan="2" %)time_period
777 +| |(% colspan="2" %)(((
744 744  ReportingQuarter
779 +
745 745  (YYYY-Qq – 3 month period)
746 -)))|(% colspan="1" style="width:311px" %)time_period
747 -|(% colspan="2" style="width:507px" %)(((
781 +)))|(% colspan="2" %)time_period
782 +| |(% colspan="2" %)(((
748 748  ReportingMonth
784 +
749 749  (YYYY-Mmm – 1 month period)
750 -)))|(% colspan="1" style="width:311px" %)time_period
751 -|(% colspan="2" style="width:507px" %)ReportingWeek|(% colspan="1" style="width:311px" %)time_period
752 -|(% 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" %)
753 -|(% colspan="1" style="width:507px" %)(((
786 +)))|(% colspan="2" %)time_period
787 +| |(% colspan="2" %)ReportingWeek|(% colspan="2" %)time_period
788 +| |(% colspan="2" %) |(% colspan="2" %)
789 +| |(% colspan="2" %) |(% colspan="2" %)
790 +|(% colspan="2" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" %) |
791 +|(% colspan="2" %)(((
754 754  ReportingDay
793 +
755 755  (YYYY-Dddd – 1 day period)
756 -)))|(% colspan="2" style="width:312px" %)time_period
757 -|(% colspan="1" style="width:507px" %)(((
795 +)))|(% colspan="2" %)time_period|
796 +|(% colspan="2" %)(((
758 758  DateTime
798 +
759 759  (YYYY-MM-DDThh:mm:ss)
760 -)))|(% colspan="2" style="width:312px" %)date
761 -|(% colspan="1" style="width:507px" %)(((
800 +)))|(% colspan="2" %)date|
801 +|(% colspan="2" %)(((
762 762  TimeRange
803 +
763 763  (YYYY-MM-DD(Thh:mm:ss)?/<duration>)
764 -)))|(% colspan="2" style="width:312px" %)time
765 -|(% colspan="1" style="width:507px" %)(((
805 +)))|(% colspan="2" %)time|
806 +|(% colspan="2" %)(((
766 766  Month
808 +
767 767  (~-~-MM; speicifies a month independent of a year; e.g. February is black history month in the United States)
768 -)))|(% colspan="2" style="width:312px" %)string
769 -|(% colspan="1" style="width:507px" %)(((
810 +)))|(% colspan="2" %)string|
811 +|(% colspan="2" %)(((
770 770  MonthDay
813 +
771 771  (~-~-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)
772 -)))|(% colspan="2" style="width:312px" %)string
773 -|(% colspan="1" style="width:507px" %)(((
815 +)))|(% colspan="2" %)string|
816 +|(% colspan="2" %)(((
774 774  Day
818 +
775 775  (~-~--DD; specifies a day independent of a month or year; e.g. the 15^^th^^ is payday)
776 -)))|(% colspan="2" style="width:312px" %)string
777 -|(% colspan="1" style="width:507px" %)(((
820 +)))|(% colspan="2" %)string|
821 +|(% colspan="2" %)(((
778 778  Time
823 +
779 779  (hh:mm:ss; time independent of a date; e.g. coffee break is at 10:00 AM)
780 -)))|(% colspan="2" style="width:312px" %)string
781 -|(% colspan="1" style="width:507px" %)(((
825 +)))|(% colspan="2" %)string|
826 +|(% colspan="2" %)(((
782 782  Duration
828 +
783 783  (corresponds to XML Schema xs:duration datatype)
784 -)))|(% colspan="2" style="width:312px" %)duration
785 -|(% colspan="1" style="width:507px" %)XHTML|(% colspan="2" style="width:312px" %)Metadata type – not applicable
786 -|(% colspan="1" style="width:507px" %)KeyValues|(% colspan="2" style="width:312px" %)Metadata type – not applicable
787 -|(% colspan="1" style="width:507px" %)IdentifiableReference|(% colspan="2" style="width:312px" %)Metadata type – not applicable
788 -|(% colspan="1" style="width:507px" %)DataSetReference|(% colspan="2" style="width:312px" %)Metadata type – not applicable
830 +)))|(% colspan="2" %)duration|
831 +|(% colspan="2" %)XHTML|(% colspan="2" %)Metadata type – not applicable|
832 +|(% colspan="2" %)KeyValues|(% colspan="2" %)Metadata type – not applicable|
833 +|(% colspan="2" %)IdentifiableReference|(% colspan="2" %)Metadata type – not applicable|
834 +|(% colspan="2" %)DataSetReference|(% colspan="2" %)Metadata type – not applicable|
789 789  
790 -(% class="wikigeneratedid" id="HFigure142013MappingsfromSDMXdatatypestoVTLBasicScalarTypes" %)
791 -**Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types**
836 +==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ====
792 792  
793 793  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).
794 794  
... ... @@ -796,29 +796,37 @@
796 796  
797 797  The following table describes the default conversion from the VTL basic scalar types to the SDMX data types .
798 798  
799 -(% style="width:1073.29px" %)
800 -|(% style="width:207px" %)(((
801 -**VTL basic scalar type**
802 -)))|(% style="width:462px" %)(((
803 -**Default SDMX data type (BasicComponentDataType)**
804 -)))|(% style="width:402px" %)**Default output format**
805 -|(% style="width:207px" %)String|(% style="width:462px" %)String|(% style="width:402px" %)Like XML (xs:string)
806 -|(% style="width:207px" %)Number|(% style="width:462px" %)Float|(% style="width:402px" %)Like XML (xs:float)
807 -|(% style="width:207px" %)Integer|(% style="width:462px" %)Integer|(% style="width:402px" %)Like XML (xs:int)
808 -|(% style="width:207px" %)Date|(% style="width:462px" %)DateTime|(% style="width:402px" %)YYYY-MM-DDT00:00:00Z
809 -|(% style="width:207px" %)Time|(% style="width:462px" %)StandardTimePeriod|(% style="width:402px" %)<date>/<date> (as defined above)
810 -|(% style="width:207px" %)time_period|(% style="width:462px" %)(((
844 +|(((
845 +VTL basic
846 +
847 +scalar type
848 +)))|(((
849 +Default SDMX data type
850 +
851 +(BasicComponentDataType
852 +
853 +)
854 +)))|Default output format
855 +|String|String|Like XML (xs:string)
856 +|Number|Float|Like XML (xs:float)
857 +|Integer|Integer|Like XML (xs:int)
858 +|Date|DateTime|YYYY-MM-DDT00:00:00Z
859 +|Time|StandardTimePeriod|<date>/<date> (as defined above)
860 +|time_period|(((
811 811  ReportingTimePeriod
862 +
812 812  (StandardReportingPeriod)
813 -)))|(% style="width:402px" %)(((
864 +)))|(((
814 814  YYYY-Pppp
866 +
815 815  (according to SDMX )
816 816  )))
817 -|(% style="width:207px" %)Duration|(% style="width:462px" %)Duration|(% style="width:402px" %)(((
869 +|Duration|Duration|(((
818 818  Like XML (xs:duration)
871 +
819 819  PnYnMnDTnHnMnS
820 820  )))
821 -|(% style="width:207px" %)Boolean|(% style="width:462px" %)Boolean|(% style="width:402px" %)Like XML (xs:boolean) with the values "true" or "false"
874 +|Boolean|Boolean|Like XML (xs:boolean) with the values "true" or "false"
822 822  
823 823  ==== Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types ====
824 824  
... ... @@ -874,7 +874,7 @@
874 874  |N|fixed number of digits used in the preceding textual representation of the month or the day
875 875  | |
876 876  
877 -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 wikiinternallink" %)^^42^^>>path:#sdfootnote42sym||name="sdfootnote42anc"]](%%)^^.
930 +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"]](%%)^^.
878 878  
879 879  === 12.4.5 Null Values ===
880 880