Skip to Content

Changes for page 10 Constraints

Last modified by Helena on 2025/09/10 11:19
From version 1.1
edited by Helena
on 2025/05/15 15:48
Change comment: Changed document syntax from [XWiki 2.1] to [xwiki/2.1].
To version 16.4
edited by Helena
on 2025/05/19 14:18
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +10 Constraints
Parent
... ... @@ -1,0 +1,1 @@
1 +Methodology.SDMX 3\.0 Standards\. Technical notes.WebHome
Content
... ... @@ -1,0 +1,361 @@
1 +{{box title="**Contents**"}}
2 +{{toc/}}
3 +{{/box}}
4 +
5 +== 10.1 Introduction ==
6 +
7 +A (% style="color:#2ecc71" %)Constraint(%%) is a [[Maintainable Artefact>>doc:xwiki:Glossary.Maintainable artefact.WebHome]] that can be associated to one or more of:
8 +
9 +* Data Structure Definition
10 +* Metadata Structure Definition
11 +* [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]
12 +* [[Metadataflow>>doc:xwiki:Glossary.Metadataflow.WebHome]]
13 +* [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]]
14 +* Metadata [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]]
15 +* [[Data Provider>>doc:xwiki:Glossary.Data provider.WebHome]] or Metadata Provider (this is restricted to a [[Release Calendar>>doc:xwiki:Glossary.Release policy - release calendar.WebHome]] (% style="color:#2ecc71" %)Constraint(%%))
16 +* Simple or Queryable Data Sources
17 +* Dataset
18 +* Metadataset
19 +
20 +Note that regardless of the [[Artefact>>doc:xwiki:Glossary.Artefact.WebHome]] to which the (% style="color:#2ecc71" %)Constraint(%%) is associated, it is constraining the contents of [[code lists>>doc:xwiki:Glossary.Code list.WebHome]] in the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] to which the constrained object is related. This does not apply, of course, to a Metadata/[[Data Provider>>doc:xwiki:Glossary.Data provider.WebHome]] as the latter can be associated, via the (Metadata) [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]], to many MSDs/DSDs. Hence the reason for the restriction on the type of (% style="color:#2ecc71" %)Constraint(%%) that can be attached to a Metadata/[[Data Provider>>doc:xwiki:Glossary.Data provider.WebHome]].
21 +
22 +== 10.2 Types of Constraint ==
23 +
24 +The (% style="color:#2ecc71" %)Constraint(%%) can be of one of two types:
25 +
26 +* Data (% style="color:#2ecc71" %)constraint
27 +* Metadata (% style="color:#2ecc71" %)constraint
28 +
29 +The Data (% style="color:#2ecc71" %)Constraint(%%) may serve two different perspectives, depending on the way the latter is retrieved. These are:
30 +
31 +* Allowed (% style="color:#2ecc71" %)constraint
32 +* Actual (% style="color:#2ecc71" %)constraint
33 +
34 +The former (allowed – also valid for Metadata (% style="color:#2ecc71" %)Constraint(%%)) is specified by a data or metadata provider or consumer for sharing the allowed data and metadata in the context of their [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] or [[MSD>>doc:xwiki:Glossary.Metadata structure definition.WebHome]] exchanges, e.g., only Monthly data for a specific [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]. The latter (actual) is a dynamic (% style="color:#2ecc71" %)Constraint(%%) in response to an availability request (only possible for data).
35 +
36 +For Actual Data (% style="color:#2ecc71" %)Constraints(%%), there a few characteristics that are worth noting:
37 +
38 +* They can only be retrieved by the availability requests (as specified in the REST API).
39 +* They depend on the data available in an [[SDMX>>doc:xwiki:Glossary.Statistical data and metadata exchange.WebHome]] Web Service and thus they can only be dynamically generated according to that data.
40 +* Although they are [[Maintainable Artefacts>>doc:xwiki:Glossary.Maintainable artefact.WebHome]], they cannot change independently of data; thus, they cannot be versioned (they are non-versioned, as explained in section 14).
41 +* Their identifier may also be dynamically generated and thus there is no REST resource based on their identification.
42 +
43 +== 10.3 Rules for a Constraint ==
44 +
45 +=== 10.3.1 Scope of a Constraint ===
46 +
47 +A (% style="color:#2ecc71" %)Constraint(%%) is used specify the content of a data or metadata source in terms of the [[component>>doc:xwiki:Glossary.Component.WebHome]] values or the keys.
48 +
49 +In terms of data the [[components>>doc:xwiki:Glossary.Component.WebHome]] are:
50 +
51 +* [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]]
52 +* Time [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]]
53 +* Data [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]]
54 +* [[Measure>>doc:xwiki:Glossary.Measure.WebHome]]
55 +* Metadata [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]]
56 +* DataKeySets: the keys are the content of the KeyDescriptor – i.e., the [[series keys>>doc:xwiki:Glossary.Series key.WebHome]] composed, for each key, by a value for each [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]].
57 +
58 +In terms of [[reference metadata>>doc:xwiki:Glossary.Reference metadata.WebHome]] the [[components>>doc:xwiki:Glossary.Component.WebHome]] are:
59 +
60 +* Metadata [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]]
61 +
62 +For a (% style="color:#2ecc71" %)Constraint(%%) based on a [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] the (% style="color:#2ecc71" %)Constraint(%%) can reference one or more of:
63 +
64 +* Data Structure Definition
65 +* [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]
66 +* [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]]
67 +* [[Data Provider>>doc:xwiki:Glossary.Data provider.WebHome]]
68 +
69 +For a (% style="color:#2ecc71" %)Constraint(%%) based on an [[MSD>>doc:xwiki:Glossary.Metadata structure definition.WebHome]] the (% style="color:#2ecc71" %)Constraint(%%) can reference one or more of:
70 +
71 +* Metadata Structure Definition
72 +* [[Metadataflow>>doc:xwiki:Glossary.Metadataflow.WebHome]]
73 +* Metadata [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]]
74 +* Metadata Provider
75 +* Metadata Set
76 +
77 +Furthermore, there can be more than one (% style="color:#2ecc71" %)Constraint(%%) specified for a specific object e.g., more than one (% style="color:#2ecc71" %)Constraint(%%) for a specific [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]].
78 +
79 +In view of the flexibility of (% style="color:#2ecc71" %)constraints(%%) attachment, clear rules on their usage are required. These are elaborated below.
80 +
81 +=== 10.3.2 Multiple Constraints ===
82 +
83 +There can be many (% style="color:#2ecc71" %)Constraints(%%) for any Constrainable [[Artefact>>doc:xwiki:Glossary.Artefact.WebHome]] (e.g., [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]]), subject to the following restrictions:
84 +
85 +==== 10.3.2.1 Cube Region ====
86 +
87 +A (% style="color:#2ecc71" %)Constraint(%%) can contain multiple [[Member Selections>>doc:xwiki:Glossary.Member selection.WebHome]] (e.g., [[Dimensions>>doc:xwiki:Glossary.Dimension.WebHome]]).
88 +
89 +* A specific [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] (e.g., [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] FREQ) can only be contained in one Cube Region for any one attached object (e.g., a specific [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] or specific [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]).
90 +* [[Component>>doc:xwiki:Glossary.Component.WebHome]] values within a [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] may define a validity period. Otherwise, the value is valid for the whole validity of the Cube Region.
91 +* For partial reference resolution purposes (as per the [[SDMX>>doc:xwiki:Glossary.Statistical data and metadata exchange.WebHome]] REST API), the latest non-draft (% style="color:#2ecc71" %)Constraint(%%) must be considered.
92 +* A [[Member Selection>>doc:xwiki:Glossary.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), 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.
93 +* Any values included in a [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] for [[Components>>doc:xwiki:Glossary.Component.WebHome]] with an array data type (i.e., [[Measures>>doc:xwiki:Glossary.Measure.WebHome]], [[Attributes>>doc:xwiki:Glossary.Attribute.WebHome]] or Metadata [[Attributes>>doc:xwiki:Glossary.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:xwiki:Glossary.Code.WebHome]] ‘A’ for an [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]] will allow any instance of the [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]] that includes ‘A’, like [‘A’, ‘B’] or [‘A’, ‘C’, ‘D’]. Similarly, if [[Code>>doc:xwiki:Glossary.Code.WebHome]] ‘A’ was excluded, all those arrays of values would also be excluded.
94 +
95 +==== 10.3.2.2 Key Set ====
96 +
97 +Key Sets will be processed in the order they appear in the (% style="color:#2ecc71" %)Constraint(%%) and wildcards can be used (e.g., any key position not reference explicitly is deemed to be "all values").
98 +
99 +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:xwiki:Glossary.Series key.WebHome]]. This will minimize the risk that keys are inadvertently included or excluded.
100 +
101 +In addition, [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]], [[Measure>>doc:xwiki:Glossary.Measure.WebHome]] and Metadata [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]] (% style="color:#2ecc71" %)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.
102 +
103 +Finally, a validity period may be specified per Key.
104 +
105 +=== 10.3.3 Inheritance of a Constraint ===
106 +
107 +==== 10.3.3.1 Attachment levels of a Constraint ====
108 +
109 +There are three (% style="color:#2ecc71" %)levels(%%) of (% style="color:#2ecc71" %)constraint(%%) attachment for which these inheritance rules apply:
110 +
111 +• [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]]/[[MSD>>doc:xwiki:Glossary.Metadata structure definition.WebHome]] – top (% style="color:#2ecc71" %)level(%%) o [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]/[[Metadataflow>>doc:xwiki:Glossary.Metadataflow.WebHome]] – second (% style="color:#2ecc71" %)level
112 +
113 +▪ [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]] – third (% style="color:#2ecc71" %)level
114 +
115 +Note that these rules do not apply to the Simple Datasource or Queryable Datasource; the (% style="color:#2ecc71" %)Constraint(%%)(s) attached to these [[artefacts>>doc:xwiki:Glossary.Artefact.WebHome]] are resolved for this [[artefact>>doc:xwiki:Glossary.Artefact.WebHome]] only and do not take into account (% style="color:#2ecc71" %)Constraints(%%) attached to other [[artefacts>>doc:xwiki:Glossary.Artefact.WebHome]] (e.g., [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]], [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]], [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]]).
116 +
117 +It is not necessary for a (% style="color:#2ecc71" %)Constraint(%%) to be attached to a higher (% style="color:#2ecc71" %)level(%%) [[artefact>>doc:xwiki:Glossary.Artefact.WebHome]]. e.g., it is valid to have a (% style="color:#2ecc71" %)Constraint(%%) for a [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]] where there are no (% style="color:#2ecc71" %)constraints(%%) attached the relevant [[dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] or [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]].
118 +
119 +==== 10.3.3.2 Cascade rules for processing Constraints ====
120 +
121 +The processing of the (% style="color:#2ecc71" %)constraints(%%) on either [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]/[[Metadataflow>>doc:xwiki:Glossary.Metadataflow.WebHome]] or [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]] must take into account the (% style="color:#2ecc71" %)constraints(%%) declared at higher (% style="color:#2ecc71" %)levels(%%). The rules for the lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)constraints(%%) (attached to [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]/ [[Metadataflow>>doc:xwiki:Glossary.Metadataflow.WebHome]] and [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]]) are detailed below.
122 +
123 +Note that there can be a situation where a (% style="color:#2ecc71" %)constraint(%%) is specified at a lower (% style="color:#2ecc71" %)level(%%) before a (% style="color:#2ecc71" %)constraint(%%) is specified at a higher (% style="color:#2ecc71" %)level(%%). Therefore, it is possible that a higher-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)constraint(%%) makes a lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)constraint(%%) invalid. [[SDMX>>doc:xwiki:Glossary.Statistical data and metadata exchange.WebHome]] makes no rules on how such a conflict should be handled when processing the (% style="color:#2ecc71" %)constraint(%%) for attachment. However, the cascade rules on evaluating (% style="color:#2ecc71" %)constraints(%%) for usage are clear – the higher-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)constraint(%%) takes precedence in any conflicts that result in a less restrictive specification at the lower (% style="color:#2ecc71" %)level(%%).
124 +
125 +==== 10.3.3.3 Cube Region ====
126 +
127 +It is not necessary to have a (% style="color:#2ecc71" %)Constraint(%%) on the higher-(% style="color:#2ecc71" %)level(%%) [[artefact>>doc:xwiki:Glossary.Artefact.WebHome]] (e.g., [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] referenced by the [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]), but if there is such a (% style="color:#2ecc71" %)Constraint(%%) at the higher (% style="color:#2ecc71" %)level(%%)(s) then:
128 +
129 +* The lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%) cannot be less restrictive than the (% style="color:#2ecc71" %)Constraint(%%) specified for the same [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] (e.g. [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]]) at the next higher (% style="color:#2ecc71" %)level(%%), which constrains that [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]]. For example, if the [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] FREQ is constrained to A, Q in a [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]], then the (% style="color:#2ecc71" %)Constraint(%%) at the [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] or [[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]] cannot be A, Q, M or even just M – it can only further constrain A, Q.
130 +* The (% style="color:#2ecc71" %)Constraint(%%) at the lower (% style="color:#2ecc71" %)level(%%) for any one [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] further constrains the content for the same [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] at the higher (% style="color:#2ecc71" %)level(%%)(s).
131 +* Any [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]], which is not referenced in a (% style="color:#2ecc71" %)Constraint(%%), is deemed to be constrained according to the (% style="color:#2ecc71" %)Constraint(%%) specified at the next higher (% style="color:#2ecc71" %)level(%%) which (% style="color:#2ecc71" %)constraints(%%) that [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]].
132 +* If there is a conflict when resolving the (% style="color:#2ecc71" %)Constraint(%%) in terms of a lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%) being less restrictive than a higher-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%), then the (% style="color:#2ecc71" %)Constraint(%%) at the higher-(% style="color:#2ecc71" %)level(%%) is used.
133 +
134 +Note that it is possible for a (% style="color:#2ecc71" %)Constraint(%%) at a higher (% style="color:#2ecc71" %)level(%%) to constrain, say, four [[Dimensions>>doc:xwiki:Glossary.Dimension.WebHome]] in a single (% style="color:#2ecc71" %)Constraint(%%), and a (% style="color:#2ecc71" %)Constraint(%%) at a lower (% style="color:#2ecc71" %)level(%%) to constrain the same four in two, three, or four (% style="color:#2ecc71" %)Constraints(%%).
135 +
136 +==== 10.3.3.4 Key Set ====
137 +
138 +It is not necessary to have a (% style="color:#2ecc71" %)Constraint(%%) on the higher-(% style="color:#2ecc71" %)level(%%) [[artefact>>doc:xwiki:Glossary.Artefact.WebHome]] (e.g., [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] referenced by the [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]), but if there is such a (% style="color:#2ecc71" %)Constraint(%%) at the higher (% style="color:#2ecc71" %)level(%%)(s) then:
139 +
140 +* The lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%) cannot be less restrictive than the (% style="color:#2ecc71" %)Constraint(%%) specified at the higher (% style="color:#2ecc71" %)level(%%).
141 +* The (% style="color:#2ecc71" %)Constraint(%%) at the lower (% style="color:#2ecc71" %)level(%%) for any one [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]] further constrains the keys specified at the higher (% style="color:#2ecc71" %)level(%%)(s).
142 +* Any [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]], which is not referenced in a (% style="color:#2ecc71" %)Constraint(%%), is deemed to be constrained according to the (% style="color:#2ecc71" %)Constraint(%%) specified at the next higher (% style="color:#2ecc71" %)level(%%) which (% style="color:#2ecc71" %)constraints(%%) that [[Member Selection>>doc:xwiki:Glossary.Member selection.WebHome]].
143 +* If there is a conflict when resolving the keys in the (% style="color:#2ecc71" %)Constraint(%%) at two (% style="color:#2ecc71" %)levels(%%), in terms of a lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)constraint(%%) being less restrictive than a higher-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%), then the offending keys specified at the lower (% style="color:#2ecc71" %)level(%%) are not deemed part of the (% style="color:#2ecc71" %)Constraint(%%).
144 +
145 +Note that a Key in a Key Set can have wildcarded [[Components>>doc:xwiki:Glossary.Component.WebHome]]. For instance, the (% style="color:#2ecc71" %)Constraint(%%) may simply constrain the [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] FREQ to "A", and all keys where the FREQ="A" are therefore valid.
146 +
147 +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.
148 +
149 +*
150 +*1. Determine all possible keys that are valid at the higher (% style="color:#2ecc71" %)level(%%).
151 +*1. These keys are deemed to be inherited by the lower-(% style="color:#2ecc71" %)level(%%) constrained object, subject to the (% style="color:#2ecc71" %)Constraints(%%) specified at the lower (% style="color:#2ecc71" %)level(%%).
152 +*1. Determine all possible keys that are possible using the (% style="color:#2ecc71" %)Constraints(%%) specified at the lower (% style="color:#2ecc71" %)level(%%).
153 +*1. At the lower (% style="color:#2ecc71" %)level(%%) inherit all keys that match with the higher-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%).
154 +*1. If there are keys in the lower-(% style="color:#2ecc71" %)level(%%) (% style="color:#2ecc71" %)Constraint(%%) that are not inherited then the key is invalid (i.e., it is less restrictive).
155 +
156 +=== 10.3.4 Constraints Examples ===
157 +
158 +==== 10.3.4.1 Data Constraint and Cascading ====
159 +
160 +The following scenario is used.
161 +
162 +A [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] contains the following [[Dimensions>>doc:xwiki:Glossary.Dimension.WebHome]]:
163 +
164 +* GEO – Geography
165 +* SEX – Sex
166 +* AGE – Age
167 +* CAS – Current Activity Status
168 +
169 +In the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]], common [[code lists>>doc:xwiki:Glossary.Code list.WebHome]] are used and the requirement is to restrict these at various (% style="color:#2ecc71" %)levels(%%) to specify the actual [[code>>doc:xwiki:Glossary.Code.WebHome]] that are valid for the object to which the (% style="color:#2ecc71" %)Constraint(%%) is attached.
170 +
171 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_77bea5e.png||height="344" width="554"]]
172 +
173 +**Figure 20: Example Scenario for Constraints **
174 +
175 +Constraints are declared as follows:
176 +
177 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_7c36c475.png||height="356" width="541"]]
178 +
179 +**Figure 21: Example Constraints**
180 +
181 +Notes:
182 +
183 +[[AGE>>doc:xwiki:Glossary.Age.WebHome]] is constrained for the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] and is further restricted for the [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] CENSUS_CUBE1.
184 +
185 +* The same (% style="color:#2ecc71" %)Constraint(%%) applies to both Provision Agreements.
186 +
187 +The cascade rules elaborated above result as follows:
188 +
189 +[[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]]
190 +
191 +* Constrained by eliminating [[code>>doc:xwiki:Glossary.Code.WebHome]] 001 from the [[code list>>doc:xwiki:Glossary.Code list.WebHome]] for the [[AGE>>doc:xwiki:Glossary.Age.WebHome]] [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]].
192 +
193 +[[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] CENSUS_CUBE1
194 +
195 +* Constrained by restricting the [[code list>>doc:xwiki:Glossary.Code list.WebHome]] for the [[AGE>>doc:xwiki:Glossary.Age.WebHome]] [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] to [[codes>>doc:xwiki:Glossary.Code.WebHome]] 002 and 003 (note that this is a more restrictive (% style="color:#2ecc71" %)constraint(%%) than that declared for the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] which specifies all [[codes>>doc:xwiki:Glossary.Code.WebHome]] except [[code>>doc:xwiki:Glossary.Code.WebHome]] 001).
196 +** Restricts the CAS [[codes>>doc:xwiki:Glossary.Code.WebHome]] to 003 and 004.
197 +
198 +[[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] CENSUS_CUBE2
199 +
200 +* Restricts the [[code list>>doc:xwiki:Glossary.Code list.WebHome]] for the CAS [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] to [[codes>>doc:xwiki:Glossary.Code.WebHome]] TOT and NAP.
201 +** Inherits the [[AGE>>doc:xwiki:Glossary.Age.WebHome]] (% style="color:#2ecc71" %)constraint(%%) applied at the (% style="color:#2ecc71" %)level(%%) of the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]].
202 +
203 +Provision Agreement CENSUS_CUBE1_IT
204 +
205 +* Restricts the [[codes>>doc:xwiki:Glossary.Code.WebHome]] for the GEO [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] to IT and its children.
206 +** Inherits the (% style="color:#2ecc71" %)constraints(%%) from [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] CENSUS_CUBE1 for the [[AGE>>doc:xwiki:Glossary.Age.WebHome]] and CAS Dimensions.
207 +
208 +Provision Agreement CENSUS_CUBE2_IT
209 +
210 +* Restricts the [[codes>>doc:xwiki:Glossary.Code.WebHome]] for the GEO [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] to IT and its children.
211 +** Inherits the (% style="color:#2ecc71" %)constraints(%%) from [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] CENSUS_CUBE2 for the CAS [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]].
212 +** Inherits the [[AGE>>doc:xwiki:Glossary.Age.WebHome]] (% style="color:#2ecc71" %)constraint(%%) applied at the (% style="color:#2ecc71" %)level(%%) of the [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]].
213 +
214 +The (% style="color:#2ecc71" %)Constraints(%%) are defined as follows:
215 +
216 +[[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] (% style="color:#2ecc71" %)Constraint
217 +
218 +[[image:1747386911707-332.png]]
219 +
220 +[[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]] (% style="color:#2ecc71" %)Constraints
221 +
222 +[[image:1747386933952-158.png]]
223 +
224 +[[image:1747386970127-658.png]]
225 +
226 +[[Provision Agreement>>doc:xwiki:Glossary.Provision agreement.WebHome]] (% style="color:#2ecc71" %)Constraint
227 +
228 +[[image:1747386991329-805.png]]
229 +
230 +==== 10.3.4.2 Combination of Constraints ====
231 +
232 +The possible combination of constraining terms are explained in this section, following a few examples.
233 +
234 +Let’s assume a [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] with the following [[Components>>doc:xwiki:Glossary.Component.WebHome]]:
235 +
236 +[[image:1747387057775-838.png]]
237 +
238 +[[image:1747387089210-741.png]]
239 +
240 +On the above, let’s assume the following use cases with their constraining requirements:
241 +
242 +===== 10.3.4.2.1 Use Case 1: A Constraint on allowed values for some Dimensions =====
243 +
244 +R1: Allow monthly and quarterly data
245 +R2: Allow Mexico for vis-à-vis country
246 +
247 +This is expressed with the following CubeRegion:
248 +
249 +[[image:1747387154981-708.png]]
250 +
251 +===== 10.3.4.2.2 Use Case 2: A Constraint on allowed combinations for some Dimensions =====
252 +
253 +R1: Allow monthly data for Germany
254 +R2: Allow quarterly data for Mexico
255 +
256 +This is expressed with the following DataKeySet:
257 +
258 +[[image:1747387188821-467.png]]
259 +
260 +===== 10.3.4.2.3 Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes =====
261 +
262 +R1: Allow monthly and quarterly data
263 +R2: Allow Mexico for vis-à-vis country
264 +R3: Allow present for status
265 +
266 +This may be expressed with the following CubeRegion:
267 +
268 +[[image:1747387231598-634.png]]
269 +
270 +===== 10.3.4.2.4 Use Case 4: A Constraint on allowed combinations for some =====
271 +
272 +//**[[Dimensions>>doc:xwiki:Glossary.Dimension.WebHome]] combined with specific [[Attribute>>doc:xwiki:Glossary.Attribute.WebHome]] values**//
273 +
274 +R1: Allow monthly data, for Germany, with unit euro
275 +R2: Allow quarterly data, for Mexico, with unit usd
276 +
277 +This is may be expressed with the following DataKeySet:
278 +
279 +[[image:1747387252077-954.png]]
280 +
281 +[[image:1747387281625-859.png]]
282 +
283 +===== 10.3.4.2.5 Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values =====
284 +
285 +R1: For annually and quarterly data, for Mexico and Germany, only A status is allowed
286 +R2: For monthly data, for Mexico and Germany, only F status is allowed
287 +
288 +Considering the above examples, the following CubeRegions would be created:
289 +
290 +[[image:1747387330751-405.png]]
291 +
292 +The problem with this approach is that according to the business rule for (% style="color:#2ecc71" %)Constraints(%%), only one should be specified per [[Component>>doc:xwiki:Glossary.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).
293 +
294 +Nevertheless, there is a much easier approach to that; this is the cascading mechanism of (% style="color:#2ecc71" %)Constraints(%%) (as shown in 10.3.4.1). Hence, these rules would be expressed into two (% style="color:#2ecc71" %)levels(%%) of (% style="color:#2ecc71" %)Constraints(%%), e.g., [[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] and [[Dataflows>>doc:xwiki:Glossary.Dataflow.WebHome]]:
295 +
296 +[[DSD>>doc:xwiki:Glossary.Data structure definition.WebHome]] CubeRegion:
297 +
298 +[[image:1747387369822-932.png]]
299 +
300 +Dataflow1 CubeRegion:
301 +
302 +[[image:1747387387944-676.png]]
303 +
304 +Dataflow2 CubeRegion:
305 +
306 +[[image:1747387401689-306.png]]
307 +
308 +===== 10.3.4.2.6 Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures =====
309 +
310 +R1: Allow monthly data, for Germany, with unit euro, and [[measure>>doc:xwiki:Glossary.Measure.WebHome]] choice is 'A'
311 +R2: Allow quarterly data, for Mexico, with unit usd, and [[measure>>doc:xwiki:Glossary.Measure.WebHome]] choice is 'B' This is may be expressed with the following DataKeySet:
312 +
313 +[[image:1747387437317-733.png]]
314 +
315 +===== 10.3.4.2.7 Use Case 7: A Constraint with wildcards for Codes and removePrefix property =====
316 +
317 +For this example, we assume that the VIS_CTY [[representation>>doc:xwiki:Glossary.Representation.WebHome]] has been prefixed with prefix ‘AREA_’. In this (% style="color:#2ecc71" %)Constraint(%%), we need to remove the prefix.
318 +
319 +R1: Allow monthly and quarterly data
320 +R2: Allow vis-à-vis countries that start with M
321 +R3: Remove the prefix ‘AREA_’
322 +
323 +This may be expressed with the following CubeRegion:
324 +
325 +[[image:1747387461703-763.png]]
326 +
327 +10.3.4.2.8 Use Case 8: A Constraint with multilingual support on Attributes
328 +
329 +R1: Allow monthly and quarterly data
330 +R2: Allow Mexico for vis-à-vis country
331 +R3: Allow a [[comment>>doc:xwiki:Glossary.Comment.WebHome]], in English, which includes the term adjusted for status
332 +
333 +This may be expressed with the following CubeRegion:
334 +
335 +[[image:1747387484366-337.png]]
336 +
337 +===== 10.3.4.2.9 Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes =====
338 +
339 +R1: Allow monthly and quarterly data
340 +R2: Allow Mexico for vis-à-vis country
341 +R3: Allow John Doe for contact
342 +
343 +This may be expressed with the following CubeRegion:
344 +
345 +[[image:1747387514061-293.png]]
346 +
347 +==== 10.3.4.3 Other constraining terms ====
348 +
349 +Beyond the cube regions and keysets, there is one more constraining term, i.e., the ReleaseCalendar.
350 +
351 +The ReleaseCalendar is the only term that does not apply on [[Components>>doc:xwiki:Glossary.Component.WebHome]]; it specifies the schedule of publication or reporting of the [[dataset>>doc:xwiki:Glossary.Data set.WebHome]] or metadataset.
352 +
353 +For example, the ReleaseCalendar for Provider BIS, is specified in the three following terms:
354 +
355 +* Periodicity: how often data should be reported, e.g., monthly
356 +* Offset: the number of days between the 1^^st^^ of January and the first release of data, e.g., 10 days
357 +* Tolerance: the maximum allowed of days that data may be considered, without being considered as late, e.g., 5 days
358 +
359 +With the above terms, BIS would need to report data between the 10^^th^^ and 15^^th^^ of every month.
360 +
361 +NOTE: The [[SDMX>>doc:xwiki:Glossary.Statistical data and metadata exchange.WebHome]] 2.1 constraining term ReferencePeriod has been deprecated in [[SDMX>>doc:xwiki:Glossary.Statistical data and metadata exchange.WebHome]] 3.0; thus, the TimeDimension and any [[Dimension>>doc:xwiki:Glossary.Dimension.WebHome]] with a time [[Representation>>doc:xwiki:Glossary.Representation.WebHome]] can be constrained within a CubeRegion or MetadataTargetRegion, using the TimeRangeValue.
1747386911707-332.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +47.1 KB
Content
1747386933952-158.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +35.3 KB
Content
1747386970127-658.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +59.4 KB
Content
1747386991329-805.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +56.5 KB
Content
1747387057775-838.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +13.1 KB
Content
1747387089210-741.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +8.3 KB
Content
1747387135817-339.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +3.8 KB
Content
1747387154981-708.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +3.8 KB
Content
1747387188821-467.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +8.2 KB
Content
1747387231598-634.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.2 KB
Content
1747387252077-954.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +5.1 KB
Content
1747387281625-859.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.0 KB
Content
1747387330751-405.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +15.8 KB
Content
1747387369822-932.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.9 KB
Content
1747387387944-676.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.2 KB
Content
1747387401689-306.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.0 KB
Content
1747387437317-733.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +13.9 KB
Content
1747387461703-763.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.5 KB
Content
1747387484366-337.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +9.0 KB
Content
1747387514061-293.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.3 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_18c3726e.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6b13e05d.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.5 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6e97b73c.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_77bea5e.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +66.5 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_7c36c475.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +93.4 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_7df2eea7.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_7e57ad28.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8d48dc1a.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_9818c7f7.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.6 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_a0d353e8.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.6 KB
Content
SDMX 3-0-0 SECTION 6 FINAL-1.0_en_b4693e0d.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content