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.26
edited by Helena
on 2025/05/16 09:02
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,189 @@
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 +|(% style="width:501px" %)SDMX data type (BasicComponentDataType)|(% style="width:1437px" %)Default VTL basic scalar type
640 +|(% style="width:501px" %)(((
642 642  String
643 643  (string allowing any character)
644 -)))|(% style="width:312px" %)string
645 -|(% style="width:509px" %)(((
643 +)))|(% style="width:1437px" %)string
644 +|(% style="width:501px" %)(((
646 646  Alpha
647 647  (string which only allows A-z)
648 -)))|(% style="width:312px" %)string
649 -|(% style="width:509px" %)(((
647 +)))|(% style="width:1437px" %)string
648 +|(% style="width:501px" %)(((
650 650  AlphaNumeric
651 651  (string which only allows A-z and 0-9)
652 -)))|(% style="width:312px" %)string
653 -|(% style="width:509px" %)(((
651 +)))|(% style="width:1437px" %)string
652 +|(% style="width:501px" %)(((
654 654  Numeric
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" %)(((
655 +)))|(% style="width:1437px" %)string
656 +|(% style="width:501px" %)(((
658 658  BigInteger
659 659  (corresponds to XML Schema xs:integer datatype; infinite set of integer values)
660 -)))|(% style="width:312px" %)integer
661 -|(% style="width:509px" %)(((
659 +)))|(% style="width:1437px" %)integer
660 +|(% style="width:501px" %)(((
662 662  Integer
663 663  (corresponds to XML Schema xs:int datatype; between -2147483648 and +2147483647 (inclusive))
664 -)))|(% style="width:312px" %)integer
665 -|(% style="width:509px" %)(((
663 +)))|(% style="width:1437px" %)integer
664 +|(% style="width:501px" %)(((
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" %)(((
666 +(corresponds to XML Schema xs:long datatype; between -9223372036854775808 and
667 +
668 ++9223372036854775807 (inclusive))
669 +)))|(% style="width:1437px" %)integer
670 +|(% style="width:501px" %)(((
670 670  Short
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" %)(((
673 +)))|(% style="width:1437px" %)integer
674 +|(% style="width:501px" %)Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:1437px" %)number
675 +|(% style="width:501px" %)(((
675 675  Float
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" %)(((
678 +)))|(% style="width:1437px" %)number
679 +|(% style="width:501px" %)(((
679 679  Double
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" %)(((
682 +)))|(% style="width:1437px" %)number
683 +|(% style="width:501px" %)(((
683 683  Boolean
684 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 +)))|(% style="width:1437px" %)boolean
686 686  
687 -(% style="width:822.294px" %)
688 -|(% colspan="2" style="width:507px" %)(((
688 +| |(% colspan="2" %)(((
689 689  URI
690 +
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" %)(((
692 +)))|(% colspan="2" %)string
693 +| |(% colspan="2" %)(((
693 693  Count
695 +
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" %)(((
697 +)))|(% colspan="2" %)integer
698 +| |(% colspan="2" %)(((
697 697  InclusiveValueRange
700 +
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" %)(((
702 +)))|(% colspan="2" %)number
703 +| |(% colspan="2" %)(((
701 701  ExclusiveValueRange
705 +
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" %)(((
707 +)))|(% colspan="2" %)number
708 +| |(% colspan="2" %)(((
705 705  Incremental
710 +
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" %)(((
712 +)))|(% colspan="2" %)number
713 +| |(% colspan="2" %)(((
709 709  ObservationalTimePeriod
715 +
710 710  (superset of StandardTimePeriod and TimeRange)
711 -)))|(% colspan="1" style="width:311px" %)time
712 -|(% colspan="2" style="width:507px" %)(((
717 +)))|(% colspan="2" %)time
718 +| |(% colspan="2" %)(((
713 713  StandardTimePeriod
714 -(superset of BasicTimePeriod and ReportingTimePeriod)
715 -)))|(% colspan="1" style="width:311px" %)time
716 -|(% colspan="2" style="width:507px" %)(((
720 +
721 +(superset of BasicTimePeriod and
722 +
723 +ReportingTimePeriod)
724 +)))|(% colspan="2" %)time
725 +| |(% colspan="2" %)(((
717 717  BasicTimePeriod
727 +
718 718  (superset of GregorianTimePeriod and DateTime)
719 -)))|(% colspan="1" style="width:311px" %)date
720 -|(% colspan="2" style="width:507px" %)(((
729 +)))|(% colspan="2" %)date
730 +| |(% colspan="2" %)(((
721 721  GregorianTimePeriod
732 +
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" %)(((
734 +)))|(% colspan="2" %)date
735 +| |(% colspan="2" %)GregorianYear (YYYY)|(% colspan="2" %)date
736 +| |(% colspan="2" %)GregorianYearMonth / GregorianMonth (YYYY-MM)|(% colspan="2" %)date
737 +| |(% colspan="2" %)GregorianDay (YYYY-MM-DD)|(% colspan="2" %)date
738 +| |(% 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" %)(((
740 +
741 +(superset of RepostingYear, ReportingSemester,
742 +
743 +ReportingTrimester, ReportingQuarter,
744 +
745 +ReportingMonth, ReportingWeek, ReportingDay)
746 +)))|(% colspan="2" %)time_period
747 +| |(% colspan="2" %)(((
732 732  ReportingYear
749 +
733 733  (YYYY-A1 – 1 year period)
734 -)))|(% colspan="1" style="width:311px" %)time_period
735 -|(% colspan="2" style="width:507px" %)(((
751 +)))|(% colspan="2" %)time_period
752 +| |(% colspan="2" %)(((
736 736  ReportingSemester
754 +
737 737  (YYYY-Ss – 6 month period)
738 -)))|(% colspan="1" style="width:311px" %)time_period
739 -|(% colspan="2" style="width:507px" %)(((
756 +)))|(% colspan="2" %)time_period
757 +| |(% colspan="2" %)(((
740 740  ReportingTrimester
759 +
741 741  (YYYY-Tt – 4 month period)
742 -)))|(% colspan="1" style="width:311px" %)time_period
743 -|(% colspan="2" style="width:507px" %)(((
761 +)))|(% colspan="2" %)time_period
762 +| |(% colspan="2" %)(((
744 744  ReportingQuarter
764 +
745 745  (YYYY-Qq – 3 month period)
746 -)))|(% colspan="1" style="width:311px" %)time_period
747 -|(% colspan="2" style="width:507px" %)(((
766 +)))|(% colspan="2" %)time_period
767 +| |(% colspan="2" %)(((
748 748  ReportingMonth
769 +
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" %)(((
771 +)))|(% colspan="2" %)time_period
772 +| |(% colspan="2" %)ReportingWeek|(% colspan="2" %)time_period
773 +| |(% colspan="2" %) |(% colspan="2" %)
774 +| |(% colspan="2" %) |(% colspan="2" %)
775 +|(% colspan="2" %)(YYYY-Www – 7 day period; following ISO 8601 definition of a week in a year)|(% colspan="2" %) |
776 +|(% colspan="2" %)(((
754 754  ReportingDay
778 +
755 755  (YYYY-Dddd – 1 day period)
756 -)))|(% colspan="2" style="width:312px" %)time_period
757 -|(% colspan="1" style="width:507px" %)(((
780 +)))|(% colspan="2" %)time_period|
781 +|(% colspan="2" %)(((
758 758  DateTime
783 +
759 759  (YYYY-MM-DDThh:mm:ss)
760 -)))|(% colspan="2" style="width:312px" %)date
761 -|(% colspan="1" style="width:507px" %)(((
785 +)))|(% colspan="2" %)date|
786 +|(% colspan="2" %)(((
762 762  TimeRange
788 +
763 763  (YYYY-MM-DD(Thh:mm:ss)?/<duration>)
764 -)))|(% colspan="2" style="width:312px" %)time
765 -|(% colspan="1" style="width:507px" %)(((
790 +)))|(% colspan="2" %)time|
791 +|(% colspan="2" %)(((
766 766  Month
793 +
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" %)(((
795 +)))|(% colspan="2" %)string|
796 +|(% colspan="2" %)(((
770 770  MonthDay
798 +
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" %)(((
800 +)))|(% colspan="2" %)string|
801 +|(% colspan="2" %)(((
774 774  Day
803 +
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" %)(((
805 +)))|(% colspan="2" %)string|
806 +|(% colspan="2" %)(((
778 778  Time
808 +
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" %)(((
810 +)))|(% colspan="2" %)string|
811 +|(% colspan="2" %)(((
782 782  Duration
813 +
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
815 +)))|(% colspan="2" %)duration|
816 +|(% colspan="2" %)XHTML|(% colspan="2" %)Metadata type – not applicable|
817 +|(% colspan="2" %)KeyValues|(% colspan="2" %)Metadata type – not applicable|
818 +|(% colspan="2" %)IdentifiableReference|(% colspan="2" %)Metadata type – not applicable|
819 +|(% 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**
821 +==== 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" %)(((
829 +|(((
830 +VTL basic
831 +
832 +scalar type
833 +)))|(((
834 +Default SDMX data type
835 +
836 +(BasicComponentDataType
837 +
838 +)
839 +)))|Default output format
840 +|String|String|Like XML (xs:string)
841 +|Number|Float|Like XML (xs:float)
842 +|Integer|Integer|Like XML (xs:int)
843 +|Date|DateTime|YYYY-MM-DDT00:00:00Z
844 +|Time|StandardTimePeriod|<date>/<date> (as defined above)
845 +|time_period|(((
811 811  ReportingTimePeriod
847 +
812 812  (StandardReportingPeriod)
813 -)))|(% style="width:402px" %)(((
849 +)))|(((
814 814  YYYY-Pppp
851 +
815 815  (according to SDMX )
816 816  )))
817 -|(% style="width:207px" %)Duration|(% style="width:462px" %)Duration|(% style="width:402px" %)(((
854 +|Duration|Duration|(((
818 818  Like XML (xs:duration)
856 +
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"
859 +|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"]](%%)^^.
915 +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