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, 1 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -283,17 +283,18 @@ 283 283 |(% style="width:190px" %)German (de)|(% style="width:230px" %)Austria (AT)|(% style="width:348px" %)de-AT 284 284 |(% style="width:190px" %)German (de)|(% style="width:230px" %)Germany (DE)|(% style="width:348px" %)de-DE 285 285 286 -|(% style="width:190px" %)German (de)|(% style="width:234px" %)Luxembourg (LU)|(% style="width:1514px" %)de-LU 287 -|(% style="width:190px" %)German (de)|(% style="width:234px" %)Switzerland (CH)|(% style="width:1514px" %)de-CH 288 -|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Cyprus (CY)|(% style="width:1514px" %)el-CY__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__ 289 -|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Greece (GR)|(% style="width:1514px" %)el-GR 290 -|(% style="width:190px" %)Hebrew (iw)|(% style="width:234px" %)Israel (IL)|(% style="width:1514px" %)iw-IL 291 -|(% style="width:190px" %)Hindi (hi)|(% style="width:234px" %)India (IN)|(% style="width:1514px" %)hi-IN 292 -|(% style="width:190px" %)Hungarian (hu)|(% style="width:234px" %)Hungary (HU)|(% style="width:1514px" %)hu-HU 293 -|(% style="width:190px" %)Icelandic (is)|(% style="width:234px" %)Iceland (IS)|(% style="width:1514px" %)is-IS 294 -|(% style="width:190px" %)Indonesian (in)|(% style="width:234px" %)Indonesia (ID)|(% style="width:1514px" %)in-ID[[__(*)__>>url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]][[url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]] 295 -|(% style="width:190px" %)Irish (ga)|(% style="width:234px" %)Ireland (IE)|(% style="width:1514px" %)ga-IE[[__(*)__>>url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]][[url:https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]] 296 -|(% style="width:190px" %)Italian (it)|(% style="width:234px" %)Italy (IT)|(% style="width:1514px" %)it-IT 286 +(% style="width:773.294px" %) 287 +|(% style="width:190px" %)German (de)|(% style="width:234px" %)Luxembourg (LU)|(% style="width:345px" %)de-LU 288 +|(% style="width:190px" %)German (de)|(% style="width:234px" %)Switzerland (CH)|(% style="width:345px" %)de-CH 289 +|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Cyprus (CY)|(% style="width:345px" %)el-CY__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__ 290 +|(% style="width:190px" %)Greek (el)|(% style="width:234px" %)Greece (GR)|(% style="width:345px" %)el-GR 291 +|(% style="width:190px" %)Hebrew (iw)|(% style="width:234px" %)Israel (IL)|(% style="width:345px" %)iw-IL 292 +|(% style="width:190px" %)Hindi (hi)|(% style="width:234px" %)India (IN)|(% style="width:345px" %)hi-IN 293 +|(% style="width:190px" %)Hungarian (hu)|(% style="width:234px" %)Hungary (HU)|(% style="width:345px" %)hu-HU 294 +|(% style="width:190px" %)Icelandic (is)|(% style="width:234px" %)Iceland (IS)|(% style="width:345px" %)is-IS 295 +|(% style="width:190px" %)Indonesian (in)|(% style="width:234px" %)Indonesia (ID)|(% style="width:345px" %)in-ID__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__ 296 +|(% style="width:190px" %)Irish (ga)|(% style="width:234px" %)Ireland (IE)|(% style="width:345px" %)ga-IE__([[*>>https://www.oracle.com/java/technologies/javase/jdk8-jre8-suported-locales.html#cldrlocale]])__ 297 +|(% style="width:190px" %)Italian (it)|(% style="width:234px" %)Italy (IT)|(% style="width:345px" %)it-IT 297 297 298 298 Examples 299 299 ... ... @@ -309,32 +309,30 @@ 309 309 310 310 The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved): 311 311 312 -|Letter|Date or Time Component|Presentation|Examples 313 -|G|Era designator|[[Text>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]]|AD 314 -|yy|Year short (upper case is Year of Week^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^45^^>>path:#sdfootnote45sym||name="sdfootnote45anc"]](%%)^^)|[[Year>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#year]]|96 315 -|yyyy|Year Full (upper case is Year of Week)|Year|1996 316 -|MM|Month number in year starting with 1|Month|07 317 -|MMM|Month name short|Month|Jul 318 -|MMMM|Month name full|Month|July 319 -|ww|Week in year|[[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]]|27 320 -|W|Week in month|[[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]]|2 321 -|DD|Day in year|[[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]]|189 322 -|dd|Day in month|[[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]]|10 323 -|F|Day of week in month|[[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]]|2 324 -|E|Day name in week|[[Text>>url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]][[url:https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html#text]]|Tuesday; Tue 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 325 325 326 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape9" height="1" width="192"]] 327 - 328 -|U|Day number of week (1 = Monday, ..., 7 = Sunday)|[[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]]|1 329 -|HH|Hour in day (0-23)|[[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]]|0 330 -|kk|Hour in day (1-24)|[[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]]|24 331 -|KK|Hour in am/pm (0-11)|[[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]]|0 332 -|hh|Hour in am/pm (1-12)|[[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 333 -|mm|Minute in hour|[[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]]|30 334 -|ss|Second in minute|[[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]]|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 - 338 338 The model is illustrated below: 339 339 340 340 [[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_295af259.jpg||height="265" width="477"]] ... ... @@ -355,17 +355,16 @@ 355 355 * microsecond 356 356 * nanosecond 357 357 358 -|Numerical datetime systems|Base|Period 359 -|((( 357 +(% style="width:573.294px" %) 358 +|(% style="width:276px" %)**Numerical datetime systems**|(% style="width:117px" %)**Base**|(% style="width:177px" %)**Period** 359 +|(% style="width:276px" %)((( 360 360 Epoch Time (UNIX) 361 - 362 362 Milliseconds since 01 Jan 1970 363 -)))|1970|millisecond 364 -|((( 362 +)))|(% style="width:117px" %)1970|(% style="width:177px" %)millisecond 363 +|(% style="width:276px" %)((( 365 365 Windows System Time 366 - 367 367 Milliseconds since 01 Jan 1601 368 -)))|1601|millisecond 366 +)))|(% style="width:117px" %)1601|(% style="width:177px" %)millisecond 369 369 370 370 The example above illustrates numerical based datetime mapping rules for two commonly used time standards. 371 371 ... ... @@ -387,41 +387,34 @@ 387 387 388 388 The main use case is setting the value of Observation Attributes in the target dataset. 389 389 390 -|Rule|Source|Target 391 -|1|((( 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" %)((( 392 392 If 393 - 394 394 INDICATOR=XULADS; and TIME_PERIOD=2007. 395 -)))|((( 393 +)))|(% style="width:315px" %)((( 396 396 Set 397 - 398 398 OBS_CONF=F 399 399 ))) 400 -|2|((( 397 +|(% style="width:92px" %)2|(% style="width:377px" %)((( 401 401 If 402 - 403 403 INDICATOR=XULADS; and TIME_PERIOD=2008. 404 -)))|((( 400 +)))|(% style="width:315px" %)((( 405 405 Set 406 - 407 407 OBS_CONF=F 408 408 ))) 409 -|3|((( 404 +|(% style="width:92px" %)3|(% style="width:377px" %)((( 410 410 If 411 - 412 412 INDICATOR=XULADS; and TIME_PERIOD=2009. 413 -)))|((( 407 +)))|(% style="width:315px" %)((( 414 414 Set 415 - 416 416 OBS_CONF=F 417 417 ))) 418 -|4|((( 411 +|(% style="width:92px" %)4|(% style="width:377px" %)((( 419 419 If 420 - 421 421 INDICATOR=XULADS; and TIME_PERIOD=2010. 422 -)))|((( 414 +)))|(% style="width:315px" %)((( 423 423 Set 424 - 425 425 OBS_CONF=**C** 426 426 ))) 427 427 ... ... @@ -435,27 +435,22 @@ 435 435 436 436 By specifying validity periods, the example from Section 13.8 can be re-written using two rules as follows: 437 437 438 -|Rule|Source|Target 439 -|1|((( 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" %)((( 440 440 If 441 - 442 442 INDICATOR=XULADS. 443 - 444 444 Validity Period start period=2007 end period=2009 445 -)))|((( 435 +)))|(% style="width:328px" %)((( 446 446 Set 447 - 448 448 OBS_CONF=F 449 449 ))) 450 -|2|((( 439 +|(% style="width:93px" %)2|(% style="width:385px" %)((( 451 451 If 452 - 453 453 INDICATOR=XULADS. 454 - 455 455 Validity Period start period=2010 456 -)))|((( 443 +)))|(% style="width:328px" %)((( 457 457 Set 458 - 459 459 OBS_CONF=F** ** 460 460 ))) 461 461 ... ... @@ -467,31 +467,8 @@ 467 467 468 468 === 13.10.1 Many to one mapping (N-1) === 469 469 470 -|Source|Map To 471 -|((( 472 -**FREQ**="A" 456 +[[image:1747377208446-496.png]] 473 473 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 - 495 495 The bold Dimensions map from source to target verbatim. The mapping simply specifies: 496 496 497 497 FREQ => FREQ ... ... @@ -516,49 +516,43 @@ 516 516 517 517 The following representation mapping can be used to explicitly map each age to an output code. 518 518 519 -: 520 - 521 521 ((( 522 -|Source Input Free Text|Desired Output Code Id 523 -|0|A 524 -|1|A 525 -|2|A 526 -|3|B 527 -|4|B 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 528 528 ))) 529 529 530 -If this mapping takes advantage of regular expressions it can be expressed in two 3464rules:492 +If this mapping takes advantage of regular expressions it can be expressed in two rules: 531 531 532 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_8c1afe2b.gif||alt="Shape10" height="1" width="302"]] 533 - 534 -__Regular Expression __Desired Output 535 - 536 -: 537 - 538 538 ((( 539 -|[0-2]|A 540 -|[3-4]|B 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 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 541 541 ))) 542 542 543 -=== 13.10.3 Observation Attributes for Time Period === 544 - 545 545 This use case is where a specific observation for a specific time period has an attribute 3468 value. 546 546 547 -: 548 - 549 549 ((( 550 -|Input INDICATOR|Input TIME_PERIOD|Output OBS_CONF 551 -|XULADS|2008|C 552 -|XULADS|2009|C 553 -|XULADS|2010|C 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 554 554 ))) 555 555 556 556 __Or using a validity period on the Representation Mapping__: 557 557 558 - [[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_CONF517 +Input INDICATOR Valid From/ Valid To Output OBS_CONF XULADS 2008/2010 C 559 559 560 -XULADS 2008/2010 C 561 - 562 562 === 13.10.4 Time mapping === 563 563 564 564 This use case is to create a time period from an input that does not respect SDMXTime Formats. ... ... @@ -565,20 +565,15 @@ 565 565 566 566 The Component Mapping from SYS_TIME to TIME_PERIOD specifies itself as a time mapping with the following details: 567 567 568 -: 569 - 570 570 ((( 571 -|Source Value|Source Mapping|Target Frequency|Output 572 -|18/07/1981|dd/MM/yyyy|A|1981 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 573 573 ))) 574 574 575 575 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. 576 576 577 -[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_dbe68698.gif||alt="Shape12" height="1" width="273"]] 578 578 579 -: 580 -:: 581 - 582 582 ((( 583 583 |Source Value|Source Mapping|Target Frequency Output Dimension 584 584 ... ... @@ -602,7 +602,7 @@ 602 602 603 603 Dimension 604 604 605 - [[image:SDMX3-0-0 SECTION 6 FINAL-1.0_en_4ec4bb31.gif||alt="Shape13" height="173" width="555"]] 1981 yyyy D – End of Period 1981-12-31557 + 1981 yyyy D – End of Period 1981-12-31 606 606 607 607 When the start of year is April 1^^st^^ the Structure Map has YearStart=04-01: 608 608
- 1747377208446-496.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +XWiki.helena - Size
-
... ... @@ -1,0 +1,1 @@ 1 +28.0 KB - Content