Changes for page 10 Constraints

Summary

• Page properties (1 modified, 0 added, 0 removed)
• Objects (1 modified, 0 added, 0 removed)
  • SUZ.Methodology.Code.MethodologyClass[0]

Details

Page properties

Content

...	...	@@ -298,18 +298,18 @@
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
	301	+(% style="width:519.294px" %)
	302	+|(% style="width:259px" %)Dimension|(% style="width:257px" %)FREQ
	303	+|(% style="width:259px" %)Dimension|(% style="width:257px" %)JD_TYPE
	304	+|(% style="width:259px" %)Dimension|(% style="width:257px" %)JD_CATEGORY
	305	+|(% style="width:259px" %)Dimension|(% style="width:257px" %)VIS_CTY
	306	+|(% style="width:259px" %)TimeDimension|(% style="width:257px" %)TIME_PERIOD
	307	+|(% style="width:259px" %)Attribute|(% style="width:257px" %)OBS_STATUS
	308	+|(% style="width:259px" %)Attribute|(% style="width:257px" %)UNIT
	309	+|(% style="width:259px" %)Attribute|(% style="width:257px" %)COMMENT
	310	+|(% style="width:259px" %)MetadataAttribute|(% style="width:257px" %)CONTACT
	311	+|(% style="width:259px" %)Measure|(% style="width:257px" %)MULTISELECT
	312	+|(% style="width:259px" %)Measure|(% style="width:257px" %)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
	324	+|FREQ|M, Q
	325	+|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
	335	+|Key1|FREQ|M
	336	+| |VIS_CTY|DE
	337	+|(% rowspan="2" %)Key2|FREQ|Q
	338	+|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
	348	+|FREQ|M, Q
	349	+|VIS_CTY|MX
	350	+|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
...	...	@@ -360,13 +360,12 @@
360	360
361	361	This may be expressed with the following DataKeySet:
362	362
363		-(% style="width:389.294px" %)
364		-|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)M
365		-|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)DE
366		-|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:142px" %)(% style="color:#27ae60" %)EUR
367		-|(% rowspan="3" style="width:89px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:142px" %)(% style="color:#2980b9" %)Q
368		-|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:142px" %)(% style="color:#2980b9" %)MX
369		-|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:142px" %)(% style="color:#27ae60" %)USD
	360	+|(% rowspan="3" %)Key1|FREQ|M
	361	+|VIS_CTY|DE
	362	+|UNIT|EUR
	363	+|(% rowspan="3" %)Key2|FREQ|Q
	364	+|VIS_CTY|MX
	365	+|UNIT|USD
370	370
371	371	**Use Case 5: A Constraint on allowed values for some Dimensions together with some combination of Dimension values**
372	372
...	...	@@ -376,13 +376,12 @@
376	376
377	377	Considering the above examples, the following CubeRegions would be created:
378	378
379		-(% style="width:449.294px" %)
380		-|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion1|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)Q, A
381		-|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
382		-|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)A
383		-|(% rowspan="3" style="width:126px" %)(% style="color:#2980b9" %)CubeRegion2|(% style="width:137px" %)(% style="color:#2980b9" %)FREQ|(% style="width:183px" %)(% style="color:#2980b9" %)M
384		-|(% style="width:137px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:183px" %)(% style="color:#2980b9" %)MX, DE
385		-|(% style="width:137px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:183px" %)(% style="color:#27ae60" %)F
	375	+|(% rowspan="3" %)CubeRegion1|FREQ|Q, A
	376	+|VIS_CTY|MX, DE
	377	+|OBS_STATUS|A
	378	+|(% rowspan="3" %)CubeRegion2|FREQ|M
	379	+|VIS_CTY|MX, DE
	380	+|OBS_STATUS|F
386	386
387	387	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).
388	388
...	...	@@ -390,24 +390,21 @@
390	390
391	391	DSD CubeRegion:
392	392
393		-(% style="width:280.294px" %)
394		-|(% style="width:156px" %)(% style="color:#2980b9" %)FREQ|(% style="width:121px" %)(% style="color:#2980b9" %)M, Q, A
395		-|(% style="width:156px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:121px" %)(% style="color:#2980b9" %)MX, DE
396		-|(% style="width:156px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:121px" %)(% style="color:#27ae60" %)A, F
	388	+|FREQ|M, Q, A
	389	+|VIS_CTY|MX, DE
	390	+|OBS_STATUS|A, F
397	397
398	398	Dataflow1 CubeRegion:
399	399
400		-(% style="width:285.294px" %)
401		-|(% style="width:157px" %)(% style="color:#2980b9" %)FREQ|(% style="width:125px" %)(% style="color:#2980b9" %)Q, A
402		-|(% style="width:157px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:125px" %)(% style="color:#2980b9" %)MX, DE
403		-|(% style="width:157px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:125px" %)(% style="color:#27ae60" %)F
	394	+|FREQ|Q, A
	395	+|VIS_CTY|MX, DE
	396	+|OBS_STATUS|F
404	404
405	405	Dataflow2 CubeRegion:
406	406
407		-(% style="width:288.294px" %)
408		-|(% style="width:159px" %)(% style="color:#2980b9" %)FREQ|(% style="width:126px" %)(% style="color:#2980b9" %)M
409		-|(% style="width:159px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:126px" %)(% style="color:#2980b9" %)MX, DE
410		-|(% style="width:159px" %)(% style="color:#27ae60" %)OBS_STATUS|(% style="width:126px" %)(% style="color:#27ae60" %)A
	400	+|FREQ|M
	401	+|VIS_CTY|MX, DE
	402	+|OBS_STATUS|A
411	411
412	412	**Use case 6: A Constraint on allowed values for some Dimensions combined with allowed values for Measures**
413	413
...	...	@@ -415,15 +415,14 @@
415	415
416	416	This may be expressed with the following DataKeySet:
417	417
418		-(% style="width:404.294px" %)
419		-|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key1|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)M
420		-|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)DE
421		-|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:149px" %)(% style="color:#27ae60" %)EUR
422		-|(% style="width:153px" %)(% style="color:#e74c3c" %)CHOICE|(% style="width:149px" %)(% style="color:#e74c3c" %)A
423		-|(% rowspan="4" style="width:99px" %)(% style="color:#2980b9" %)Key2|(% style="width:153px" %)(% style="color:#2980b9" %)FREQ|(% style="width:149px" %)(% style="color:#2980b9" %)Q
424		-|(% style="width:153px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:149px" %)(% style="color:#2980b9" %)MX
425		-|(% style="width:153px" %)(% style="color:#27ae60" %)UNIT|(% style="width:149px" %)(% style="color:#27ae60" %)USD
426		-|(% style="width:153px" %)(% style="color:#e74c3c" %)CHOICE|(% style="width:149px" %)(% style="color:#e74c3c" %)B
	410	+|(% rowspan="4" %)Key1|FREQ|M
	411	+|VIS_CTY|DE
	412	+|UNIT|EUR
	413	+|CHOICE|A
	414	+|(% rowspan="4" %)Key2|FREQ|Q
	415	+|VIS_CTY|MX
	416	+|UNIT|USD
	417	+|CHOICE|B
427	427
428	428	**Use Case 7: A Constraint with wildcards for Codes and removePrefix property** 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.
429	429
...	...	@@ -435,9 +435,8 @@
435	435
436	436	This may be expressed with the following CubeRegion:
437	437
438		-(% style="width:379.294px" %)
439		-|(% style="width:264px" %)(% style="color:#2980b9" %)FREQ|(% style="width:112px" %)(% style="color:#2980b9" %)M, Q
440		-|(% style="width:264px" %)(% style="color:#2980b9" %)VIS_CTY (removePrefix=’AREA_’)|(% style="width:112px" %)(% style="color:#2980b9" %)M%
	429	+|FREQ|M, Q
	430	+|VIS_CTY (removePrefix=’AREA_’)|M%
441	441
442	442	**Use Case 8: A Constraint with multilingual support on Attributes**
443	443
...	...	@@ -449,10 +449,9 @@
449	449
450	450	This may be expressed with the following CubeRegion:
451	451
452		-(% style="width:382.294px" %)
453		-|(% style="width:190px" %)(% style="color:#2980b9" %)FREQ|(% style="width:189px" %)(% style="color:#2980b9" %)M, Q
454		-|(% style="width:190px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:189px" %)(% style="color:#2980b9" %)MX
455		-|(% style="width:190px" %)(% style="color:#27ae60" %)COMMENT (lang=’en’)|(% style="width:189px" %)(% style="color:#27ae60" %)%adjusted%
	442	+|FREQ|M, Q
	443	+|VIS_CTY|MX
	444	+|COMMENT (lang=’en’)|%adjusted%
456	456
457	457	**Use Case 9: A Constraint on allowed values for Dimensions combined with allowed** values for Metadata Attributes R1: Allow monthly and quarterly data
458	458
...	...	@@ -462,7 +462,6 @@
462	462
463	463	This may be expressed with the following CubeRegion:
464	464
465		-(% style="width:388.294px" %)
466		-|(% style="width:181px" %)(% style="color:#2980b9" %)FREQ|(% style="width:204px" %)(% style="color:#2980b9" %)M, Q
467		-|(% style="width:181px" %)(% style="color:#2980b9" %)VIS_CTY|(% style="width:204px" %)(% style="color:#2980b9" %)MX
468		-|(% style="width:181px" %)(% style="color:#f39c12" %)CONTACT|(% style="width:204px" %)(% style="color:#f39c12" %)John Doe
	454	+|FREQ|M, Q
	455	+|VIS_CTY|MX
	456	+|CONTACT|John Doe

SUZ.Methodology.Code.MethodologyClass[0]

index

...	...	@@ -1,1 +1,0 @@
1		-10