Skip to Content

Changes for page 10 Constraints

Last modified by Artur on 2025/09/10 11:19
From version 2.1
edited by Helena
on 2025/06/16 12:25
Change comment: There is no comment for this version
To version 1.16
edited by Helena
on 2025/06/16 12:23
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -415,15 +415,14 @@
415 415  
416 416  This may be expressed with the following DataKeySet:
417 417  
418 -(% style="width:404.294px" %)
419 -|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)M
420 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)DE
421 -|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:149px" %)(% style="color:#27ae60" %)EUR
422 -|(% style="width:153px" %)(% style="color:#e74c3c" %)CHOICE|(% style="width:149px" %)(% style="color:#e74c3c" %)A
423 -|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)Q
424 -|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)MX
425 -|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:149px" %)(% style="color:#27ae60" %)USD
426 -|(% style="width:153px" %)(% style="color:#e74c3c" %)CHOICE|(% style="width:149px" %)(% style="color:#e74c3c" %)B
418 +|(% rowspan="4" %)Key1|FREQ|M
419 +|VIS_CTY|DE
420 +|UNIT|EUR
421 +|CHOICE|A
422 +|(% rowspan="4" %)Key2|FREQ|Q
423 +|VIS_CTY|MX
424 +|UNIT|USD
425 +|CHOICE|B
427 427  
428 428  **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.
429 429  
... ... @@ -435,9 +435,8 @@
435 435  
436 436  This may be expressed with the following CubeRegion:
437 437  
438 -(% style="width:379.294px" %)
439 -|(% style="width:264px" %)(% style="color:#2980b9" %)FREQ|(% style="width:112px" %)(% style="color:#2980b9" %)M, Q
440 -|(% style="width:264px" %)(% style="color:#2980b9" %)VIS_CTY (removePrefix=’AREA_’)|(% style="width:112px" %)(% style="color:#2980b9" %)M%
437 +|FREQ|M, Q
438 +|VIS_CTY (removePrefix=’AREA_’)|M%
441 441  
442 442  **Use Case 8: A Constraint with multilingual support on Attributes**
443 443  
... ... @@ -449,10 +449,9 @@
449 449  
450 450  This may be expressed with the following CubeRegion:
451 451  
452 -(% style="width:382.294px" %)
453 -|(% style="width:190px" %)(% style="color:#2980b9" %)FREQ|(% style="width:189px" %)(% style="color:#2980b9" %)M, Q
454 -|(% style="width:190px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:189px" %)(% style="color:#2980b9" %)MX
455 -|(% style="width:190px" %)(% style="color:#27ae60" %)COMMENT (lang=’en’)|(% style="width:189px" %)(% style="color:#27ae60" %)%adjusted%
450 +|FREQ|M, Q
451 +|VIS_CTY|MX
452 +|COMMENT (lang=’en’)|%adjusted%
456 456  
457 457  **Use Case 9: A Constraint on allowed values for Dimensions combined with allowed** values for Metadata Attributes R1: Allow monthly and quarterly data
458 458  
... ... @@ -462,7 +462,6 @@
462 462  
463 463  This may be expressed with the following CubeRegion:
464 464  
465 -(% style="width:388.294px" %)
466 -|(% style="width:181px" %)(% style="color:#2980b9" %)FREQ|(% style="width:204px" %)(% style="color:#2980b9" %)M, Q
467 -|(% style="width:181px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:204px" %)(% style="color:#2980b9" %)MX
468 -|(% style="width:181px" %)(% style="color:#f39c12" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
462 +|FREQ|M, Q
463 +|VIS_CTY|MX
464 +|CONTACT|John Doe