Skip to Content

Changes for page 10 Constraints

Last modified by Artur on 2025/09/10 11:19
From version 1.6
edited by Helena
on 2025/06/16 12:15
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
... ... @@ -282,10 +282,16 @@
282 282  
283 283  DSD Constraint
284 284  
285 +[[image:1750065367824-357.png]]
286 +
285 285  Dataflow Constraints
286 286  
289 +[[image:1750065392163-400.png]]
290 +
287 287  Provision Agreement Constraint
288 288  
293 +[[image:1750065461589-995.png]]
294 +
289 289  **10.4.7.2 Combination of Constraints**
290 290  
291 291  The possible combination of constraining terms are explained in this section, following a few examples.
... ... @@ -292,17 +292,18 @@
292 292  
293 293  Let’s assume a DSD with the following Components:
294 294  
295 -|Dimension|FREQ
296 -|Dimension|JD_TYPE
297 -|Dimension|JD_CATEGORY
298 -|Dimension|VIS_CTY
299 -|TimeDimension|TIME_PERIOD
300 -|Attribute|OBS_STATUS
301 -|Attribute|UNIT
302 -|Attribute|COMMENT
303 -|MetadataAttribute|CONTACT
304 -|Measure|MULTISELECT
305 -|Measure|CHOICE
301 +(% style="width:459.294px" %)
302 +|(% style="width:204px" %)(% style="color:#3498db" %)Dimension|(% style="width:252px" %)(% style="color:#3498db" %)FREQ
303 +|(% style="width:204px" %)(% style="color:#3498db" %)Dimension|(% style="width:252px" %)(% style="color:#3498db" %)JD_TYPE
304 +|(% style="width:204px" %)(% style="color:#3498db" %)Dimension|(% style="width:252px" %)(% style="color:#3498db" %)JD_CATEGORY
305 +|(% style="width:204px" %)(% style="color:#3498db" %)Dimension|(% style="width:252px" %)(% style="color:#3498db" %)VIS_CTY
306 +|(% style="width:204px" %)(% style="color:#2980b9" %)TimeDimension|(% style="width:252px" %)(% style="color:#2980b9" %)TIME_PERIOD
307 +|(% style="width:204px" %)(% style="color:#16a085" %)Attribute|(% style="width:252px" %)(% style="color:#16a085" %)OBS_STATUS
308 +|(% style="width:204px" %)(% style="color:#16a085" %)Attribute|(% style="width:252px" %)(% style="color:#16a085" %)UNIT
309 +|(% style="width:204px" %)(% style="color:#16a085" %)Attribute|(% style="width:252px" %)(% style="color:#16a085" %)COMMENT
310 +|(% style="width:204px" %)(% style="color:#f39c12" %)MetadataAttribute|(% style="width:252px" %)(% style="color:#f39c12" %)CONTACT
311 +|(% style="width:204px" %)(% style="color:#e74c3c" %)Measure|(% style="width:252px" %)(% style="color:#e74c3c" %)MULTISELECT
312 +|(% style="width:204px" %)(% style="color:#e74c3c" %)Measure|(% style="width:252px" %)(% style="color:#e74c3c" %)CHOICE
306 306  
307 307  On the above, let’s assume the following use cases with their constraining requirements:
308 308  
... ... @@ -314,8 +314,9 @@
314 314  
315 315  This is expressed with the following CubeRegion:
316 316  
317 -|FREQ|M, Q
318 -|VIS_CTY|MX
324 +(% style="width:287.294px" %)
325 +|(% style="width:131px" %)(% style="color:#3498db" %)FREQ|(% style="width:153px" %)(% style="color:#3498db" %)M, Q
326 +|(% style="width:131px" %)(% style="color:#3498db" %)VIS_CTY|(% style="width:153px" %)(% style="color:#3498db" %)MX
319 319  
320 320  **Use Case 2: A Constraint on allowed combinations for some Dimensions**
321 321  
... ... @@ -325,10 +325,11 @@
325 325  
326 326  This is expressed with the following DataKeySet:
327 327  
328 -|Key1|FREQ|M
329 -| |VIS_CTY|DE
330 -|(% rowspan="2" %)Key2|FREQ|Q
331 -|VIS_CTY|MX
336 +(% style="width:388.294px" %)
337 +|(% style="width:105px" %)(% style="color:#2980b9" %)Key1|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:143px" %)(% style="color:#2980b9" %)M
338 +|(% style="width:105px" %) |(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)DE
339 +|(% rowspan="2" style="width:105px" %)(% style="color:#2980b9" %)Key2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:143px" %)(% style="color:#2980b9" %)Q
340 +|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:143px" %)(% style="color:#2980b9" %)MX
332 332  
333 333  **Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes** R1: Allow monthly and quarterly data
334 334  
... ... @@ -338,9 +338,10 @@
338 338  
339 339  This may be expressed with the following CubeRegion:
340 340  
341 -|FREQ|M, Q
342 -|VIS_CTY|MX
343 -|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
344 344  
345 345  **Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
346 346  
... ... @@ -350,12 +350,13 @@
350 350  
351 351  This may be expressed with the following DataKeySet:
352 352  
353 -|(% rowspan="3" %)Key1|FREQ|M
354 -|VIS_CTY|DE
355 -|UNIT|EUR
356 -|(% rowspan="3" %)Key2|FREQ|Q
357 -|VIS_CTY|MX
358 -|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
359 359  
360 360  **Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
361 361  
... ... @@ -365,12 +365,13 @@
365 365  
366 366  Considering the above examples, the following CubeRegions would be created:
367 367  
368 -|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
369 -|VIS_CTY|MX, DE
370 -|OBS_STATUS|A
371 -|(% rowspan="3" %)CubeRegion2|FREQ|M
372 -|VIS_CTY|MX, DE
373 -|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
374 374  
375 375  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).
376 376  
... ... @@ -378,21 +378,24 @@
378 378  
379 379  DSD CubeRegion:
380 380  
381 -|FREQ|M, Q, A
382 -|VIS_CTY|MX, DE
383 -|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
384 384  
385 385  Dataflow1 CubeRegion:
386 386  
387 -|FREQ|Q, A
388 -|VIS_CTY|MX, DE
389 -|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
390 390  
391 391  Dataflow2 CubeRegion:
392 392  
393 -|FREQ|M
394 -|VIS_CTY|MX, DE
395 -|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
396 396  
397 397  **Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
398 398  
1750065367824-357.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +51.4 KB
Content
1750065392163-400.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +104.8 KB
Content
1750065461589-995.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +43.9 KB
Content