| ... |
... |
@@ -4,16 +4,16 @@ |
| 4 |
4 |
|
| 5 |
5 |
== 6.1 Context == |
| 6 |
6 |
|
| 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. |
|
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 2\.1.Dimension.WebHome]] can be derived from a [[hierarchical code list>>doc:sdmx:Glossary 2\.1.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 2\.1.Hierarchy.WebHome]] [[levels>>doc:sdmx:Glossary 2\.1.Level.WebHome]] for each of the [[dimensions>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] to specify the [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]] of granularity required to give a “view” of the data – some [[dimensions>>doc:sdmx:Glossary 2\.1.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 2\.1.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 2\.1.Dimension.WebHome]], such as “type of road” may be drilled down to its lower [[level>>doc:sdmx:Glossary 2\.1.Level.WebHome]]. The resulting [[measure>>doc:sdmx:Glossary 2\.1.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. |
| 8 |
8 |
|
| 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). |
|
9 |
+Such cube systems rely, not on simple [[code lists>>doc:sdmx:Glossary 2\.1.Code list.WebHome]], but on [[hierarchical code>>doc:sdmx:Glossary 2\.1.Hierarchical code.WebHome]] sets (see section 8). |
| 10 |
10 |
|
| 11 |
11 |
== 6.2 Support for the Cube in the Information Model == |
| 12 |
12 |
|
| 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: |
|
13 |
+Data reported using a [[Data Structure Definition>>doc:sdmx:Glossary 2\.1.Data structure definition.WebHome]] structure (where each [[dimension>>doc:sdmx:Glossary 2\.1.Dimension.WebHome]] value, if coded, is taken from a flat [[code list>>doc:sdmx:Glossary 2\.1.Code list.WebHome]]) can be described by a cube definition and can be processed by cube aware systems. The [[SDMX-IM>>doc:sdmx:Glossary 2\.1.SDMX Information Model.WebHome]] supports the definition of such cubes in the following way: |
| 14 |
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]]. |
|
15 |
+* The [[Hierarchy>>doc:sdmx:Glossary 2\.1.Hierarchy.WebHome]] defines the (often complex) [[hierarchies>>doc:sdmx:Glossary 2\.1.Hierarchy.WebHome]] of [[codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]]. |
| 16 |
16 |
* If required: |
| 17 |
17 |
** The StructureMap can group DataStructureDefinition that describe the cube |
| 18 |
18 |
|
| 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]]). |
|
19 |
+The HierarchyAssociation can provide a mechanism to apply a [[Hierarchy>>doc:sdmx:Glossary 2\.1.Hierarchy.WebHome]] to the [[Codes>>doc:sdmx:Glossary 2\.1.Code.WebHome]] in the [[Codelists>>doc:sdmx:Glossary 2\.1.Code list.WebHome]] used by the DataStructureDefinition, providing also the context of which the [[hierarchy>>doc:sdmx:Glossary 2\.1.Hierarchy.WebHome]] applies (e.g., a [[Dataflow>>doc:sdmx:Glossary 2\.1.Dataflow.WebHome]]). |
