Skip to Content

Changes for page 10 Constraints

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

Summary

Details

Page properties
Content
... ... @@ -360,12 +360,13 @@
360 360  
361 361  This may be expressed with the following DataKeySet:
362 362  
363 -|(% rowspan="3" %)Key1|FREQ|M
364 -|VIS_CTY|DE
365 -|UNIT|EUR
366 -|(% rowspan="3" %)Key2|FREQ|Q
367 -|VIS_CTY|MX
368 -|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
369 369  
370 370  **Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
371 371  
... ... @@ -375,12 +375,13 @@
375 375  
376 376  Considering the above examples, the following CubeRegions would be created:
377 377  
378 -|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
379 -|VIS_CTY|MX, DE
380 -|OBS_STATUS|A
381 -|(% rowspan="3" %)CubeRegion2|FREQ|M
382 -|VIS_CTY|MX, DE
383 -|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
384 384  
385 385  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).
386 386  
... ... @@ -388,21 +388,24 @@
388 388  
389 389  DSD CubeRegion:
390 390  
391 -|FREQ|M, Q, A
392 -|VIS_CTY|MX, DE
393 -|OBS_STATUS|A, F
393 +(% style="width:280.294px" %)
394 +|(% style="width:156px" %)FREQ|(% style="width:121px" %)M, Q, A
395 +|(% style="width:156px" %)VIS_CTY|(% style="width:121px" %)MX, DE
396 +|(% style="width:156px" %)OBS_STATUS|(% style="width:121px" %)A, F
394 394  
395 395  Dataflow1 CubeRegion:
396 396  
397 -|FREQ|Q, A
398 -|VIS_CTY|MX, DE
399 -|OBS_STATUS|F
400 +(% style="width:285.294px" %)
401 +|(% style="width:157px" %)FREQ|(% style="width:125px" %)Q, A
402 +|(% style="width:157px" %)VIS_CTY|(% style="width:125px" %)MX, DE
403 +|(% style="width:157px" %)OBS_STATUS|(% style="width:125px" %)F
400 400  
401 401  Dataflow2 CubeRegion:
402 402  
403 -|FREQ|M
404 -|VIS_CTY|MX, DE
405 -|OBS_STATUS|A
407 +(% style="width:288.294px" %)
408 +|(% style="width:159px" %)FREQ|(% style="width:126px" %)M
409 +|(% style="width:159px" %)VIS_CTY|(% style="width:126px" %)MX, DE
410 +|(% style="width:159px" %)OBS_STATUS|(% style="width:126px" %)A
406 406  
407 407  **Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
408 408