Changes for page 13 Structure Mapping
Last modified by Helena on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 1 removed)
Details
- Page properties
-
- Content
-
... ... @@ -311,29 +311,30 @@ 311 311 The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved): 312 312 313 313 (% style="width:896.294px" %) 314 -|(% style="width:133px" %)**Letter**|(% style="width:414px" %)**Date or Time Component**|(% style="width:157px" %)**Presentation**|(% style="width:172px" %)**Examples** 315 -|(% style="width:133px" %)G|(% style="width:414px" %)Era designator|(% style="width:157px" %)Text|(% style="width:172px" %)AD 316 -|(% style="width:133px" %)yy|(% style="width:414px" %)Year short (upper case is Year of Week{{footnote}}yyyy represents the calendar year while YYYY represents the year of the week, which is only relevant for 53 week years{{/footnote}})|(% style="width:157px" %)Year|(% style="width:172px" %)96 317 -|(% style="width:133px" %)yyyy|(% style="width:414px" %)Year Full (upper case is Year of Week)|(% style="width:157px" %)Year|(% style="width:172px" %)1996 318 -|(% style="width:133px" %)MM|(% style="width:414px" %)Month number in year starting with 1|(% style="width:157px" %)Month|(% style="width:172px" %)07 319 -|(% style="width:133px" %)MMM|(% style="width:414px" %)Month name short|(% style="width:157px" %)Month|(% style="width:172px" %)Jul 320 -|(% style="width:133px" %)MMMM|(% style="width:414px" %)Month name full|(% style="width:157px" %)Month|(% style="width:172px" %)July 321 -|(% style="width:133px" %)ww|(% style="width:414px" %)Week in year|(% style="width:157px" %)Number|(% style="width:172px" %)27 322 -|(% style="width:133px" %)W|(% style="width:414px" %)Week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2 323 -|(% style="width:133px" %)DD|(% style="width:414px" %)Day in year|(% style="width:157px" %)Number|(% style="width:172px" %)189 324 -|(% style="width:133px" %)dd|(% style="width:414px" %)Day in month|(% style="width:157px" %)Number|(% style="width:172px" %)10 325 -|(% style="width:133px" %)F|(% style="width:414px" %)Day of week in month|(% style="width:157px" %)Number|(% style="width:172px" %)2 326 -|(% style="width:133px" %)E|(% style="width:414px" %)Day name in week|(% style="width:157px" %)Text|(% style="width:172px" %)Tuesday; Tue 327 -|(% style="width:132px" %)U|(% style="width:414px" %)Day number of week (1 = Monday, ..., 7 = Sunday)|(% style="width:157px" %)Number|(% style="width:217px" %)1 328 -|(% style="width:132px" %)HH|(% style="width:414px" %)Hour in day (0-23)|(% style="width:157px" %)Number|(% style="width:217px" %)0 329 -|(% style="width:132px" %)kk|(% style="width:414px" %)Hour in day (1-24)|(% style="width:157px" %)Number|(% style="width:217px" %)24 330 -|(% style="width:132px" %)KK|(% style="width:414px" %)Hour in am/pm (0-11)|(% style="width:157px" %)Number|(% style="width:217px" %)0 331 -|(% style="width:132px" %)hh|(% style="width:414px" %)Hour in am/pm (1-12)|(% style="width:157px" %)Number|(% style="width:217px" %)12 332 -|(% style="width:132px" %)mm|(% style="width:414px" %)Minute in hour|(% style="width:157px" %)Number|(% style="width:217px" %)30 333 -|(% style="width:132px" %)ss|(% style="width:414px" %)Second in minute|(% style="width:157px" %)Number|(% style="width:217px" %)55 334 -|(% style="width:132px" %)S|(% style="width:414px" %)Millisecond|(% style="width:157px" %)Number|(% style="width:217px" %)978 335 -|(% style="width:132px" %)n|(% style="width:414px" %)Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|(% style="width:157px" %)Number|(% style="width:217px" %)12 314 +|**Letter**|(% style="width:340px" %)**Date or Time Component**|(% style="width:153px" %)**Presentation**|(% style="width:172px" %)Examples 315 +|G|(% style="width:340px" %)Era designator|(% style="width:153px" %)Text|(% style="width:172px" %)AD 316 +|yy|(% style="width:340px" %)Year short (upper case is Year of Week{{footnote}}yyyy represents the calendar year while YYYY represents the year of the week, which is only relevant for 53 week years{{/footnote}})|(% style="width:153px" %)Year|(% style="width:172px" %)96 317 +|yyyy|(% style="width:340px" %)Year Full (upper case is Year of Week)|(% style="width:153px" %)Year|(% style="width:172px" %)1996 318 +|MM|(% style="width:340px" %)Month number in year starting with 1|(% style="width:153px" %)Month|(% style="width:172px" %)07 319 +|MMM|(% style="width:340px" %)Month name short|(% style="width:153px" %)Month|(% style="width:172px" %)Jul 320 +|MMMM|(% style="width:340px" %)Month name full|(% style="width:153px" %)Month|(% style="width:172px" %)July 321 +|ww|(% style="width:340px" %)Week in year|(% style="width:153px" %)Number|(% style="width:172px" %)27 322 +|W|(% style="width:340px" %)Week in month|(% style="width:153px" %)Number|(% style="width:172px" %)2 323 +|DD|(% style="width:340px" %)Day in year|(% style="width:153px" %)Number|(% style="width:172px" %)189 324 +|dd|(% style="width:340px" %)Day in month|(% style="width:153px" %)Number|(% style="width:172px" %)10 325 +|F|(% style="width:340px" %)Day of week in month|(% style="width:153px" %)Number|(% style="width:172px" %)2 326 +|E|(% style="width:340px" %)Day name in week|(% style="width:153px" %)Text|(% style="width:172px" %)Tuesday; Tue 336 336 328 +|U|Day number of week (1 = Monday, ..., 7 = Sunday)|Number|1 329 +|HH|Hour in day (0-23)|Number|0 330 +|kk|Hour in day (1-24)|Number|24 331 +|KK|Hour in am/pm (0-11)|Number|0 332 +|hh|Hour in am/pm (1-12)|Number|12 333 +|mm|Minute in hour|Number|30 334 +|ss|Second in minute|Number|55 335 +|S|Millisecond|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|978 336 +|n|Number of periods, used after a SDMX Frequency Identifier such as M, Q, D (month, quarter, day)|[[Number>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#number]]|12 337 + 337 337 The model is illustrated below: 338 338 339 339 [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg||height="265" width="477"]] ... ... @@ -354,16 +354,17 @@ 354 354 * microsecond 355 355 * nanosecond 356 356 357 -(% style="width:573.294px" %) 358 -|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period** 359 -|(% style="width:276px" %)((( 358 +|Numerical datetime systems|Base|Period 359 +|((( 360 360 Epoch Time (UNIX) 361 + 361 361 Milliseconds since 01 Jan 1970 362 -)))| (% style="width:117px" %)1970|(% style="width:177px" %)millisecond363 -|( % style="width:276px" %)(((363 +)))|1970|millisecond 364 +|((( 364 364 Windows System Time 366 + 365 365 Milliseconds since 01 Jan 1601 366 -)))| (% style="width:117px" %)1601|(% style="width:177px" %)millisecond368 +)))|1601|millisecond 367 367 368 368 The example above illustrates numerical based datetime mapping rules for two commonly used time standards. 369 369 ... ... @@ -385,34 +385,41 @@ 385 385 386 386 The main use case is setting the value of Observation Attributes in the target dataset. 387 387 388 -(% style="width:786.294px" %) 389 -|(% style="width:92px" %)**Rule**|(% style="width:377px" %)**Source**|(% style="width:315px" %)**Target** 390 -|(% style="width:92px" %)1|(% style="width:377px" %)((( 390 +|Rule|Source|Target 391 +|1|((( 391 391 If 393 + 392 392 INDICATOR=XULADS; and TIME_PERIOD=2007. 393 -)))|( % style="width:315px" %)(((395 +)))|((( 394 394 Set 397 + 395 395 OBS_CONF=F 396 396 ))) 397 -| (% style="width:92px" %)2|(% style="width:377px" %)(((400 +|2|((( 398 398 If 402 + 399 399 INDICATOR=XULADS; and TIME_PERIOD=2008. 400 -)))|( % style="width:315px" %)(((404 +)))|((( 401 401 Set 406 + 402 402 OBS_CONF=F 403 403 ))) 404 -| (% style="width:92px" %)3|(% style="width:377px" %)(((409 +|3|((( 405 405 If 411 + 406 406 INDICATOR=XULADS; and TIME_PERIOD=2009. 407 -)))|( % style="width:315px" %)(((413 +)))|((( 408 408 Set 415 + 409 409 OBS_CONF=F 410 410 ))) 411 -| (% style="width:92px" %)4|(% style="width:377px" %)(((418 +|4|((( 412 412 If 420 + 413 413 INDICATOR=XULADS; and TIME_PERIOD=2010. 414 -)))|( % style="width:315px" %)(((422 +)))|((( 415 415 Set 424 + 416 416 OBS_CONF=**C** 417 417 ))) 418 418 ... ... @@ -426,22 +426,27 @@ 426 426 427 427 By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows: 428 428 429 -(% style="width:808.294px" %) 430 -|(% style="width:93px" %)**Rule**|(% style="width:385px" %)**Source**|(% style="width:328px" %)**Target** 431 -|(% style="width:93px" %)1|(% style="width:385px" %)((( 438 +|Rule|Source|Target 439 +|1|((( 432 432 If 441 + 433 433 INDICATOR=XULADS. 443 + 434 434 Validity Period start period=2007 end period=2009 435 -)))|( % style="width:328px" %)(((445 +)))|((( 436 436 Set 447 + 437 437 OBS_CONF=F 438 438 ))) 439 -| (% style="width:93px" %)2|(% style="width:385px" %)(((450 +|2|((( 440 440 If 452 + 441 441 INDICATOR=XULADS. 454 + 442 442 Validity Period start period=2010 443 -)))|( % style="width:328px" %)(((456 +)))|((( 444 444 Set 458 + 445 445 OBS_CONF=F** ** 446 446 ))) 447 447 ... ... @@ -453,8 +453,31 @@ 453 453 454 454 === 13.10.1 Many to one mapping (N-1) === 455 455 456 -[[image:1747377208446-496.png]] 470 +|Source|Map To 471 +|((( 472 +**FREQ**="A" 457 457 474 +ADJUSTMENT="N" 475 + 476 +**REF_AREA**="PL" 477 + 478 +**COUNTERPART_AREA**="W0" 479 + 480 +REF_SECTOR="S1" 481 + 482 +COUNTERPART_SECTOR="S1" ACCOUNTING_ENTRY="B" 483 + 484 +STO="B5G" 485 +)))|((( 486 +FREQ="A" 487 + 488 +REF_AREA="PL" 489 + 490 +COUNTERPART_AREA="W0" 491 + 492 +INDICATOR="IND_ABC" 493 +))) 494 + 458 458 The bold Dimensions map from source to target verbatim. The mapping simply specifies: 459 459 460 460 FREQ => FREQ ... ... @@ -479,43 +479,49 @@ 479 479 480 480 The following representation mapping can be used to explicitly map each age to an output code. 481 481 519 +: 520 + 482 482 ((( 483 -(% style="width:669.294px" %) 484 -|(% style="width:218px" %)**Source Input Free Text**|(% style="width:448px" %)**Desired Output Code Id** 485 -|(% style="width:218px" %)0|(% style="width:448px" %)A 486 -|(% style="width:218px" %)1|(% style="width:448px" %)A 487 -|(% style="width:218px" %)2|(% style="width:448px" %)A 488 -|(% style="width:218px" %)3|(% style="width:448px" %)B 489 -|(% style="width:218px" %)4|(% style="width:448px" %)B 522 +|Source Input Free Text|Desired Output Code Id 523 +|0|A 524 +|1|A 525 +|2|A 526 +|3|B 527 +|4|B 490 490 ))) 491 491 492 -If this mapping takes advantage of regular expressions it can be expressed in two rules: 530 +If this mapping takes advantage of regular expressions it can be expressed in two 3464 rules: 493 493 494 -((( 495 -(% style="width:675.294px" %) 496 -|(% style="width:219px" %)((( 497 -**Regular Expression** 498 -)))|(% style="width:453px" %)**Desired Output** 499 -|(% style="width:219px" %)[0-2]|(% style="width:453px" %)A 500 -|(% style="width:219px" %)[3-4]|(% style="width:453px" %)B 532 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]] 501 501 502 -(% style="color:inherit; font-family:inherit; font-size:max(21px, min(23px, 17.4444px + 0.462963vw))" %)13.10.3 Observation Attributes for Time Period 534 +__Regular Expression __Desired Output 535 + 536 +: 537 + 538 +((( 539 +|[0-2]|A 540 +|[3-4]|B 503 503 ))) 504 504 543 +=== 13.10.3 Observation Attributes for Time Period === 544 + 505 505 This use case is where a specific observation for a specific time period has an attribute 3468 value. 506 506 547 +: 548 + 507 507 ((( 508 -(% style="width:689.294px" %) 509 -|(% style="width:220px" %)**Input INDICATOR**|(% style="width:223px" %)**Input TIME_PERIOD**|(% style="width:243px" %)**Output OBS_CONF** 510 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2008|(% style="width:243px" %)C 511 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2009|(% style="width:243px" %)C 512 -|(% style="width:220px" %)XULADS|(% style="width:223px" %)2010|(% style="width:243px" %)C 550 +|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF 551 +|XULADS|2008|C 552 +|XULADS|2009|C 553 +|XULADS|2010|C 513 513 ))) 514 514 515 515 __Or using a validity period on the Representation Mapping__: 516 516 517 -Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C558 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_6dbf7f.gif||alt="Shape11" height="36" width="555"]] Input INDICATOR Valid From/ Valid To Output OBS_CONF 518 518 560 +XULADS 2008/2010 C 561 + 519 519 === 13.10.4 Time mapping === 520 520 521 521 This use case is to create a time period from an input that does not respect SDMXTime Formats. ... ... @@ -522,15 +522,20 @@ 522 522 523 523 The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details: 524 524 568 +: 569 + 525 525 ((( 526 -(% style="width:763.294px" %) 527 -|(% style="width:163px" %)**Source Value**|(% style="width:219px" %)**Source Mapping**|(% style="width:198px" %)**Target Frequency**|(% style="width:180px" %)**Output** 528 -|(% style="width:163px" %)18/07/1981|(% style="width:219px" %)dd/MM/yyyy|(% style="width:198px" %)A|(% style="width:180px" %)1981 571 +|Source Value|Source Mapping|Target Frequency|Output 572 +|18/07/1981|dd/MM/yyyy|A|1981 529 529 ))) 530 530 531 531 When the target frequency is based on another target Dimension value, in this example __the value of the FREQ Dimension in the tar__get DSD. 532 532 577 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]] 533 533 579 +: 580 +:: 581 + 534 534 ((( 535 535 |Source Value|Source Mapping|Target Frequency Output Dimension 536 536 ... ... @@ -554,7 +554,7 @@ 554 554 555 555 Dimension 556 556 557 - 1981 yyyy D – End of Period 1981-12-31 605 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif||alt="Shape13" height="173" width="555"]] 1981 yyyy D – End of Period 1981-12-31 558 558 559 559 When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01: 560 560
- 1747377208446-496.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.helena - Size
-
... ... @@ -1,1 +1,0 @@ 1 -28.0 KB - Content