Skip to Content

Changes for page 13 Structure Mapping

Last modified by Helena on 2025/09/10 11:19
From version 10.6
edited by Helena
on 2025/05/16 09:14
Change comment: There is no comment for this version
To version 10.3
edited by Helena
on 2025/05/16 09:12
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -38,14 +38,15 @@
38 38  
39 39  Different source values can also map to the same target value, for example when deriving regions from country codes.
40 40  
41 -(% style="width:674.294px" %)
42 -|(% style="width:284px" %)**Source Component: REF_AREA**|(% style="width:387px" %)**Target Component: REGION**
43 -|(% style="width:284px" %)FR|(% style="width:387px" %)EUR
44 -|(% style="width:284px" %)DE|(% style="width:387px" %)EUR
45 -|(% style="width:284px" %)IT|(% style="width:387px" %)EUR
46 -|(% style="width:284px" %)ES|(% style="width:387px" %)EUR
47 -|(% style="width:284px" %)BE|(% style="width:387px" %)EUR
41 +[[image:SDMX 3-0-0 SECTION 6 FINAL-1.0_en_59eee18f.gif||alt="Shape7" height="1" width="192"]]
48 48  
43 +|Source Component: REF_AREA|Target Component: REGION
44 +|FR|EUR
45 +|DE|EUR
46 +|IT|EUR
47 +|ES|EUR
48 +|BE|EUR
49 +
49 49  == 13.3 N-n structure maps ==
50 50  
51 51  N-n (pronounced 'N to N') mappings describe rules where a specified combination of values in multiple source Components map to specified values in one or more target Components. For example, when mapping a partial Series Key from a highly multidimensional cube (like Balance of Payments) to a single 'Indicator' Dimension in a target Data Structure.
... ... @@ -52,42 +52,51 @@
52 52  
53 53  Example:
54 54  
55 -(% style="width:760.294px" %)
56 -|(% style="width:58px" %)**Rule**|(% style="width:384px" %)**Source**|(% style="width:313px" %)**Target**
57 -|(% style="width:58px" %)1|(% style="width:384px" %)(((
56 +|Rule|Source|Target
57 +|1|(((
58 58  If
59 +
59 59  FREQUENCY=A; and ADJUSTMENT=N; and MATURITY=L.
60 -)))|(% style="width:313px" %)(((
61 +)))|(((
61 61  Set
63 +
62 62  INDICATOR=A_N_L
63 63  )))
64 -|(% style="width:58px" %)2|(% style="width:384px" %)(((
66 +|2|(((
65 65  If
68 +
66 66  FREQUENCY=M; and ADJUSTMENT=S_A1; and MATURITY=TY12.
67 -)))|(% style="width:313px" %)(((
70 +)))|(((
68 68  Set
72 +
69 69  INDICATOR=MON_SAX_12
70 70  )))
71 71  
72 72  N-n rules can also set values for multiple source Components.
73 73  
74 -(% style="width:757.294px" %)
75 -|(% style="width:62px" %)**Rule**|(% style="width:378px" %)**Source**|(% style="width:312px" %)**Target**
76 -|(% style="width:62px" %)1|(% style="width:378px" %)(((
78 +|Rule|Source|Target
79 +|1|(((
77 77  If
81 +
78 78  FREQUENCY=A; and ADJUSTMENT=N; and MATURITY=L.
79 -)))|(% style="width:312px" %)(((
83 +)))|(((
80 80  Set
81 -INDICATOR=A_N_L,
82 -STATUS=QXR15,
85 +
86 +INDICATOR=A_N_L, STATUS=QXR15,
87 +
83 83  NOTE="Unadjusted".
84 84  )))
85 -|(% style="width:62px" %)2|(% style="width:378px" %)(((
90 +|2|(((
86 86  If
92 +
87 87  FREQUENCY=M; and ADJUSTMENT=S_A1; and MATURITY=TY12.
88 -)))|(% style="width:312px" %)(((
94 +)))|(((
89 89  Set
90 -INDICATOR=MON_SAX_12, STATUS=MPM12,
96 +
97 +INDICATOR=MON_SAX_12,
98 +
99 +STATUS=MPM12,
100 +
91 91  NOTE="Seasonally Adjusted"
92 92  )))
93 93