| ... |
... |
@@ -1,15 +1,19 @@ |
| 1 |
|
-=== 6.1 Context === |
|
1 |
+{{box title="**Contents**"}} |
|
2 |
+{{toc/}} |
|
3 |
+{{/box}} |
| 2 |
2 |
|
| 3 |
|
-Some statistical systems create views of data based on a “cube” structure. In essence, a cube is an n-dimensional object where the value of each dimension can be derived from a hierarchical code list. The utility of such cube systems is that it is possible to “roll up” or “drill down” each of the hierarchy levels for each of the dimensions to specify the level of granularity required to give a “view” of the data – some dimensions may be rolled up, others may be drilled down. Such systems give a dynamic view of the data, with aggregated values for rolled up dimension positions. For example, the individual countries may be rolled up into an economic region such as the EU, or a geographical region such as Europe, whilst another dimension, such as “type of road” may be drilled down to its lower level. The resulting measure (such as “number of accidents”) would then be an aggregation of the value for each individual country for the specific type of road. |
|
5 |
+== 6.1 Context == |
| 4 |
4 |
|
| 5 |
|
-Such cube systems rely, not on simple code lists, but on hierarchical code sets (see section 8). |
|
7 |
+Some statistical systems create views of data based on a “cube” structure. In essence, a cube is an n-dimensional object where the value of each [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] can be derived from a [[hierarchical code list>>doc:sdmx:Glossary.Hierarchical code list.WebHome]]. The utility of such cube systems is that it is possible to “roll up” or “drill down” each of the [[hierarchy>>doc:sdmx:Glossary.Hierarchy.WebHome]] (% style="color:#e74c3c" %)[[levels>>doc:sdmx:Glossary.Level.WebHome]](%%) for each of the [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] to specify the (% style="color:#e74c3c" %)[[level>>doc:sdmx:Glossary.Level.WebHome]](%%) of granularity required to give a “view” of the data – some [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] may be rolled up, others may be drilled down. Such systems give a dynamic view of the data, with aggregated values for rolled up [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] positions. For example, the individual countries may be rolled up into an economic region such as the EU, or a geographical region such as Europe, whilst another [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]], such as “type of road” may be drilled down to its lower (% style="color:#e74c3c" %)[[level>>doc:sdmx:Glossary.Level.WebHome]](%%). The resulting [[measure>>doc:sdmx:Glossary.Measure.WebHome]] (such as “number of accidents”) would then be an aggregation of the value for each individual country for the specific type of road. |
| 6 |
6 |
|
| 7 |
|
-=== 6.2 Support for the Cube in the Information Model === |
|
9 |
+Such cube systems rely, not on simple [[code lists>>doc:sdmx:Glossary.Code list.WebHome]], but on [[hierarchical code>>doc:sdmx:Glossary.Hierarchical code.WebHome]] sets (see section 8). |
| 8 |
8 |
|
| 9 |
|
-Data reported using a Data Structure Definition structure (where each dimension value, if coded, is taken from a flat code list) can be described by a cube definition and can be processed by cube aware systems. The SDMX-IM supports the definition of such cubes in the following way: |
|
11 |
+== 6.2 Support for the Cube in the Information Model == |
| 10 |
10 |
|
| 11 |
|
-* The Hierarchy defines the (often complex) hierarchies of codes. |
|
13 |
+Data reported using a [[Data Structure Definition>>doc:sdmx:Glossary.Data structure definition.WebHome]] structure (where each [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] value, if coded, is taken from a flat [[code list>>doc:sdmx:Glossary.Code list.WebHome]]) can be described by a cube definition and can be processed by cube aware systems. The [[SDMX-IM>>doc:sdmx:Glossary.SDMX Information Model.WebHome]] supports the definition of such cubes in the following way: |
|
14 |
+ |
|
15 |
+* The [[Hierarchy>>doc:sdmx:Glossary.Hierarchy.WebHome]] defines the (often complex) [[hierarchies>>doc:sdmx:Glossary.Hierarchy.WebHome]] of [[codes>>doc:sdmx:Glossary.Code.WebHome]]. |
| 12 |
12 |
* If required: |
| 13 |
13 |
** The StructureMap can group DataStructureDefinition that describe the cube |
| 14 |
14 |
|
| 15 |
|
-The HierarchyAssociation can provide a mechanism to apply a Hierarchy to the Codes in the Codelists used by the DataStructureDefinition, providing also the context of which the hierarchy applies (e.g., a Dataflow). |
|
19 |
+The HierarchyAssociation can provide a mechanism to apply a [[Hierarchy>>doc:sdmx:Glossary.Hierarchy.WebHome]] to the [[Codes>>doc:sdmx:Glossary.Code.WebHome]] in the [[Codelists>>doc:sdmx:Glossary.Code list.WebHome]] used by the DataStructureDefinition, providing also the context of which the [[hierarchy>>doc:sdmx:Glossary.Hierarchy.WebHome]] applies (e.g., a [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]). |
