Skip to Content

Changes for page 10 Constraints

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

Summary

Details

Page properties
Content
... ... @@ -347,9 +347,10 @@
347 347  
348 348  This may be expressed with the following CubeRegion:
349 349  
350 -|FREQ|M, Q
351 -|VIS_CTY|MX
352 -|OBS_STATUS|A
350 +(% style="width:285.294px" %)
351 +|(% style="width:143px" %)(% style="color:#2980b9" %)FREQ|(% style="width:139px" %)(% style="color:#2980b9" %)M, Q
352 +|(% style="width:143px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:139px" %)(% style="color:#2980b9" %)MX
353 +|(% style="width:143px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:139px" %)(% style="color:#27ae60" %)A
353 353  
354 354  **Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
355 355  
... ... @@ -359,12 +359,13 @@
359 359  
360 360  This may be expressed with the following DataKeySet:
361 361  
362 -|(% rowspan="3" %)Key1|FREQ|M
363 -|VIS_CTY|DE
364 -|UNIT|EUR
365 -|(% rowspan="3" %)Key2|FREQ|Q
366 -|VIS_CTY|MX
367 -|UNIT|USD
363 +(% style="width:389.294px" %)
364 +|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)M
365 +|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)DE
366 +|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:142px" %)(% style="color:#27ae60" %)EUR
367 +|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)Q
368 +|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)MX
369 +|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:142px" %)(% style="color:#27ae60" %)USD
368 368  
369 369  **Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
370 370  
... ... @@ -374,12 +374,13 @@
374 374  
375 375  Considering the above examples, the following CubeRegions would be created:
376 376  
377 -|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
378 -|VIS_CTY|MX, DE
379 -|OBS_STATUS|A
380 -|(% rowspan="3" %)CubeRegion2|FREQ|M
381 -|VIS_CTY|MX, DE
382 -|OBS_STATUS|F
379 +(% style="width:449.294px" %)
380 +|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion1|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)Q, A
381 +|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
382 +|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)A
383 +|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)M
384 +|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
385 +|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)F
383 383  
384 384  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).
385 385  
... ... @@ -387,21 +387,24 @@
387 387  
388 388  DSD CubeRegion:
389 389  
390 -|FREQ|M, Q, A
391 -|VIS_CTY|MX, DE
392 -|OBS_STATUS|A, F
393 +(% style="width:280.294px" %)
394 +|(% style="width:156px" %)(% style="color:#2980b9" %)FREQ|(% style="width:121px" %)(% style="color:#2980b9" %)M, Q, A
395 +|(% style="width:156px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:121px" %)(% style="color:#2980b9" %)MX, DE
396 +|(% style="width:156px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:121px" %)(% style="color:#27ae60" %)A, F
393 393  
394 394  Dataflow1 CubeRegion:
395 395  
396 -|FREQ|Q, A
397 -|VIS_CTY|MX, DE
398 -|OBS_STATUS|F
400 +(% style="width:285.294px" %)
401 +|(% style="width:157px" %)(% style="color:#2980b9" %)FREQ|(% style="width:125px" %)(% style="color:#2980b9" %)Q, A
402 +|(% style="width:157px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:125px" %)(% style="color:#2980b9" %)MX, DE
403 +|(% style="width:157px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:125px" %)(% style="color:#27ae60" %)F
399 399  
400 400  Dataflow2 CubeRegion:
401 401  
402 -|FREQ|M
403 -|VIS_CTY|MX, DE
404 -|OBS_STATUS|A
407 +(% style="width:288.294px" %)
408 +|(% style="width:159px" %)(% style="color:#2980b9" %)FREQ|(% style="width:126px" %)(% style="color:#2980b9" %)M
409 +|(% style="width:159px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:126px" %)(% style="color:#2980b9" %)MX, DE
410 +|(% style="width:159px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:126px" %)(% style="color:#27ae60" %)A
405 405  
406 406  **Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
407 407  
... ... @@ -409,14 +409,15 @@
409 409  
410 410  This may be expressed with the following DataKeySet:
411 411  
412 -|(% rowspan="4" %)Key1|FREQ|M
413 -|VIS_CTY|DE
414 -|UNIT|EUR
415 -|CHOICE|A
416 -|(% rowspan="4" %)Key2|FREQ|Q
417 -|VIS_CTY|MX
418 -|UNIT|USD
419 -|CHOICE|B
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
420 420  
421 421  **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.
422 422  
... ... @@ -428,8 +428,9 @@
428 428  
429 429  This may be expressed with the following CubeRegion:
430 430  
431 -|FREQ|M, Q
432 -|VIS_CTY (removePrefix=’AREA_’)|M%
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%
433 433  
434 434  **Use Case 8: A Constraint with multilingual support on Attributes**
435 435  
... ... @@ -441,9 +441,10 @@
441 441  
442 442  This may be expressed with the following CubeRegion:
443 443  
444 -|FREQ|M, Q
445 -|VIS_CTY|MX
446 -|COMMENT (lang=’en’)|%adjusted%
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%
447 447  
448 448  **Use Case 9: A Constraint on allowed values for Dimensions combined with allowed** values for Metadata Attributes R1: Allow monthly and quarterly data
449 449  
... ... @@ -453,6 +453,7 @@
453 453  
454 454  This may be expressed with the following CubeRegion:
455 455  
456 -|FREQ|M, Q
457 -|VIS_CTY|MX
458 -|CONTACT|John Doe
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