Skip to Content

Changes for page 10 Constraints

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

Summary

Details

Page properties
Content
... ... @@ -282,12 +282,15 @@
282 282  
283 283  DSD Constraint
284 284  
285 +[[image:1750065367824-357.png]]
285 285  
286 286  Dataflow Constraints
287 287  
289 +[[image:1750065392163-400.png]]
288 288  
289 289  Provision Agreement Constraint
290 290  
293 +[[image:1750065461589-995.png]]
291 291  
292 292  **10.4.7.2 Combination of Constraints**
293 293  
... ... @@ -295,17 +295,18 @@
295 295  
296 296  Let’s assume a DSD with the following Components:
297 297  
298 -|Dimension|FREQ
299 -|Dimension|JD_TYPE
300 -|Dimension|JD_CATEGORY
301 -|Dimension|VIS_CTY
302 -|TimeDimension|TIME_PERIOD
303 -|Attribute|OBS_STATUS
304 -|Attribute|UNIT
305 -|Attribute|COMMENT
306 -|MetadataAttribute|CONTACT
307 -|Measure|MULTISELECT
308 -|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
309 309  
310 310  On the above, let’s assume the following use cases with their constraining requirements:
311 311  
... ... @@ -317,8 +317,9 @@
317 317  
318 318  This is expressed with the following CubeRegion:
319 319  
320 -|FREQ|M, Q
321 -|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
322 322  
323 323  **Use Case 2: A Constraint on allowed combinations for some Dimensions**
324 324  
... ... @@ -328,10 +328,11 @@
328 328  
329 329  This is expressed with the following DataKeySet:
330 330  
331 -|Key1|FREQ|M
332 -| |VIS_CTY|DE
333 -|(% rowspan="2" %)Key2|FREQ|Q
334 -|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
335 335  
336 336  **Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes** R1: Allow monthly and quarterly data
337 337  
... ... @@ -341,9 +341,10 @@
341 341  
342 342  This may be expressed with the following CubeRegion:
343 343  
344 -|FREQ|M, Q
345 -|VIS_CTY|MX
346 -|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
347 347  
348 348  **Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
349 349  
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