Changes for page 6 Cube

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

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

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.elenasemanticproorg
1 +xwiki:XWiki.helena
Content
... ... @@ -4,7 +4,7 @@
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.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.
8 8  
9 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).
10 10