Skip to Content

Changes for page 10 Constraints

Last modified by Helena on 2025/09/10 11:19
From version 14.2
edited by Helena
on 2025/05/16 12:20
Change comment: There is no comment for this version
To version 15.1
edited by Helena
on 2025/05/16 12:25
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -265,42 +265,29 @@
265 265  
266 266  This may be expressed with the following CubeRegion:
267 267  
268 +[[image:1747387231598-634.png]]
268 268  
269 -|FREQ|M, Q
270 -|VIS_CTY|MX
271 -|OBS_STATUS|A
272 -
273 273  ===== 10.3.4.2.4 Use Case 4: A Constraint on allowed combinations for some =====
274 274  
275 275  //**Dimensions combined with specific Attribute values**//
276 276  
277 277  R1: Allow monthly data, for Germany, with unit euro
278 -
279 279  R2: Allow quarterly data, for Mexico, with unit usd
280 280  
281 281  This is may be expressed with the following DataKeySet:
282 282  
283 -|(% rowspan="3" style="width:87px" %)Key1|(% style="width:1327px" %)FREQ|M
284 -|(% style="width:1327px" %)VIS_CTY|DE
285 -|(% style="width:1327px" %)UNIT|EUR
286 -|(% rowspan="3" style="width:87px" %)Key2|(% style="width:1327px" %)FREQ|Q
287 -|(% style="width:1327px" %)VIS_CTY|MX
288 -|(% style="width:1327px" %)UNIT|USD
279 +[[image:1747387252077-954.png]]
289 289  
281 +[[image:1747387281625-859.png]]
282 +
290 290  ===== 10.3.4.2.5 Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values =====
291 291  
292 292  R1: For annually and quarterly data, for Mexico and Germany, only A status is allowed
293 -
294 294  R2: For monthly data, for Mexico and Germany, only F status is allowed
295 295  
296 296  Considering the above examples, the following CubeRegions would be created:
297 297  
298 -|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
299 -|VIS_CTY|MX, DE
300 -|OBS_STATUS|A
301 -|(% rowspan="3" %)CubeRegion2|FREQ|M
302 -|VIS_CTY|MX, DE
303 -|OBS_STATUS|F
290 +[[image:1747387330751-405.png]]
304 304  
305 305  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).
306 306  
... ... @@ -308,36 +308,22 @@
308 308  
309 309  DSD CubeRegion:
310 310  
311 -|FREQ|M, Q, A
312 -|VIS_CTY|MX, DE
313 -|OBS_STATUS|A, F
298 +[[image:1747387369822-932.png]]
314 314  
315 315  Dataflow1 CubeRegion:
316 316  
317 -|FREQ|Q, A
318 -|VIS_CTY|MX, DE
319 -|OBS_STATUS|F
302 +[[image:1747387387944-676.png]]
320 320  
321 321  Dataflow2 CubeRegion:
322 322  
323 -|FREQ|M
324 -|VIS_CTY|MX, DE
325 -|OBS_STATUS|A
306 +[[image:1747387401689-306.png]]
326 326  
327 327  ===== 10.3.4.2.6 Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures =====
328 328  
329 329  R1: Allow monthly data, for Germany, with unit euro, and measure choice is 'A'
330 -
331 331  R2: Allow quarterly data, for Mexico, with unit usd, and measure choice is 'B' This is may be expressed with the following DataKeySet:
332 332  
333 -|(% rowspan="4" %)Key1|FREQ|M
334 -|VIS_CTY|DE
335 -|UNIT|EUR
336 -|CHOICE|A
337 -|(% rowspan="4" %)Key2|FREQ|Q
338 -|VIS_CTY|MX
339 -|UNIT|USD
340 -|CHOICE|B
313 +[[image:1747387437317-733.png]]
341 341  
342 342  ===== 10.3.4.2.7 Use Case 7: A Constraint with wildcards for Codes and removePrefix property =====
343 343  
... ... @@ -344,43 +344,32 @@
344 344  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.
345 345  
346 346  R1: Allow monthly and quarterly data
347 -
348 348  R2: Allow vis-à-vis countries that start with M
349 -
350 350  R3: Remove the prefix ‘AREA_’
351 351  
323 +[[image:1747387461703-763.png]]
324 +
352 352  This may be expressed with the following CubeRegion:
353 353  
354 -|FREQ|M, Q
355 -|VIS_CTY (removePrefix=’AREA_’)|M%
356 -
357 357  ===== 10.3.4.2.8 Use Case 8: A Constraint with multilingual support on Attributes =====
358 358  
359 359  R1: Allow monthly and quarterly data
360 -
361 361  R2: Allow Mexico for vis-à-vis country
362 -
363 363  R3: Allow a comment, in English, which includes the term adjusted for status
364 364  
365 365  This may be expressed with the following CubeRegion:
366 366  
367 -|FREQ|M, Q
368 -|VIS_CTY|MX
369 -|COMMENT (lang=’en’)|%adjusted%
335 +[[image:1747387484366-337.png]]
370 370  
371 371  ===== 10.3.4.2.9 Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes =====
372 372  
373 373  R1: Allow monthly and quarterly data
374 -
375 375  R2: Allow Mexico for vis-à-vis country
376 -
377 377  R3: Allow John Doe for contact
378 378  
379 379  This may be expressed with the following CubeRegion:
380 380  
381 -|FREQ|M, Q
382 -|VIS_CTY|MX
383 -|CONTACT|John Doe
345 +[[image:1747387514061-293.png]]
384 384  
385 385  ==== 10.3.4.3 Other constraining terms ====
386 386  
1747387231598-634.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.2 KB
Content
1747387252077-954.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +5.1 KB
Content
1747387281625-859.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.0 KB
Content
1747387330751-405.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +15.8 KB
Content
1747387369822-932.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.9 KB
Content
1747387387944-676.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.2 KB
Content
1747387401689-306.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.0 KB
Content
1747387437317-733.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +13.9 KB
Content
1747387461703-763.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.5 KB
Content
1747387484366-337.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +9.0 KB
Content
1747387514061-293.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +6.3 KB
Content