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 8.5
edited by Helena K.
on 2026/06/10 09:37
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -251,9 +251,10 @@
251 251  
252 252  Notes:
253 253  
254 +
254 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.
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]].
257 +* The same (% style="color:#e74c3c" %)Constraint(%%) applies to both [[Provision Agreements>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]].
257 257  
258 258  The cascade rules elaborated above result as follows:
259 259  
... ... @@ -263,40 +263,40 @@
263 263  
264 264  [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] 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 +* 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 (% style="color:#e74c3c" %)constraint(%%) 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 267  ** Restricts the CAS [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] to 003 and 004.
268 268  
269 269  [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE2
270 270  
271 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]].
273 +** Inherits the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] (% style="color:#e74c3c" %)constraint(%%) applied at the (% style="color:#e74c3c" %)level(%%) of the [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]].
273 273  
274 274  [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE1_IT
275 275  
276 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]].
278 +** Inherits the (% style="color:#e74c3c" %)constraints(%%) 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]].
278 278  
279 279  [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE2_IT
280 280  
281 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]].
283 +** Inherits the (% style="color:#e74c3c" %)constraints(%%) from [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE2 for the CAS [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]].
284 +** Inherits the [[AGE>>doc:sdmx:Glossary 2\.1.Age.WebHome]] (% style="color:#e74c3c" %)constraint(%%) applied at the (% style="color:#e74c3c" %)level(%%) 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:
286 +The (% style="color:#e74c3c" %)Constraints(%%) are defined as follows:
286 286  
287 -DSD Constraint
288 +[[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] (% style="color:#e74c3c" %)Constraint
288 288  
289 289  [[image:1750065367824-357.png]]
290 290  
291 -Dataflow Constraints
292 +[[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] (% style="color:#e74c3c" %)Constraints
292 292  
293 293  [[image:1750065392163-400.png]]
294 294  
295 -Provision Agreement Constraint
296 +[[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] (% style="color:#e74c3c" %)Constraint
296 296  
297 297  [[image:1750065461589-995.png]]
298 298  
299 -**10.4.7.2 Combination of Constraints**
300 +**10.4.7.2 Combination of (% style="color:#e74c3c" %)Constraints(%%)**
300 300  
301 301  The possible combination of constraining terms are explained in this section, following a few examples.
302 302  
... ... @@ -317,7 +317,7 @@
317 317  
318 318  On the above, let’s assume the following use cases with their constraining requirements:
319 319  
320 -**Use Case 1: A Constraint on allowed values for some Dimensions**
321 +**Use Case 1: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]**
321 321  
322 322  R1: Allow monthly and quarterly data
323 323  
... ... @@ -329,7 +329,7 @@
329 329  |(% style="width:131px" %)(% style="color:#3498db" %)FREQ|(% style="width:153px" %)(% style="color:#3498db" %)M, Q
330 330  |(% style="width:131px" %)(% style="color:#3498db" %)VIS_CTY|(% style="width:153px" %)(% style="color:#3498db" %)MX
331 331  
332 -**Use Case 2: A Constraint on allowed combinations for some Dimensions**
333 +**Use Case 2: A (% style="color:#e74c3c" %)Constraint(%%) on allowed combinations for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]**
333 333  
334 334  R1: Allow monthly data for Germany
335 335  
... ... @@ -343,10 +343,8 @@
343 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 344  |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)MX
345 345  
346 -**Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes**
347 +**Use Case 3: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] combined with allowed values for some [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]** 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
... ... @@ -358,7 +358,7 @@
358 358  |(% style="width:143px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:139px" %)(% style="color:#2980b9" %)MX
359 359  |(% style="width:143px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:139px" %)(% style="color:#27ae60" %)A
360 360  
361 -**Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
360 +**Use Case 4: A (% style="color:#e74c3c" %)Constraint(%%) on allowed combinations for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] combined with specific [[Attribute>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] values**
362 362  
363 363  R1: Allow monthly data, for Germany, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] euro
364 364  
... ... @@ -374,7 +374,7 @@
374 374  |(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)MX
375 375  |(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:142px" %)(% style="color:#27ae60" %)USD
376 376  
377 -**Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
376 +**Use Case 5: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] together with some combination of [[Dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] values**
378 378  
379 379  R1: For annually and quarterly data, for Mexico and Germany, only A status is allowed
380 380  
... ... @@ -390,11 +390,11 @@
390 390  |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
391 391  |(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)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).
392 +The problem with this approach is that according to the business rule for (% style="color:#e74c3c" %)Constraints(%%), 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).
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]]:
394 +Nevertheless, there is a much easier approach to that; this is the cascading mechanism of (% style="color:#e74c3c" %)Constraints(%%) (as shown in 10.4.7.1). Hence, these rules would be expressed into two (% style="color:#e74c3c" %)levels(%%) of (% style="color:#e74c3c" %)Constraints(%%), e.g., [[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] and [[Dataflows>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]:
396 396  
397 -DSD CubeRegion:
396 +[[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] CubeRegion:
398 398  
399 399  (% style="width:280.294px" %)
400 400  |(% style="width:156px" %)(% style="color:#2980b9" %)FREQ|(% style="width:121px" %)(% style="color:#2980b9" %)M, Q, A
... ... @@ -415,7 +415,7 @@
415 415  |(% style="width:159px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:126px" %)(% style="color:#2980b9" %)MX, DE
416 416  |(% style="width:159px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:126px" %)(% style="color:#27ae60" %)A
417 417  
418 -**Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
417 +**Use case 6: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] combined with allowed values for [[Measures>>doc:sdmx:Glossary 2\.1.Measure.WebHome]]**
419 419  
420 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'
421 421  
... ... @@ -431,9 +431,9 @@
431 431  |(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:149px" %)(% style="color:#27ae60" %)USD
432 432  |(% style="width:153px" %)CHOICE|(% style="width:149px" %)B
433 433  
434 -**Use Case 7: A Constraint with wildcards for Codes and removePrefix property**
433 +**Use Case 7: A (% style="color:#e74c3c" %)Constraint(%%) with wildcards for [[Codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] and removePrefix property**
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.
435 +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 (% style="color:#e74c3c" %)Constraint(%%), we need to remove the prefix.
437 437  
438 438  R1: Allow monthly and quarterly data
439 439  
... ... @@ -447,7 +447,7 @@
447 447  |(% style="width:264px" %)(% style="color:#2980b9" %)FREQ|(% style="width:112px" %)(% style="color:#2980b9" %)M, Q
448 448  |(% style="width:264px" %)(% style="color:#2980b9" %)VIS_CTY (removePrefix=’AREA_’)|(% style="width:112px" %)(% style="color:#2980b9" %)M%
449 449  
450 -**Use Case 8: A Constraint with multilingual support on Attributes**
449 +**Use Case 8: A (% style="color:#e74c3c" %)Constraint(%%) with multilingual support on [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]**
451 451  
452 452  R1: Allow monthly and quarterly data
453 453  
... ... @@ -462,13 +462,11 @@
462 462  |(% style="width:190px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:189px" %)(% style="color:#2980b9" %)MX
463 463  |(% style="width:190px" %)(% style="color:#27ae60" %)[[COMMENT>>doc:sdmx:Glossary 2\.1.Comment.WebHome]] (lang=’en’)|(% style="width:189px" %)(% style="color:#27ae60" %)%adjusted%
464 464  
465 -**Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes**
464 +**Use Case 9: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] combined with allowed** values for Metadata [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]] 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 -R3: Allow John Doe for contact
468 +R3: Allow John Doe for (% style="color:#e74c3c" %)contact(%%)
472 472  
473 473  This may be expressed with the following CubeRegion:
474 474  
... ... @@ -475,4 +475,4 @@
475 475  (% style="width:388.294px" %)
476 476  |(% style="width:181px" %)(% style="color:#2980b9" %)FREQ|(% style="width:204px" %)(% style="color:#2980b9" %)M, Q
477 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
475 +|(% style="width:181px" %)(% style="color: rgb(243, 156, 18); color: rgb(231, 76, 60)" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
© Semantic R&D Group, 2026