Skip to Content

Changes for page 10 Constraints

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

Summary

Details

Page properties
Content
... ... @@ -376,13 +376,12 @@
376 376  
377 377  Considering the above examples, the following CubeRegions would be created:
378 378  
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
379 +|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
380 +|VIS_CTY|MX, DE
381 +|OBS_STATUS|A
382 +|(% rowspan="3" %)CubeRegion2|FREQ|M
383 +|VIS_CTY|MX, DE
384 +|OBS_STATUS|F
386 386  
387 387  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).
388 388  
... ... @@ -390,24 +390,21 @@
390 390  
391 391  DSD CubeRegion:
392 392  
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
392 +|FREQ|M, Q, A
393 +|VIS_CTY|MX, DE
394 +|OBS_STATUS|A, F
397 397  
398 398  Dataflow1 CubeRegion:
399 399  
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
398 +|FREQ|Q, A
399 +|VIS_CTY|MX, DE
400 +|OBS_STATUS|F
404 404  
405 405  Dataflow2 CubeRegion:
406 406  
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
404 +|FREQ|M
405 +|VIS_CTY|MX, DE
406 +|OBS_STATUS|A
411 411  
412 412  **Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
413 413