Changes for page 10 Constraints

Summary

• Page properties (1 modified, 0 added, 0 removed)
• Attachments (0 modified, 0 added, 11 removed)
  • 1747387231598-634.png
  • 1747387252077-954.png
  • 1747387281625-859.png
  • 1747387330751-405.png
  • 1747387369822-932.png
  • 1747387387944-676.png
  • 1747387401689-306.png
  • 1747387437317-733.png
  • 1747387461703-763.png
  • 1747387484366-337.png
  • 1747387514061-293.png

Details

Page properties

Content

...	...	@@ -265,29 +265,42 @@
265	265
266	266	This may be expressed with the following CubeRegion:
267	267
268		-[[image:1747387231598-634.png]]
269	269
	269	+|FREQ|M, Q
	270	+|VIS_CTY|MX
	271	+|OBS_STATUS|A
	272	+
270	270	===== 10.3.4.2.4 Use Case 4: A Constraint on allowed combinations for some =====
271	271
272	272	//**Dimensions combined with specific Attribute values**//
273	273
274	274	R1: Allow monthly data, for Germany, with unit euro
	278	+
275	275	R2: Allow quarterly data, for Mexico, with unit usd
276	276
277	277	This is may be expressed with the following DataKeySet:
278	278
279		-[[image:1747387252077-954.png]]
	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
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
	293	+
286	286	R2: For monthly data, for Mexico and Germany, only F status is allowed
287	287
288	288	Considering the above examples, the following CubeRegions would be created:
289	289
290		-[[image:1747387330751-405.png]]
	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
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,36 @@
295	295
296	296	DSD CubeRegion:
297	297
298		-[[image:1747387369822-932.png]]
	311	+|FREQ|M, Q, A
	312	+|VIS_CTY|MX, DE
	313	+|OBS_STATUS|A, F
299	299
300	300	Dataflow1 CubeRegion:
301	301
302		-[[image:1747387387944-676.png]]
	317	+|FREQ|Q, A
	318	+|VIS_CTY|MX, DE
	319	+|OBS_STATUS|F
303	303
304	304	Dataflow2 CubeRegion:
305	305
306		-[[image:1747387401689-306.png]]
	323	+|FREQ|M
	324	+|VIS_CTY|MX, DE
	325	+|OBS_STATUS|A
307	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'
	330	+
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]]
	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
314	314
315	315	===== 10.3.4.2.7 Use Case 7: A Constraint with wildcards for Codes and removePrefix property =====
316	316
...	...	@@ -317,32 +317,43 @@
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
	347	+
320	320	R2: Allow vis-à-vis countries that start with M
	349	+
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
	354	+|FREQ|M, Q
	355	+|VIS_CTY (removePrefix=’AREA_’)|M%
	356	+
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
	360	+
330	330	R2: Allow Mexico for vis-à-vis country
	362	+
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]]
	367	+|FREQ|M, Q
	368	+|VIS_CTY|MX
	369	+|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
339	339	R1: Allow monthly and quarterly data
	374	+
340	340	R2: Allow Mexico for vis-à-vis country
	376	+
341	341	R3: Allow John Doe for contact
342	342
343	343	This may be expressed with the following CubeRegion:
344	344
345		-[[image:1747387514061-293.png]]
	381	+|FREQ|M, Q
	382	+|VIS_CTY|MX
	383	+|CONTACT|John Doe
346	346
347	347	==== 10.3.4.3 Other constraining terms ====
348	348

1747387231598-634.png

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.helena

Size

...	...	@@ -1,1 +1,0 @@
1		-6.2 KB

Content

1747387252077-954.png

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.helena

Size

...	...	@@ -1,1 +1,0 @@
1		-5.1 KB

Content

1747387281625-859.png

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.helena

Size

...	...	@@ -1,1 +1,0 @@
1		-6.0 KB

Content

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

1747387514061-293.png

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.helena

Size

...	...	@@ -1,1 +1,0 @@
1		-6.3 KB

Content