Changes for page 10 Constraints

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

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

Summary

Details

Page properties
Content
... ... @@ -237,9 +237,11 @@
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]]
240 240  
241 241  **Figure 20: Example Scenario for Constraints **Constraints are declared as follows:
242 242  
244 +[[image:1750065319060-899.png]]
243 243  
244 244  **Figure 21: Example Constraints**
245 245  
... ... @@ -280,10 +280,16 @@
280 280  
281 281  DSD Constraint
282 282  
285 +[[image:1750065367824-357.png]]
286 +
283 283  Dataflow Constraints
284 284  
289 +[[image:1750065392163-400.png]]
290 +
285 285  Provision Agreement Constraint
286 286  
293 +[[image:1750065461589-995.png]]
294 +
287 287  **10.4.7.2 Combination of Constraints**
288 288  
289 289  The possible combination of constraining terms are explained in this section, following a few examples.
... ... @@ -290,17 +290,18 @@
290 290  
291 291  Let’s assume a DSD with the following Components:
292 292  
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
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
304 304  
305 305  On the above, let’s assume the following use cases with their constraining requirements:
306 306  
... ... @@ -312,8 +312,9 @@
312 312  
313 313  This is expressed with the following CubeRegion:
314 314  
315 -|FREQ|M, Q
316 -|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
317 317  
318 318  **Use Case 2: A Constraint on allowed combinations for some Dimensions**
319 319  
... ... @@ -323,10 +323,11 @@
323 323  
324 324  This is expressed with the following DataKeySet:
325 325  
326 -|Key1|FREQ|M
327 -| |VIS_CTY|DE
328 -|(% rowspan="2" %)Key2|FREQ|Q
329 -|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
330 330  
331 331  **Use Case 3: A Constraint on allowed values for some Dimensions combined with allowed values for some Attributes** R1: Allow monthly and quarterly data
332 332  
1750065279010-260.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +60.3 KB
Content
1750065319060-899.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.helena
Size
... ... @@ -1,0 +1,1 @@
1 +91.0 KB
Content
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