Skip to Content

Changes for page 10 Constraints

Last modified by Helena on 2025/09/10 11:19
From version 14.6
edited by Helena
on 2025/05/16 12:24
Change comment: There is no comment for this version
To version 14.3
edited by Helena
on 2025/05/16 12:21
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -278,8 +278,6 @@
278 278  
279 279  [[image:1747387252077-954.png]]
280 280  
281 -[[image:1747387281625-859.png]]
282 -
283 283  ===== 10.3.4.2.5 Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values =====
284 284  
285 285  R1: For annually and quarterly data, for Mexico and Germany, only A status is allowed
... ... @@ -287,7 +287,7 @@
287 287  
288 288  Considering the above examples, the following CubeRegions would be created:
289 289  
290 -[[image:1747387330751-405.png]]
288 +[[image:1747387281625-859.png]]
291 291  
292 292  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).
293 293  
... ... @@ -295,22 +295,24 @@
295 295  
296 296  DSD CubeRegion:
297 297  
298 -[[image:1747387369822-932.png]]
299 -
300 300  Dataflow1 CubeRegion:
301 301  
302 -[[image:1747387387944-676.png]]
303 -
304 304  Dataflow2 CubeRegion:
305 305  
306 -[[image:1747387401689-306.png]]
307 -
308 308  ===== 10.3.4.2.6 Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures =====
309 309  
310 310  R1: Allow monthly data, for Germany, with unit euro, and measure choice is 'A'
303 +
311 311  R2: Allow quarterly data, for Mexico, with unit usd, and measure choice is 'B' This is may be expressed with the following DataKeySet:
312 312  
313 -[[image:1747387437317-733.png]]
306 +|(% rowspan="4" %)Key1|FREQ|M
307 +|VIS_CTY|DE
308 +|UNIT|EUR
309 +|CHOICE|A
310 +|(% rowspan="4" %)Key2|FREQ|Q
311 +|VIS_CTY|MX
312 +|UNIT|USD
313 +|CHOICE|B
314 314  
315 315  ===== 10.3.4.2.7 Use Case 7: A Constraint with wildcards for Codes and removePrefix property =====
316 316  
... ... @@ -317,22 +317,29 @@
317 317  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.
318 318  
319 319  R1: Allow monthly and quarterly data
320 +
320 320  R2: Allow vis-à-vis countries that start with M
322 +
321 321  R3: Remove the prefix ‘AREA_’
322 322  
323 -[[image:1747387461703-763.png]]
324 -
325 325  This may be expressed with the following CubeRegion:
326 326  
327 +|FREQ|M, Q
328 +|VIS_CTY (removePrefix=’AREA_’)|M%
329 +
327 327  ===== 10.3.4.2.8 Use Case 8: A Constraint with multilingual support on Attributes =====
328 328  
329 329  R1: Allow monthly and quarterly data
333 +
330 330  R2: Allow Mexico for vis-à-vis country
335 +
331 331  R3: Allow a comment, in English, which includes the term adjusted for status
332 332  
333 333  This may be expressed with the following CubeRegion:
334 334  
335 -[[image:1747387484366-337.png]]
340 +|FREQ|M, Q
341 +|VIS_CTY|MX
342 +|COMMENT (lang=’en’)|%adjusted%
336 336  
337 337  ===== 10.3.4.2.9 Use Case 9: A Constraint on allowed values for Dimensions combined with allowed values for Metadata Attributes =====
338 338  
1747387330751-405.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -15.8 KB
Content
1747387369822-932.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -6.9 KB
Content
1747387387944-676.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -6.2 KB
Content
1747387401689-306.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -6.0 KB
Content
1747387437317-733.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -13.9 KB
Content
1747387461703-763.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -6.5 KB
Content
1747387484366-337.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -9.0 KB
Content