Skip to Content

Changes for page 10 Constraints

Last modified by Helena K. on 2026/06/10 09:45
From version 8.5
edited by Helena K.
on 2026/06/10 09:37
Change comment: There is no comment for this version
To version 10.1
edited by Helena K.
on 2026/06/10 09:45
Change comment: There is no comment for this version

Summary

Details

Page properties
Tags
... ... @@ -1,0 +1,1 @@
1 +Age|Artefact|Attribute|Code|Codelist|Comment|Component|Constraint|Data Provider|Data Set|Data Structure Definition|Dataflow|Dimension|Language|Level|Maintainable Artefact|Measure|Member Selection|Metadata Set|Metadata Structure Definition|Metadataflow|Observation Value|Provision Agreement|Reference metadata|Representation|Series|Series Key|Sex|Statistical Data and Metadata eXchange|Statistical unit|Time period|Version
Content
... ... @@ -251,10 +251,9 @@
251 251  
252 252  Notes:
253 253  
254 -
255 255  [[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.
256 256  
257 -* The same (% style="color:#e74c3c" %)Constraint(%%) applies to both [[Provision Agreements>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]].
256 +* The same [[Constraint>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] applies to both [[Provision Agreements>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]].
258 258  
259 259  The cascade rules elaborated above result as follows:
260 260  
... ... @@ -264,40 +264,40 @@
264 264  
265 265  [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE1
266 266  
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).
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).
268 268  ** Restricts the CAS [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] to 003 and 004.
269 269  
270 270  [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] CENSUS_CUBE2
271 271  
272 272  * 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.
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]].
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]].
274 274  
275 275  [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE1_IT
276 276  
277 277  * 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.
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]].
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]].
279 279  
280 280  [[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] CENSUS_CUBE2_IT
281 281  
282 282  * 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.
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]].
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]].
285 285  
286 -The (% style="color:#e74c3c" %)Constraints(%%) are defined as follows:
285 +The [[Constraints>>doc:sdmx:Glossary 2\.1.Constraint.WebHome]] are defined as follows:
287 287  
288 -[[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] (% style="color:#e74c3c" %)Constraint
287 +DSD Constraint
289 289  
290 290  [[image:1750065367824-357.png]]
291 291  
292 -[[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]] (% style="color:#e74c3c" %)Constraints
291 +Dataflow Constraints
293 293  
294 294  [[image:1750065392163-400.png]]
295 295  
296 -[[Provision Agreement>>doc:sdmx:Glossary 2\.1.Provision agreement.WebHome]] (% style="color:#e74c3c" %)Constraint
295 +Provision Agreement Constraint
297 297  
298 298  [[image:1750065461589-995.png]]
299 299  
300 -**10.4.7.2 Combination of (% style="color:#e74c3c" %)Constraints(%%)**
299 +**10.4.7.2 Combination of Constraints**
301 301  
302 302  The possible combination of constraining terms are explained in this section, following a few examples.
303 303  
... ... @@ -318,7 +318,7 @@
318 318  
319 319  On the above, let’s assume the following use cases with their constraining requirements:
320 320  
321 -**Use Case 1: A (% style="color:#e74c3c" %)Constraint(%%) on allowed values for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]**
320 +**Use Case 1: A Constraint on allowed values for some Dimensions**
322 322  
323 323  R1: Allow monthly and quarterly data
324 324  
... ... @@ -330,7 +330,7 @@
330 330  |(% style="width:131px" %)(% style="color:#3498db" %)FREQ|(% style="width:153px" %)(% style="color:#3498db" %)M, Q
331 331  |(% style="width:131px" %)(% style="color:#3498db" %)VIS_CTY|(% style="width:153px" %)(% style="color:#3498db" %)MX
332 332  
333 -**Use Case 2: A (% style="color:#e74c3c" %)Constraint(%%) on allowed combinations for some [[Dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]]**
332 +**Use Case 2: A Constraint on allowed combinations for some Dimensions**
334 334  
335 335  R1: Allow monthly data for Germany
336 336  
... ... @@ -344,8 +344,10 @@
344 344  |(% rowspan="2" style="width:105px" %)(% style="color:#2980b9" %)Key2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:143px" %)(% style="color:#2980b9" %)Q
345 345  |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)MX
346 346  
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
346 +**Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes**
348 348  
348 +R1: Allow monthly and quarterly data
349 +
349 349  R2: Allow Mexico for vis-à-vis country
350 350  
351 351  R3: Allow present for status
... ... @@ -357,7 +357,7 @@
357 357  |(% style="width:143px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:139px" %)(% style="color:#2980b9" %)MX
358 358  |(% style="width:143px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:139px" %)(% style="color:#27ae60" %)A
359 359  
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**
361 +**Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
361 361  
362 362  R1: Allow monthly data, for Germany, with [[unit>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]] euro
363 363  
... ... @@ -373,7 +373,7 @@
373 373  |(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)MX
374 374  |(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:142px" %)(% style="color:#27ae60" %)USD
375 375  
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**
377 +**Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
377 377  
378 378  R1: For annually and quarterly data, for Mexico and Germany, only A status is allowed
379 379  
... ... @@ -389,11 +389,11 @@
389 389  |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
390 390  |(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)F
391 391  
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).
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).
393 393  
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]]:
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]]:
395 395  
396 -[[DSD>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] CubeRegion:
397 +DSD CubeRegion:
397 397  
398 398  (% style="width:280.294px" %)
399 399  |(% style="width:156px" %)(% style="color:#2980b9" %)FREQ|(% style="width:121px" %)(% style="color:#2980b9" %)M, Q, A
... ... @@ -414,7 +414,7 @@
414 414  |(% style="width:159px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:126px" %)(% style="color:#2980b9" %)MX, DE
415 415  |(% style="width:159px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:126px" %)(% style="color:#27ae60" %)A
416 416  
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]]**
418 +**Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
418 418  
419 419  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'
420 420  
... ... @@ -430,9 +430,9 @@
430 430  |(% style="width:153px" %)(% style="color:#27ae60" %)[[UNIT>>doc:sdmx:Glossary 2\.1.Statistical unit.WebHome]]|(% style="width:149px" %)(% style="color:#27ae60" %)USD
431 431  |(% style="width:153px" %)CHOICE|(% style="width:149px" %)B
432 432  
433 -**Use Case 7: A (% style="color:#e74c3c" %)Constraint(%%) with wildcards for [[Codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] and removePrefix property**
434 +**Use Case 7: A Constraint with wildcards for Codes and removePrefix property**
434 434  
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.
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.
436 436  
437 437  R1: Allow monthly and quarterly data
438 438  
... ... @@ -446,7 +446,7 @@
446 446  |(% style="width:264px" %)(% style="color:#2980b9" %)FREQ|(% style="width:112px" %)(% style="color:#2980b9" %)M, Q
447 447  |(% style="width:264px" %)(% style="color:#2980b9" %)VIS_CTY (removePrefix=’AREA_’)|(% style="width:112px" %)(% style="color:#2980b9" %)M%
448 448  
449 -**Use Case 8: A (% style="color:#e74c3c" %)Constraint(%%) with multilingual support on [[Attributes>>doc:sdmx:Glossary 2\.1.Attribute.WebHome]]**
450 +**Use Case 8: A Constraint with multilingual support on Attributes**
450 450  
451 451  R1: Allow monthly and quarterly data
452 452  
... ... @@ -461,11 +461,13 @@
461 461  |(% style="width:190px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:189px" %)(% style="color:#2980b9" %)MX
462 462  |(% style="width:190px" %)(% style="color:#27ae60" %)[[COMMENT>>doc:sdmx:Glossary 2\.1.Comment.WebHome]] (lang=’en’)|(% style="width:189px" %)(% style="color:#27ae60" %)%adjusted%
463 463  
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
465 +**Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes**
465 465  
467 +R1: Allow monthly and quarterly data
468 +
466 466  R2: Allow Mexico for vis-à-vis country
467 467  
468 -R3: Allow John Doe for (% style="color:#e74c3c" %)contact(%%)
471 +R3: Allow John Doe for contact
469 469  
470 470  This may be expressed with the following CubeRegion:
471 471  
... ... @@ -472,4 +472,4 @@
472 472  (% style="width:388.294px" %)
473 473  |(% style="width:181px" %)(% style="color:#2980b9" %)FREQ|(% style="width:204px" %)(% style="color:#2980b9" %)M, Q
474 474  |(% style="width:181px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:204px" %)(% style="color:#2980b9" %)MX
475 -|(% style="width:181px" %)(% style="color: rgb(243, 156, 18); color: rgb(231, 76, 60)" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
478 +|(% style="width:181px" %)(% style="color:#e74c3c" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
© Semantic R&D Group, 2026