Changes for page 10 Constraints

Last modified by Artur on 2025/09/10 11:19

From version 1.13
edited by Helena
on 2025/06/16 12:20
Change comment: There is no comment for this version
To version 1.5
edited by Helena
on 2025/06/16 12:13
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -237,11 +237,9 @@
237 237  
238 238  In the DSD, common code lists are used and the requirement is to restrict these at various levels to specify the actual code that are valid for the object to which the Constraint is attached.
239 239  
240 -[[image:1750065279010-260.png]]
241 241  
242 242  **Figure 20: Example Scenario for Constraints **Constraints are declared as follows:
243 243  
244 -[[image:1750065319060-899.png]]
245 245  
246 246  **Figure 21: Example Constraints**
247 247  
... ... @@ -282,16 +282,10 @@
282 282  
283 283  DSD Constraint
284 284  
285 -[[image:1750065367824-357.png]]
286 -
287 287  Dataflow Constraints
288 288  
289 -[[image:1750065392163-400.png]]
290 -
291 291  Provision Agreement Constraint
292 292  
293 -[[image:1750065461589-995.png]]
294 -
295 295  **10.4.7.2 Combination of Constraints**
296 296  
297 297  The possible combination of constraining terms are explained in this section, following a few examples.
... ... @@ -298,18 +298,17 @@
298 298  
299 299  Let’s assume a DSD with the following Components:
300 300  
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
293 +|Dimension|FREQ
294 +|Dimension|JD_TYPE
295 +|Dimension|JD_CATEGORY
296 +|Dimension|VIS_CTY
297 +|TimeDimension|TIME_PERIOD
298 +|Attribute|OBS_STATUS
299 +|Attribute|UNIT
300 +|Attribute|COMMENT
301 +|MetadataAttribute|CONTACT
302 +|Measure|MULTISELECT
303 +|Measure|CHOICE
313 313  
314 314  On the above, let’s assume the following use cases with their constraining requirements:
315 315  
... ... @@ -321,9 +321,8 @@
321 321  
322 322  This is expressed with the following CubeRegion:
323 323  
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
315 +|FREQ|M, Q
316 +|VIS_CTY|MX
327 327  
328 328  **Use Case 2: A Constraint on allowed combinations for some Dimensions**
329 329  
... ... @@ -333,11 +333,10 @@
333 333  
334 334  This is expressed with the following DataKeySet:
335 335  
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
326 +|Key1|FREQ|M
327 +| |VIS_CTY|DE
328 +|(% rowspan="2" %)Key2|FREQ|Q
329 +|VIS_CTY|MX
341 341  
342 342  **Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes** R1: Allow monthly and quarterly data
343 343  
... ... @@ -347,10 +347,9 @@
347 347  
348 348  This may be expressed with the following CubeRegion:
349 349  
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
339 +|FREQ|M, Q
340 +|VIS_CTY|MX
341 +|OBS_STATUS|A
354 354  
355 355  **Use Case 4: A Constraint on allowed combinations for some Dimensions combined with specific Attribute values**
356 356  
1750065279010-260.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -60.3 KB
Content
1750065319060-899.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -91.0 KB
Content
1750065367824-357.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -51.4 KB
Content
1750065392163-400.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -104.8 KB
Content
1750065461589-995.png
Author
... ... @@ -1,1 +1,0 @@
1 -xwiki:XWiki.helena
Size
... ... @@ -1,1 +1,0 @@
1 -43.9 KB
Content