Skip to Content

Changes for page 10 Constraints

Last modified by Helena K. on 2026/06/10 09:45
From version 8.6
edited by Helena K.
on 2026/06/10 09:44
Change comment: There is no comment for this version
To version 1.1
edited by Helena K.
on 2025/06/16 12:03
Change comment: There is no comment for this version

Summary

Details

Page properties
Tags
... ... @@ -1,1 +1,0 @@
1 -Age|Artefact|Attribute|Code|Code list|Comment|Component|Data set|Data structure definition|Dataflow|Dimension|Maintainable artefact|Measure|Member selection|Metadata set|Metadata structure definition|Metadataflow|Observation value|Provision agreement|Reference metadata|Series key|Sex|Statistical data and metadata exchange|Time period
Content
... ... @@ -2,318 +2,317 @@
2 2  {{toc/}}
3 3  {{/box}}
4 4  
5 -== 10.1 Introduction ==
5 +1.
6 +11. Introduction
6 6  
8 +Constraints are used as a way to restrict what data can be reported, or to report what data exists in a given context.  There are three types of Constraint, which serve different purposes
7 7  
8 -[[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are used as a way to restrict what data can be reported, or to report what data exists in a given context.  There are three types of [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], which serve different purposes
10 +* Availability Constraint
11 +* Dimension Constraint
12 +* Reporting Constraints
9 9  
10 -* Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]
11 -* [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]
12 -* Reporting [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]
14 +An Availability Constraint defines the data that exists in the context of a data query.
13 13  
14 -An Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] defines the data that exists in the context of a data query.
16 +They form part of the response message from the Availability REST API. Availability Constraints are dynamically generated by a system based on the data that exists and the query context.  Availability Constraints are therefore not Identifiable structures (they have no URN).
15 15  
16 -They form part of the response message from the Availability REST API. Availability [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are dynamically generated by a system based on the data that exists and the query context.  Availability [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are therefore not Identifiable structures (they have no URN).
18 +A Dimension Constraint is a property of a Dataflow, they are used to fix the Dimensions that they use in the Data Structure Definition which they use. Dimension Constraints enable Data Structure Definitions to evolve over time by having new Dimensions added, without having to undergo a major version change. 
17 17  
18 -A [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is a property of a [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]], they are used to fix the [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] that they use in the [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] which they use. [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] enable [[Data Structure Definitions>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] to evolve over time by having new [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] added, without having to undergo a major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change. 
20 +A Reporting Constraint is used to define the set of allowed and/or disallowed values that can be reported in a data or metadata set.
19 19  
20 -A Reporting [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is used to define the set of allowed and/or disallowed values that can be reported in a data or [[metadata set>>doc:sdmx:Glossary 2\.1.Metadata set.WebHome]].
22 +1.
23 +11. Availability Constraint
21 21  
22 -== 10.2 Availability Constraint ==
25 +An Availability Constraint is not a maintained structure, instead it is generated dynamically as a response to the availability REST API. The purpose of the Availability Constraint is to define the distinct set of values that have data over 1 or more Dimensions.  Unlike a Data and Metadata Constraint, which can attach to multiple Constrainable structures (of the same type), an Availability Constraint can only attach to only one structure.  The attachment defines the context of the response (data exists for components in the context of).  The subset of Constrainable structures the Availability Constraint can attach to are:
23 23  
24 -An Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is not a maintained structure, instead it is generated dynamically as a response to the availability REST API. The purpose of the Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is to define the distinct set of values that have data over 1 or more [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].  Unlike a Data and Metadata [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], which can attach to multiple Constrainable structures (of the same type), an Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can only attach to only one structure.  The attachment defines the context of the response (data exists for [[components>>doc:sdmx:Glossary 2\.1.Component.WebHome]] in the context of).  The subset of Constrainable structures the Availability [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can attach to are:
27 +* Data Structure Definition
28 +* Dataflow
29 +* Provision Agreement
30 +*1. Dimension Constraint
25 25  
26 -* [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]
27 -* [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]
28 -* [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]
32 +A Dimension Constraint is a property of a Dataflow; its purpose is to explicitly list the Dimensions from the corresponding DSD that are being used by the Dataflow. 
29 29  
30 -== 10.3 Dimension Constraint ==
34 +Dimension Constraints were introduced in SDMX 3.1 and are not required for most Dataflows where the dataset must always contain the full complement of Dimensions as defined by the corresponding DSD. However, for some complex data collections, which may span long periods and where the full complement of required Dimensions are not necessarily known at design time, the DSD is subject to increasing its Dimensionality over time.  In this scenario it is possible to define the DSD as an evolving structure, this property tells the user that the DSD can have new Dimensions added without having to undergo a major version change; a DSD at version 1.0.0 for example would be able to add a new Dimension and move to version 1.1.0; a change that would not ordinarily be allowed.  A minor version change on the addition of a new Dimension is only possible if the DSD defines itself as an evolving structure.   This is a new property of the DSD introduced in version 3.1 to satisfy this use case.  The evolving structure  property is either true or false, defaulting to false if not specified.  Setting the evolving structure property to true requires a major version change, and therefore can only be introduced on an x.0.0 release (e.g. 1.0.0).  The evolving structure property can be set to false to indicate that there will be no additional Dimensions added to the Data Structure under the same major version number; setting the evolving structure property to false does not require require a major version change on the Data Structure.  
31 31  
32 -A [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is a property of a [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]; its purpose is to explicitly list the [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] from the corresponding [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] that are being used by the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]. 
36 +When a Dataflow references a DSD, late binding on the minor release, and the DSD has the evolving structure property set to true, then the Dataflow must contain a Dimension Constraint to protect its Dimensionality from changing over time without a version change. 
33 33  
38 +The Dimension Constraint provides the explicit list of Dimensions that the Dataflow uses from the DSD that it references.  This enables the DSD to evolve over time without breaking the compatibility of datasets against the Dataflow. 
34 34  
35 -[[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] were introduced in [[SDMX>>doc:sdmx:Glossary 2\.1.Statistical data and metadata exchange.WebHome]] 3.1 and are not required for most [[Dataflows>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] where the [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] must always contain the full complement of [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] as defined by the  corresponding [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]. However, for some complex data collections, which may span long periods and where the full complement of required [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] are not necessarily known at design time, the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] is subject to increasing its Dimensionality over time.  In this scenario it is possible to define the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] as an evolving structure, this property tells the user that the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] can have new [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] added without having to undergo a major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change; a [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] at [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] 1.0.0 for example would be able to add a new [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] and move to [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] 1.1.0; a change that would not ordinarily be allowed.  A minor [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change on the addition of a new [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] is only possible if the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] defines itself as an evolving structure.   This is a new property of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] introduced in [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] 3.1 to satisfy this use case.  The evolving structure  property is either true or false, defaulting to false if not specified.  Setting the evolving structure property to true requires a major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change, and therefore can only be introduced on an x.0.0 release (e.g. 1.0.0).  The evolving structure property can be set to false to indicate that there will be no additional [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] added to the Data Structure under the same major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] number; setting the evolving structure property to false does not require require a major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change on the Data Structure.   
40 +==== Rules for a Dimension Constraint ====
36 36  
37 -When a [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] references a [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]], late binding on the minor release, and the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] has the evolving structure property set to true, then the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] must contain a [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] to protect its Dimensionality from changing over time without a [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change. 
42 +* A Dataflow must contain a Dimension Constraint if the DSD which it uses states that it is an evolving structure and the Dataflow is late binding on the minor release (latest minor release of a given major version, e.g. 1.0+.0)
43 +* The Dimension Constraint can only include Dimensions from the DSD that is referenced by the Dataflow.
44 +* A Dimension Constraint can only be changed if the Dataflow undergoes a major version change
45 +* Datasets reported against the Dataflow must only contain reported values for the Dimensions specified in the Dimension Constraint. 
46 +* When exporting data for the Dataflow, the dataset should only include the Dimensions specified by the Dimension Constraint.
47 +* When exporting data for the DSD the dataset must contain the full set of Dimensions as specified by the DSD. The tilde ‘~~’ character is used to represent a value which is not present due to the Dimension not being included in the corresponding Dataflow.
38 38  
39 -The [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] provides the explicit list of [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] that the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] uses from the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] that it references.  This enables the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] to evolve over time without breaking the compatibility of [[datasets>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] against the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]. 
49 +==== Example Datasets with Evolving Structures ====
40 40  
41 -__**Rules for a Dimension Constraint**__
51 +A dataset is built against a Data Structure Definition.  The dataset contains data for two Dataflows.  Dataflows ‘DF_POP’ uses a Dimension Constraint which fixes its Dimensions to  FREQ and REF_AREA.  Dataflow ‘DF_POP_SA’ does not reference a
42 42  
43 -* A [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] must contain a [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] if the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] which it uses states that it is an evolving structure and the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] is late binding on the minor release (latest minor release of a given major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]], e.g. 1.0+.0)
44 -* The [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can only include [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] from the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] that is referenced by the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]].
45 -* A [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can only be changed if the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] undergoes a major [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] change
46 -* [[Datasets>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] reported against the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] must only contain reported values for the [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] specified in the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]. 
47 -* When exporting data for the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]], the [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] should only include the [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] specified by the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]].
48 -* When exporting data for the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] the [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] must contain the full set of [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] as specified by the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]. The tilde ‘’ character is used to represent a value which is not present due to the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] not being included in the corresponding [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]].
53 +Dimension Constraint, and as such includes all Dimensions as specified by the DSD.  
49 49  
50 -__**Example Datasets with Evolving Structures**__
55 +The resulting dataset contains values ‘~~’ for both the SEX and AGE Dimension for the series related to DF_POP.
51 51  
52 -A [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] is built against a [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].  The [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] contains data for two [[Dataflows>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]].  [[Dataflows>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] ‘DF_POP’ uses a [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] which fixes its [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to  FREQ and REF_AREA.  [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] ‘DF_POP_SA’ does not reference a [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], and as such includes all [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] as specified by the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].  
53 53  
54 -The resulting [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] contains values ‘’ for both the [[SEX>>doc:sdmx:Glossary 2\.1.Sex.WebHome]] and [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] for the [[series>>doc:sdmx:Glossary 2\.1.Series.WebHome]] related to DF_POP.
58 +|**Dataflow**|(% colspan="7" %)**FREQ REF_AREA SEX AGE OBS_VALUE TIME_PERIOD UNIT**
59 +|**DF_POP**|A|UK|~~|~~|65|2022|6
60 +|**DF_POP**|A|FR|~~|~~|50|2022|6
61 +|**DF_POP_SA**|A|UK|M|1|1.2|2022|6
55 55  
56 -(% style="width:758.294px" %)
57 -|(% style="width:119px" %)**Dataflow**|(% colspan="7" style="width:635px" %)**FREQ REF_AREA SEX AGE OBS_VALUE TIME_PERIOD UNIT**
58 -|(% style="width:119px" %)**DF_POP**|(% style="width:55px" %)A|(% style="width:103px" %)UK|(% style="width:79px" %) |(% style="width:92px" %) |(% style="width:93px" %)65|(% style="width:111px" %)2022|(% style="width:101px" %)6
59 -|(% style="width:119px" %)**DF_POP**|(% style="width:55px" %)A|(% style="width:103px" %)FR|(% style="width:79px" %) |(% style="width:92px" %) |(% style="width:93px" %)50|(% style="width:111px" %)2022|(% style="width:101px" %)6
60 -|(% style="width:119px" %)**DF_POP_SA**|(% style="width:55px" %)A|(% style="width:103px" %)UK|(% style="width:79px" %)M|(% style="width:92px" %)1|(% style="width:93px" %)1.2|(% style="width:111px" %)2022|(% style="width:101px" %)6
63 +1.
64 +11. Reporting Constraints
61 61  
62 -== 10.4 Reporting Constraints ==
66 +A Reporting Constraint is a Maintainable Artefact which restricts the values that can be reported in a dataset or metadata set based on one or more inclusion or exclusion rules. 
63 63  
64 -A Reporting [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is a [[Maintainable Artefact>>doc:sdmx:Glossary 2\.1.Maintainable artefact.WebHome]] which restricts the values that can be reported in a [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]] or [[metadata set>>doc:sdmx:Glossary 2\.1.Metadata set.WebHome]] based on one or more inclusion or exclusion rules. 
68 +A reporting constraint is one of the following concrete types:
65 65  
66 -A reporting [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is one of the following concrete types:
70 +* Data Constraint
71 +* Metadata Constraint
72 +*1.
73 +*11. Data Constraint
67 67  
68 -* Data [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]
69 -* Metadata [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]]
75 +A Data Constraint is used to add additional restrictions to the allowable values reported in a dataset.  Data Constraints can be applied to the follow structures which are collectively known as Constrainable structures:
70 70  
71 -=== 10.4.1 Data Constraint ===
77 +* Data Structure Definition
78 +* Dataflow
79 +* Provision Agreement
80 +* Data Provider
72 72  
73 -A Data [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is used to add additional restrictions to the allowable values reported in a [[dataset>>doc:sdmx:Glossary 2\.1.Data set.WebHome]].  Data [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can be applied to the follow structures which are collectively known as Constrainable structures:
82 +**Note** regardless of the Constrainable structure, the restricted values relate to  the allowable content for the Component of the DSD to which the constrained object relates. 
74 74  
75 -* [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]
76 -* [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]
77 -* [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]
78 -* [[Data Provider>>doc:sdmx:Glossary 2\.1.Data provider.WebHome]]
84 +1.
85 +11.
86 +111. Metadata Constraint
79 79  
80 -**Note** regardless of the Constrainable structure, the restricted values relate to  the allowable content for the [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] to which the constrained object relates. 
88 +A Metadata Constraint is used to add additional restrictions to the allowable values reported in a metadataset.  Metadata Constraints can be applied to the follow structures which are collectively known as Constrainable structures:
81 81  
82 -=== 10.4.2 Metadata Constraint ===
83 -
84 -A Metadata [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is used to add additional restrictions to the allowable values reported in a metadataset.  Metadata [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can be applied to the follow structures which are collectively known as Constrainable structures:
85 -
86 -* [[Metadata Structure Definition>>doc:sdmx:Glossary 2\.1.Metadata structure definition.WebHome]]
87 -* [[Metadataflow>>doc:sdmx:Glossary 2\.1.Metadataflow.WebHome]]
88 -* Metadata [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]
90 +* Metadata Structure Definition
91 +* Metadataflow
92 +* Metadata Provision Agreement
89 89  * Metadata Provider
90 90  
91 -**Note** regardless of the Constrainable structure,  the restricted values relate to  the allowable content for the [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] of the [[MSD>>doc:sdmx:Glossary 2\.1.Metadata structure definition.WebHome]] to which the constrained object relates. 
95 +**Note** regardless of the Constrainable structure,  the restricted values relate to  the allowable content for the Component of the MSD to which the constrained object relates. 
92 92  
93 -=== 10.4.3 Scope of a Constraint ===
97 +1.
98 +11.
99 +111. Scope of a Constraint
94 94  
95 -A [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is used specify the content of a data or metadata source in terms of the [[component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] values or the keys.
101 +A Constraint is used specify the content of a data or metadata source in terms of the component values or the keys.
96 96  
97 -In terms of data the [[components>>doc:sdmx:Glossary 2\.1.Component.WebHome]] are:
103 +In terms of data the components are:
98 98  
99 -* [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]
100 -* Time [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]
101 -* Data [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]
102 -* [[Measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]]
103 -* Metadata [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]
104 -* DataKeySets: the keys are the content of the KeyDescriptor – i.e., the [[series keys>>doc:sdmx:Glossary 2\.1.Series key.WebHome]] composed, for each key, by a value for each [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].
105 +* Dimension
106 +* Time Dimension
107 +* Data Attribute
108 +* Measure
109 +* Metadata Attribute
110 +* DataKeySets: the keys are the content of the KeyDescriptor – i.e., the series keys composed, for each key, by a value for each Dimension.
105 105  
106 -In terms of [[reference metadata>>doc:sdmx:Glossary 2\.1.Reference metadata.WebHome]] the [[components>>doc:sdmx:Glossary 2\.1.Component.WebHome]] are:
112 +In terms of reference metadata the components are:
107 107  
108 -* Metadata [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]
114 +* Metadata Attribute
109 109  
110 -For a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] based on a [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can reference one or more of:
116 +For a Constraint based on a DSD the Constraint can reference one or more of:
111 111  
112 -* [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]
113 -* [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]
114 -* [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]
115 -* [[Data Provider>>doc:sdmx:Glossary 2\.1.Data provider.WebHome]]
118 +* Data Structure Definition
119 +* Dataflow
120 +* Provision Agreement
121 +* Data Provider
116 116  
117 -For a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] based on an [[MSD>>doc:sdmx:Glossary 2\.1.Metadata structure definition.WebHome]] the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can reference one or more of:
123 +For a Constraint based on an MSD the Constraint can reference one or more of:
118 118  
119 -* [[Metadata Structure Definition>>doc:sdmx:Glossary 2\.1.Metadata structure definition.WebHome]]
120 -* [[Metadataflow>>doc:sdmx:Glossary 2\.1.Metadataflow.WebHome]]
121 -* Metadata [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]
125 +* Metadata Structure Definition
126 +* Metadataflow
127 +* Metadata Provision Agreement
122 122  * Metadata Provider
123 -* [[Metadata Set>>doc:sdmx:Glossary 2\.1.Metadata set.WebHome]]
129 +* Metadata Set
124 124  
125 -Furthermore, there can be more than one [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified for a specific object e.g., more than one [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] for a specific [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
131 +Furthermore, there can be more than one Constraint specified for a specific object e.g., more than one Constraint for a specific DSD.
126 126  
127 -In view of the flexibility of [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] attachment, clear rules on their usage are required. These are elaborated below.
133 +In view of the flexibility of constraints attachment, clear rules on their usage are required. These are elaborated below.
128 128  
129 -=== 10.4.4 Multiple Constraints ===
135 +1.
136 +11.
137 +111. Multiple Constraints
130 130  
131 -There can be many [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] for any Constrainable [[Artefact>>doc:sdmx:Glossary 2\.1.Artefact.WebHome]] (e.g., [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]), subject to the following restrictions:
139 +There can be many Constraints for any Constrainable Artefact (e.g., DSD), subject to the following restrictions:
132 132  
133 -==== 10.4.4.1 Cube Region ====
141 +**10.4.4.1 Cube Region**
134 134  
135 -A [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] can contain multiple [[Member Selections>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] (e.g., [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]).
143 +A Constraint can contain multiple Member Selections (e.g., Dimensions).
136 136  
137 -* A specific [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] (e.g., [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] FREQ) can only be contained in one Cube Region for any one attached object (e.g., a specific [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] or specific [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]).
138 -* [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]] values within a [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] may define a validity period. Otherwise, the value is valid for the whole validity of the Cube Region.
139 -* For partial reference resolution purposes (as per the [[SDMX>>doc:sdmx:Glossary 2\.1.Statistical data and metadata exchange.WebHome]] REST API), the latest non-draft [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] must be considered.
140 -* A [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] may include wildcarding of values (using character ‘%’ to represent zero or more occurrences of any character), as well as cascading through hierarchic structures (e.g., parents in [[Codelist>>doc:sdmx:Glossary 2\.1.Code list.WebHome]]), or localised values (e.g., text for English only). Lack of locale means any [[language>>doc:sdmx:Glossary 2\.1.Language.WebHome]] may match. Cascading values are mutual exclusive to localised values, as the former refer to coded values, while the latter refer to uncoded values.
141 -* Any values included in a [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] for [[Components>>doc:sdmx:Glossary 2\.1.Component.WebHome]] with an array data type (i.e., [[Measures>>doc:sdmx:Glossary 2\.1.Measure.WebHome]], [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] or Metadata [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]), will be applied as single values and will not be assessed combined with other values to match all possible array values. For example, including the [[Code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] ‘A’ for an [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] will allow any instance of the [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] that includes ‘A’, like [‘A’, ‘B’] or [‘A’, ‘C’, ‘D’]. Similarly, if [[Code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] ‘A’ was excluded, all those arrays of values would also be excluded.
145 +* A specific Member Selection (e.g., Dimension FREQ) can only be contained in one Cube Region for any one attached object (e.g., a specific DSD or specific Dataflow).
146 +* Component values within a Member Selection may define a validity period. Otherwise, the value is valid for the whole validity of the Cube Region.
147 +* For partial reference resolution purposes (as per the SDMX REST API), the latest non-draft Constraint must be considered.
148 +* A Member Selection may include wildcarding of values (using character ‘%’ to represent zero or more occurrences of any character), as well as cascading through hierarchic structures (e.g., parents in Codelist), or localised values (e.g., text for English only). Lack of locale means any language may match. Cascading values are mutual exclusive to localised values, as the former refer to coded values, while the latter refer to uncoded values.
149 +* Any values included in a Member Selection for Components with an array data type (i.e., Measures, Attributes or Metadata Attributes), will be applied as single values and will not be assessed combined with other values to match all possible array values. For example, including the Code ‘A’ for an Attribute will allow any instance of the Attribute that includes ‘A’, like [‘A’, ‘B’] or [‘A’, ‘C’, ‘D’]. Similarly, if Code ‘A’ was excluded, all those arrays of values would also be excluded.
142 142  
143 -==== 10.4.4.2 Key Set ====
151 +**10.4.4.2 Key Set**
144 144  
145 -Key Sets will be processed in the order they appear in the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] and wildcards can be used (e.g., any key position not reference explicitly is deemed to be "all values").
153 +Key Sets will be processed in the order they appear in the Constraint and wildcards can be used (e.g., any key position not reference explicitly is deemed to be "all values").
146 146  
147 -As the Key Sets can be "included" or "excluded" it is recommended that Key Sets with wildcards are declared before KeySets with specific [[series keys>>doc:sdmx:Glossary 2\.1.Series key.WebHome]]. This will minimize the risk that keys are inadvertently included or excluded.
155 +As the Key Sets can be "included" or "excluded" it is recommended that Key Sets with wildcards are declared before KeySets with specific series keys. This will minimize the risk that keys are inadvertently included or excluded.
148 148  
149 -In addition, [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]], [[Measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]] and Metadata [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] may accompany KeySets, in order to specify the allowed values per Key. Those are expressed following the rules for Cube Regions, as explained above.
157 +In addition, Attribute, Measure and Metadata Attribute constraints may accompany KeySets, in order to specify the allowed values per Key. Those are expressed following the rules for Cube Regions, as explained above.
150 150  
151 151  Finally, a validity period may be specified per Key.
152 152  
153 -=== 10.4.4 Versioning ===
161 +1.
162 +11.
163 +111. Versioning
154 154  
155 -When Data and Metadata [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are versioned, the latest [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] of the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is used to generate the reporting restriction rules; all previous [[versions>>doc:sdmx:Glossary 2\.1.Version.WebHome]] are for historical information only.
165 +When Data and Metadata Constraints are versioned, the latest version of the Constraint is used to generate the reporting restriction rules; all previous versions are for historical information only.
156 156  
157 -If restrictions are applicable to certain periods in time, the validFrom and validTo properties can be set on the specific values. This allows [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] to evolve over time, increasing their [[version>>doc:sdmx:Glossary 2\.1.Version.WebHome]] number as they do so, whilst being able to maintain a complete set of reporting restrictions for current and past [[datasets>>doc:sdmx:Glossary 2\.1.Data set.WebHome]].
167 +If restrictions are applicable to certain periods in time, the validFrom and validTo properties can be set on the specific values. This allows Constraints to evolve over time, increasing their version number as they do so, whilst being able to maintain a complete set of reporting restrictions for current and past datasets.
158 158  
159 159  Example:
160 160  
161 161  Data Constraint 1.0.0
162 162  
163 -(% style="width:573.294px" %)
164 -|(% style="width:108px" %)Component|(% style="width:127px" %)Valid Value|(% style="width:150px" %)Valid from|(% style="width:185px" %)Valid to
165 -|(% rowspan="3" style="width:108px" %)COUNTRY|(% style="width:127px" %)UK|(% style="width:150px" %) |(% style="width:185px" %)
166 -|(% style="width:127px" %)FR|(% style="width:150px" %) |(% style="width:185px" %)
167 -|(% style="width:127px" %)DE|(% style="width:150px" %) |(% style="width:185px" %)
173 +|Component|Valid Value|Valid from|Valid to
174 +|(% rowspan="3" %)COUNTRY|UK| |
175 +|FR| |
176 +|DE| |
168 168  
169 169  Data Constraint 1.1.0
170 170  
171 -(% style="width:576.294px" %)
172 -|(% style="width:110px" %)Component|(% style="width:129px" %)Valid Value|(% style="width:145px" %)Valid from|(% style="width:189px" %)Valid to
173 -|(% rowspan="3" style="width:110px" %)COUNTRY|(% style="width:129px" %)UK|(% style="width:145px" %) |(% style="width:189px" %)
174 -|(% style="width:129px" %)FR|(% style="width:145px" %) |(% style="width:189px" %)2012
175 -|(% style="width:129px" %)DE|(% style="width:145px" %) |(% style="width:189px" %)
180 +|Component|Valid Value|Valid from|Valid to
181 +|(% rowspan="3" %)COUNTRY|UK| |
182 +|FR| |2012
183 +|DE| |
176 176  
177 -When both [[versions>>doc:sdmx:Glossary 2\.1.Version.WebHome]] of the Data [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are in a system, an [[observation value>>doc:sdmx:Glossary 2\.1.Observation value.WebHome]] reported against COUNTRY FR for [[time period>>doc:sdmx:Glossary 2\.1.Time period.WebHome]] 2013 would be deemed invalid as the 1.1.0 rule would be applied.
185 +When both versions of the Data Constraint are in a system, an observation value reported against COUNTRY FR for time period 2013 would be deemed invalid as the 1.1.0 rule would be applied.
178 178  
179 -=== 10.4.6 Inheritance ===
187 +1.
188 +11.
189 +111. Inheritance
180 180  
181 -==== 10.4.6.1 Attachment levels of a Constraint ====
191 +**10.4.6.1 Attachment levels of a Constraint**
182 182  
183 -There are three [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]] of [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] attachment for which these inheritance rules apply:
193 +There are three levels of constraint attachment for which these inheritance rules apply:
184 184  
185 -* [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]/[[MSD>>doc:sdmx:Glossary 2\.1.Metadata structure definition.WebHome]] – top [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]]
186 -** [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]/[[Metadataflow>>doc:sdmx:Glossary 2\.1.Metadataflow.WebHome]] – second [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]]
187 -*** [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] – third [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]]
195 +• DSD/MSD – top level o Dataflow/Metadataflow – second level
188 188  
189 -It is not necessary for a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] to be attached to a higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[artefact>>doc:sdmx:Glossary 2\.1.Artefact.WebHome]]. e.g., it is valid to have a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] for a [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] where there are no [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] attached the relevant [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] or [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
197 +§ Provision Agreement – third level
190 190  
191 -==== 10.4.6.2 Cascade rules for processing Constraints ====
199 +It is not necessary for a Constraint to be attached to a higher level artefact. e.g., it is valid to have a Constraint for a Provision Agreement where there are no constraints attached the relevant Dataflow or DSD.
192 192  
193 -The processing of the [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] on either [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]/[[Metadataflow>>doc:sdmx:Glossary 2\.1.Metadataflow.WebHome]] or [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] must take into account the [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] declared at higher [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]]. The rules for the lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] (attached to [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]/ [[Metadataflow>>doc:sdmx:Glossary 2\.1.Metadataflow.WebHome]] and [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]]) are detailed below.
201 +**10.4.6.2 Cascade rules for processing Constraints**
194 194  
195 -Note that there can be a situation where a [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is specified at a lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] before a [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is specified at a higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]]. Therefore, it is possible that a higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] makes a lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] invalid. [[SDMX>>doc:sdmx:Glossary 2\.1.Statistical data and metadata exchange.WebHome]] makes no rules on how such a conflict should be handled when processing the [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] for attachment. However, the cascade rules on evaluating [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] for usage are clear – the higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] takes precedence in any conflicts that result in a less restrictive specification at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]].
203 +The processing of the constraints on either Dataflow/Metadataflow or Provision Agreement must take into account the constraints declared at higher levels. The rules for the lower-level constraints (attached to Dataflow/ Metadataflow and Provision Agreement) are detailed below.
196 196  
197 -==== 10.4.6.3 Cube Region ====
205 +Note that there can be a situation where a constraint is specified at a lower level before a constraint is specified at a higher level. Therefore, it is possible that a higher-level constraint makes a lower-level constraint invalid. SDMX makes no rules on how such a conflict should be handled when processing the constraint for attachment. However, the cascade rules on evaluating constraints for usage are clear – the higher-level constraint takes precedence in any conflicts that result in a less restrictive specification at the lower level.
198 198  
199 -It is not necessary to have a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] on the higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[artefact>>doc:sdmx:Glossary 2\.1.Artefact.WebHome]] (e.g., [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] referenced by the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]), but if there is such a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]](s) then:
207 +**10.4.6.3 Cube Region**
200 200  
201 -* The lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] cannot be less restrictive than the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified for the same [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] (e.g. [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]) at the next higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]], which constrains that [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]]. For example, if the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] FREQ is constrained to A, Q in a [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]], then the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] or [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] cannot be A, Q, M or even just M – it can only further constrain A, Q.
202 -* The [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] for any one [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] further constrains the content for the same [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]](s).
203 -* Any [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]], which is not referenced in a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], is deemed to be constrained according to the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified at the next higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] which [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] that [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]].
204 -* If there is a conflict when resolving the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] in terms of a lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] being less restrictive than a higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], then the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] is used.
209 +It is not necessary to have a Constraint on the higher-level artefact (e.g., DSD referenced by the Dataflow), but if there is such a Constraint at the higher level(s) then:
205 205  
206 -Note that it is possible for a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at a higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] to constrain, say, four [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] in a single [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], and a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at a lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] to constrain the same four in two, three, or four [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]].
211 +* The lower-level Constraint cannot be less restrictive than the Constraint specified for the same Member Selection (e.g. Dimension) at the next higher level, which constrains that Member Selection. For example, if the Dimension FREQ is constrained to A, Q in a DSD, then the Constraint at the Dataflow or Provision Agreement cannot be A, Q, M or even just M – it can only further constrain A, Q.
212 +* The Constraint at the lower level for any one Member Selection further constrains the content for the same Member Selection at the higher level(s).
213 +* Any Member Selection, which is not referenced in a Constraint, is deemed to be constrained according to the Constraint specified at the next higher level which constraints that Member Selection.
214 +* If there is a conflict when resolving the Constraint in terms of a lower-level Constraint being less restrictive than a higher-level Constraint, then the Constraint at the higher-level is used.
207 207  
208 -==== 10.4.6.4 Key Set ====
216 +Note that it is possible for a Constraint at a higher level to constrain, say, four Dimensions in a single Constraint, and a Constraint at a lower level to constrain the same four in two, three, or four Constraints.
209 209  
210 -It is not necessary to have a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] on the higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[artefact>>doc:sdmx:Glossary 2\.1.Artefact.WebHome]] (e.g., [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] referenced by the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]), but if there is such a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]](s) then:
218 +**10.4.6.4 Key Set**
211 211  
212 -* The lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] cannot be less restrictive than the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]].
213 -* The [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] for any one [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]] further constrains the keys specified at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]](s).
214 -* Any [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]], which is not referenced in a [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], is deemed to be constrained according to the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified at the next higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] which [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] that [[Member Selection>>doc:sdmx:Glossary 2\.1.Member selection.WebHome]].
215 -* If there is a conflict when resolving the keys in the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] at two [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]], in terms of a lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] being less restrictive than a higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], then the offending keys specified at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] are not deemed part of the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]].
220 +It is not necessary to have a Constraint on the higher-level artefact (e.g., DSD referenced by the Dataflow), but if there is such a Constraint at the higher level(s) then:
216 216  
217 -Note that a Key in a Key Set can have wildcarded [[Components>>doc:sdmx:Glossary 2\.1.Component.WebHome]]. For instance, the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] may simply constrain the [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] FREQ to "A", and all keys where the FREQ="A" are therefore valid.
222 +* The lower-level Constraint cannot be less restrictive than the Constraint specified at the higher level.
223 +* The Constraint at the lower level for any one Member Selection further constrains the keys specified at the higher level(s).
224 +* Any Member Selection, which is not referenced in a Constraint, is deemed to be constrained according to the Constraint specified at the next higher level which constraints that Member Selection.
225 +* If there is a conflict when resolving the keys in the Constraint at two levels, in terms of a lower-level constraint being less restrictive than a higher-level Constraint, then the offending keys specified at the lower level are not deemed part of the Constraint.
218 218  
227 +Note that a Key in a Key Set can have wildcarded Components. For instance, the Constraint may simply constrain the Dimension FREQ to "A", and all keys where the FREQ="A" are therefore valid.
228 +
219 219  The following logic explains how the inheritance mechanism works. Note that this is conceptual logic and actual systems may differ in the way this is implemented.
220 220  
221 -1. Determine all possible keys that are valid at the higher [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]].
222 -1. These keys are deemed to be inherited by the lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] constrained object, subject to the [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]].
223 -1. Determine all possible keys that are possible using the [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] specified at the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]].
224 -1. At the lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] inherit all keys that match with the higher-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]].
225 -1. If there are keys in the lower-[[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] that are not inherited then the key is invalid (i.e., it is less restrictive).
231 +1.
232 +11. Determine all possible keys that are valid at the higher level.
233 +11. These keys are deemed to be inherited by the lower-level constrained object, subject to the Constraints specified at the lower level.
234 +11. Determine all possible keys that are possible using the Constraints specified at the lower level.
235 +11. At the lower level inherit all keys that match with the higher-level Constraint.
236 +11. If there are keys in the lower-level Constraint that are not inherited then the key is invalid (i.e., it is less restrictive).
237 +111. Constraints Examples
226 226  
227 -=== 10.4.7 Constraints Examples ===
239 +**10.4.7.1 Data Constraint and Cascading **The following scenario is used.
228 228  
229 -==== 10.4.7.1 Data Constraint and Cascading ====
241 +A DSD contains the following Dimensions:
230 230  
231 -The following scenario is used.
232 -
233 -A [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] contains the following [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]:
234 -
235 235  * GEO – Geography
236 -* [[SEX>>doc:sdmx:Glossary 2\.1.Sex.WebHome]] – [[Sex>>doc:sdmx:Glossary 2\.1.Sex.WebHome]]
237 -* [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] – [[Age>>doc:sdmx:Glossary 2\.1.Age.WebHome]]
244 +* SEX – Sex
245 +* AGE – Age
238 238  * CAS – Current Activity Status
239 239  
240 -In the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]], common [[code lists>>doc:sdmx:Glossary 2\.1.Code list.WebHome]] are used and the requirement is to restrict these at various [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]] to specify the actual [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] that are valid for the object to which the [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] is attached.
248 +In the DSD, common code lists are used and the requirement is to restrict these at various levels to specify the actual code that are valid for the object to which the Constraint is attached.
241 241  
242 -[[image:1750065279010-260.png]]
243 243  
244 -**Figure 20: Example Scenario for Constraints **
251 +**Figure 20: Example Scenario for Constraints **Constraints are declared as follows:
245 245  
246 -[[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are declared as follows:
247 247  
248 -[[image:1750065319060-899.png]]
249 -
250 250  **Figure 21: Example Constraints**
251 251  
252 252  Notes:
253 253  
254 -[[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] is constrained for the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] and is further restricted for the [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE1.
258 +AGE is constrained for the DSD and is further restricted for the Dataflow CENSUS_CUBE1.
255 255  
256 -* The same [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] applies to both [[Provision Agreements>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]].
260 +* The same Constraint applies to both Provision Agreements.
257 257  
258 258  The cascade rules elaborated above result as follows:
259 259  
260 -[[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]]
264 +DSD
261 261  
262 -* Constrained by eliminating [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] 001 from the [[code list>>doc:sdmx:Glossary 2\.1.Code list.WebHome]] for the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].
266 +* Constrained by eliminating code 001 from the code list for the AGE Dimension.
263 263  
264 -[[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE1
268 +Dataflow CENSUS_CUBE1
265 265  
266 -* Constrained by restricting the [[code list>>doc:sdmx:Glossary 2\.1.Code list.WebHome]] for the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] 002 and 003 (note that this is a more restrictive [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] than that declared for the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] which specifies all [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] except [[code>>doc:sdmx:Glossary 2\.1.Code.WebHome]] 001).
267 -** Restricts the CAS [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] to 003 and 004.
270 +* Constrained by restricting the code list for the AGE Dimension to codes 002 and 003 (note that this is a more restrictive constraint than that declared for the DSD which specifies all codes except code 001).
271 +** Restricts the CAS codes to 003 and 004.
268 268  
269 -[[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE2
273 +Dataflow CENSUS_CUBE2
270 270  
271 -* Restricts the [[code list>>doc:sdmx:Glossary 2\.1.Code list.WebHome]] for the CAS [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] TOT and NAP.
272 -** Inherits the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] applied at the level of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
275 +* Restricts the code list for the CAS Dimension to codes TOT and NAP.
276 +** Inherits the AGE constraint applied at the level of the DSD.
273 273  
274 -[[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE1_IT
278 +Provision Agreement CENSUS_CUBE1_IT
275 275  
276 -* Restricts the [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] for the GEO [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to IT and its children.
277 -** Inherits the [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] from [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE1 for the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] and CAS [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].
280 +* Restricts the codes for the GEO Dimension to IT and its children.
281 +** Inherits the constraints from Dataflow CENSUS_CUBE1 for the AGE and CAS Dimensions.
278 278  
279 -[[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE2_IT
280 280  
281 -* Restricts the [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] for the GEO [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to IT and its children.
282 -** Inherits the [[constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] from [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE2 for the CAS [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].
283 -** Inherits the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] [[constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] applied at the [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
284 284  
285 -The [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are defined as follows:
285 +Provision Agreement CENSUS_CUBE2_IT
286 286  
287 -DSD Constraint
287 +* Restricts the codes for the GEO Dimension to IT and its children.
288 +** Inherits the constraints from Dataflow CENSUS_CUBE2 for the CAS Dimension.
289 +** Inherits the AGE constraint applied at the level of the DSD.
288 288  
289 -[[image:1750065367824-357.png]]
291 +The Constraints are defined as follows:
290 290  
293 +DSD Constraint
294 +
291 291  Dataflow Constraints
292 292  
293 -[[image:1750065392163-400.png]]
294 -
295 295  Provision Agreement Constraint
296 296  
297 -[[image:1750065461589-995.png]]
298 -
299 299  **10.4.7.2 Combination of Constraints**
300 300  
301 301  The possible combination of constraining terms are explained in this section, following a few examples.
302 302  
303 -Let’s assume a [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] with the following [[Components>>doc:sdmx:Glossary 2\.1.Component.WebHome]]:
303 +Let’s assume a DSD with the following Components:
304 304  
305 -(% style="width:459.294px" %)
306 -|(% style="width:204px" %)(% style="color:#3498db" %)[[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:252px" %)(% style="color:#3498db" %)FREQ
307 -|(% style="width:204px" %)(% style="color:#3498db" %)[[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:252px" %)(% style="color:#3498db" %)JD_TYPE
308 -|(% style="width:204px" %)(% style="color:#3498db" %)[[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:252px" %)(% style="color:#3498db" %)JD_CATEGORY
309 -|(% style="width:204px" %)(% style="color:#3498db" %)[[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]|(% style="width:252px" %)(% style="color:#3498db" %)VIS_CTY
310 -|(% style="width:204px" %)(% style="color:#2980b9" %)TimeDimension|(% style="width:252px" %)(% style="color:#2980b9" %)TIME_PERIOD
311 -|(% style="width:204px" %)(% style="color:#16a085" %)[[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]|(% style="width:252px" %)(% style="color:#16a085" %)OBS_STATUS
312 -|(% style="width:204px" %)(% style="color:#16a085" %)[[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]|(% style="width:252px" %)(% style="color:#16a085" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]
313 -|(% style="width:204px" %)(% style="color:#16a085" %)[[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]|(% style="width:252px" %)(% style="color:#16a085" %)[[COMMENT>>doc:sdmx:Glossary 2\.1.Comment.WebHome]]
314 -|(% style="width:204px" %)(% style="color:#f39c12" %)MetadataAttribute|(% style="width:252px" %)(% style="color:#e74c3c" %)CONTACT
315 -|(% style="width:204px" %)[[Measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]]|(% style="width:252px" %)MULTISELECT
316 -|(% style="width:204px" %)[[Measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]]|(% style="width:252px" %)CHOICE
305 +|Dimension|FREQ
306 +|Dimension|JD_TYPE
307 +|Dimension|JD_CATEGORY
308 +|Dimension|VIS_CTY
309 +|TimeDimension|TIME_PERIOD
310 +|Attribute|OBS_STATUS
311 +|Attribute|UNIT
312 +|Attribute|COMMENT
313 +|MetadataAttribute|CONTACT
314 +|Measure|MULTISELECT
315 +|Measure|CHOICE
317 317  
318 318  On the above, let’s assume the following use cases with their constraining requirements:
319 319  
... ... @@ -325,9 +325,8 @@
325 325  
326 326  This is expressed with the following CubeRegion:
327 327  
328 -(% style="width:287.294px" %)
329 -|(% style="width:131px" %)(% style="color:#3498db" %)FREQ|(% style="width:153px" %)(% style="color:#3498db" %)M, Q
330 -|(% style="width:131px" %)(% style="color:#3498db" %)VIS_CTY|(% style="width:153px" %)(% style="color:#3498db" %)MX
327 +|FREQ|M, Q
328 +|VIS_CTY|MX
331 331  
332 332  **Use Case 2: A Constraint on allowed combinations for some Dimensions**
333 333  
... ... @@ -337,16 +337,13 @@
337 337  
338 338  This is expressed with the following DataKeySet:
339 339  
340 -(% style="width:388.294px" %)
341 -|(% style="width:105px" %)(% style="color:#2980b9" %)Key1|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:143px" %)(% style="color:#2980b9" %)M
342 -|(% style="width:105px" %) |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)DE
343 -|(% rowspan="2" style="width:105px" %)(% style="color:#2980b9" %)Key2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:143px" %)(% style="color:#2980b9" %)Q
344 -|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)MX
338 +|Key1|FREQ|M
339 +| |VIS_CTY|DE
340 +|(% rowspan="2" %)Key2|FREQ|Q
341 +|VIS_CTY|MX
345 345  
346 -**Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes**
343 +**Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes** R1: Allow monthly and quarterly data
347 347  
348 -R1: Allow monthly and quarterly data
349 -
350 350  R2: Allow Mexico for vis-à-vis country
351 351  
352 352  R3: Allow present for status
... ... @@ -353,26 +353,24 @@
353 353  
354 354  This may be expressed with the following CubeRegion:
355 355  
356 -(% style="width:285.294px" %)
357 -|(% style="width:143px" %)(% style="color:#2980b9" %)FREQ|(% style="width:139px" %)(% style="color:#2980b9" %)M, Q
358 -|(% style="width:143px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:139px" %)(% style="color:#2980b9" %)MX
359 -|(% style="width:143px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:139px" %)(% style="color:#27ae60" %)A
351 +|FREQ|M, Q
352 +|VIS_CTY|MX
353 +|OBS_STATUS|A
360 360  
361 361  **Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
362 362  
363 -R1: Allow monthly data, for Germany, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] euro
357 +R1: Allow monthly data, for Germany, with unit euro
364 364  
365 -R2: Allow quarterly data, for Mexico, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] usd
359 +R2: Allow quarterly data, for Mexico, with unit usd
366 366  
367 367  This may be expressed with the following DataKeySet:
368 368  
369 -(% style="width:389.294px" %)
370 -|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)M
371 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)DE
372 -|(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:142px" %)(% style="color:#27ae60" %)EUR
373 -|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)Q
374 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)MX
375 -|(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:142px" %)(% style="color:#27ae60" %)USD
363 +|(% rowspan="3" %)Key1|FREQ|M
364 +|VIS_CTY|DE
365 +|UNIT|EUR
366 +|(% rowspan="3" %)Key2|FREQ|Q
367 +|VIS_CTY|MX
368 +|UNIT|USD
376 376  
377 377  **Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
378 378  
... ... @@ -382,59 +382,52 @@
382 382  
383 383  Considering the above examples, the following CubeRegions would be created:
384 384  
385 -(% style="width:449.294px" %)
386 -|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion1|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)Q, A
387 -|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
388 -|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)A
389 -|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)M
390 -|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
391 -|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)F
378 +|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
379 +|VIS_CTY|MX, DE
380 +|OBS_STATUS|A
381 +|(% rowspan="3" %)CubeRegion2|FREQ|M
382 +|VIS_CTY|MX, DE
383 +|OBS_STATUS|F
392 392  
393 -The problem with this approach is that according to the business rule for [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], only one should be specified per [[Component>>doc:sdmx:Glossary 2\.1.Component.WebHome]]. Thus, if a software would perform some conflict resolution would end up with empty sets for FREQ and OBS_STATUS (as they do not share any values).
385 +The problem with this approach is that according to the business rule for Constraints, only one should be specified per Component. Thus, if a software would perform some conflict resolution would end up with empty sets for FREQ and OBS_STATUS (as they do not share any values).
394 394  
395 -Nevertheless, there is a much easier approach to that; this is the cascading mechanism of [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] (as shown in 10.4.7.1). Hence, these rules would be expressed into two [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]] of [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], e.g., [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] and [[Dataflows>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]:
387 +Nevertheless, there is a much easier approach to that; this is the cascading mechanism of Constraints (as shown in 10.4.7.1). Hence, these rules would be expressed into two levels of Constraints, e.g., DSD and Dataflows:
396 396  
397 397  DSD CubeRegion:
398 398  
399 -(% style="width:280.294px" %)
400 -|(% style="width:156px" %)(% style="color:#2980b9" %)FREQ|(% style="width:121px" %)(% style="color:#2980b9" %)M, Q, A
401 -|(% style="width:156px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:121px" %)(% style="color:#2980b9" %)MX, DE
402 -|(% style="width:156px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:121px" %)(% style="color:#27ae60" %)A, F
391 +|FREQ|M, Q, A
392 +|VIS_CTY|MX, DE
393 +|OBS_STATUS|A, F
403 403  
404 404  Dataflow1 CubeRegion:
405 405  
406 -(% style="width:285.294px" %)
407 -|(% style="width:157px" %)(% style="color:#2980b9" %)FREQ|(% style="width:125px" %)(% style="color:#2980b9" %)Q, A
408 -|(% style="width:157px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:125px" %)(% style="color:#2980b9" %)MX, DE
409 -|(% style="width:157px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:125px" %)(% style="color:#27ae60" %)F
397 +|FREQ|Q, A
398 +|VIS_CTY|MX, DE
399 +|OBS_STATUS|F
410 410  
411 411  Dataflow2 CubeRegion:
412 412  
413 -(% style="width:288.294px" %)
414 -|(% style="width:159px" %)(% style="color:#2980b9" %)FREQ|(% style="width:126px" %)(% style="color:#2980b9" %)M
415 -|(% style="width:159px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:126px" %)(% style="color:#2980b9" %)MX, DE
416 -|(% style="width:159px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:126px" %)(% style="color:#27ae60" %)A
403 +|FREQ|M
404 +|VIS_CTY|MX, DE
405 +|OBS_STATUS|A
417 417  
418 418  **Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
419 419  
420 -R1: Allow monthly data, for Germany, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] euro, and [[measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]] choice is  'A' R2: Allow quarterly data, for Mexico, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] usd, and [[measure>>doc:sdmx:Glossary 2\.1.Measure.WebHome]] choice is  'B'
409 +R1: Allow monthly data, for Germany, with unit euro, and measure choice is  'A' R2: Allow quarterly data, for Mexico, with unit usd, and measure choice is  'B'
421 421  
422 422  This may be expressed with the following DataKeySet:
423 423  
424 -(% style="width:404.294px" %)
425 -|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)M
426 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)DE
427 -|(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:149px" %)(% style="color:#27ae60" %)EUR
428 -|(% style="width:153px" %)CHOICE|(% style="width:149px" %)A
429 -|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)Q
430 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)MX
431 -|(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:149px" %)(% style="color:#27ae60" %)USD
432 -|(% style="width:153px" %)CHOICE|(% style="width:149px" %)B
413 +|(% rowspan="4" %)Key1|FREQ|M
414 +|VIS_CTY|DE
415 +|UNIT|EUR
416 +|CHOICE|A
417 +|(% rowspan="4" %)Key2|FREQ|Q
418 +|VIS_CTY|MX
419 +|UNIT|USD
420 +|CHOICE|B
433 433  
434 -**Use Case 7: A Constraint with wildcards for Codes and removePrefix property**
422 +**Use Case 7: A Constraint with wildcards for Codes and removePrefix property** For this example, we assume that the VIS_CTY representation has been prefixed with prefix ‘AREA_’. In this Constraint, we need to remove the prefix.
435 435  
436 -For this example, we assume that the VIS_CTY [[representation>>doc:sdmx:Glossary 2\.1.Representation.WebHome]] has been prefixed with prefix ‘AREA_’. In this [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]], we need to remove the prefix.
437 -
438 438  R1: Allow monthly and quarterly data
439 439  
440 440  R2: Allow vis-à-vis countries that start with M
... ... @@ -443,9 +443,8 @@
443 443  
444 444  This may be expressed with the following CubeRegion:
445 445  
446 -(% style="width:379.294px" %)
447 -|(% style="width:264px" %)(% style="color:#2980b9" %)FREQ|(% style="width:112px" %)(% style="color:#2980b9" %)M, Q
448 -|(% style="width:264px" %)(% style="color:#2980b9" %)VIS_CTY (removePrefix=’AREA_’)|(% style="width:112px" %)(% style="color:#2980b9" %)M%
432 +|FREQ|M, Q
433 +|VIS_CTY (removePrefix=’AREA_’)|M%
449 449  
450 450  **Use Case 8: A Constraint with multilingual support on Attributes**
451 451  
... ... @@ -453,19 +453,16 @@
453 453  
454 454  R2: Allow Mexico for vis-à-vis country
455 455  
456 -R3: Allow a [[comment>>doc:sdmx:Glossary 2\.1.Comment.WebHome]], in English, which includes the term adjusted for status
441 +R3: Allow a comment, in English, which includes the term adjusted for status
457 457  
458 458  This may be expressed with the following CubeRegion:
459 459  
460 -(% style="width:382.294px" %)
461 -|(% style="width:190px" %)(% style="color:#2980b9" %)FREQ|(% style="width:189px" %)(% style="color:#2980b9" %)M, Q
462 -|(% style="width:190px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:189px" %)(% style="color:#2980b9" %)MX
463 -|(% style="width:190px" %)(% style="color:#27ae60" %)[[COMMENT>>doc:sdmx:Glossary 2\.1.Comment.WebHome]] (lang=’en’)|(% style="width:189px" %)(% style="color:#27ae60" %)%adjusted%
445 +|FREQ|M, Q
446 +|VIS_CTY|MX
447 +|COMMENT (lang=’en’)|%adjusted%
464 464  
465 -**Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes**
449 +**Use Case 9: A Constraint on allowed values for Dimensions combined with allowed** values for Metadata Attributes R1: Allow monthly and quarterly data
466 466  
467 -R1: Allow monthly and quarterly data
468 -
469 469  R2: Allow Mexico for vis-à-vis country
470 470  
471 471  R3: Allow John Doe for contact
... ... @@ -472,7 +472,6 @@
472 472  
473 473  This may be expressed with the following CubeRegion:
474 474  
475 -(% style="width:388.294px" %)
476 -|(% style="width:181px" %)(% style="color:#2980b9" %)FREQ|(% style="width:204px" %)(% style="color:#2980b9" %)M, Q
477 -|(% style="width:181px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:204px" %)(% style="color:#2980b9" %)MX
478 -|(% style="width:181px" %)(% style="color:#e74c3c" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
457 +|FREQ|M, Q
458 +|VIS_CTY|MX
459 +|CONTACT|John Doe
1750065279010-260.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.arturkryazhev
Size
... ... @@ -1,1 +1,0 @@
1 -60.3 KB
Content
1750065319060-899.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.arturkryazhev
Size
... ... @@ -1,1 +1,0 @@
1 -91.0 KB
Content
1750065367824-357.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.arturkryazhev
Size
... ... @@ -1,1 +1,0 @@
1 -51.4 KB
Content
1750065392163-400.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.arturkryazhev
Size
... ... @@ -1,1 +1,0 @@
1 -104.8 KB
Content
1750065461589-995.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.arturkryazhev
Size
... ... @@ -1,1 +1,0 @@
1 -43.9 KB
Content
SKMS.Methodology.Code.MethodologyClass[0]
Index
... ... @@ -1,1 +1,0 @@
1 -10
SUZ.Methodology.Code.MethodologyClass[0]
© Semantic R&D Group, 2026