Changes for page 6 Cube

Last modified by Helena on 2025/09/10 11:19

From version 4.1
edited by Helena
on 2025/06/08 11:36
Change comment: There is no comment for this version
To version 3.1
edited by Helena
on 2025/06/07 00:56
Change comment: There is no comment for this version

Summary

Details

Page properties
Tags
... ... @@ -1,1 +1,0 @@
1 -Code|Code list|Data structure definition|Dataflow|Dimension|Hierarchical code|Hierarchical code list|Hierarchy|Measure|SDMX Information Model
Content
... ... @@ -1,19 +1,15 @@
1 -{{box title="**Contents**"}}
2 -{{toc/}}
3 -{{/box}}
1 +=== 6.1 Context ===
4 4  
5 -== 6.1 Context ==
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.
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(%%) for each of the [[dimensions>>doc:sdmx:Glossary.Dimension.WebHome]] to specify the (% style="color:#e74c3c" %)level(%%) 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(%%). 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.
5 +Such cube systems rely, not on simple code lists, but on hierarchical code sets (see section 8).
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).
7 +=== 6.2 Support for the Cube in the Information Model ===
10 10  
11 -== 6.2 Support for the Cube in the Information Model ==
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:
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:
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]].
11 +* The Hierarchy defines the (often complex) hierarchies of codes.
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 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]]).
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).