Changes for page 6 Cube

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

From version 13.1
edited by Artur
on 2025/09/10 11:19
Change comment: Migrated property [LightLLMprompt] from class [SKMS.Methodology.Code.MethodologyClass]
To version 5.1
edited by Helena
on 2025/05/22 14:08
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.arturkryazhev
1 +xwiki:XWiki.helena
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,18 +5,14 @@
1 -{{box title="**Contents**"}}
2 -{{toc/}}
3 -{{/box}}
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:Glossary.Dimension.WebHome]] can be derived from a [[hierarchical code list>>doc: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:Glossary.Hierarchy.WebHome]] (% style="color:#e74c3c" %)levels(%%) for each of the [[dimensions>>doc:Glossary.Dimension.WebHome]] to specify the (% style="color:#e74c3c" %)level(%%) of granularity required to give a “view” of the data – some [[dimensions>>doc: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: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:Glossary.Dimension.WebHome]], such as “type of road” may be drilled down to its lower (% style="color:#e74c3c" %)level(%%). The resulting [[measure>>doc: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.
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>>doc:xwiki:Glossary.Dimension.WebHome]] can be derived from a [[hierarchical code list>>doc:xwiki: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:xwiki:Glossary.Hierarchy.WebHome]] (% style="color:#2ecc71" %)levels(%%) for each of the [[dimensions>>doc:xwiki:Glossary.Dimension.WebHome]] to specify the (% style="color:#2ecc71" %)level(%%) of granularity required to give a “view” of the data – some [[dimensions>>doc:xwiki: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:xwiki: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:xwiki:Glossary.Dimension.WebHome]], such as “type of road” may be drilled down to its lower (% style="color:#2ecc71" %)level(%%). The resulting [[measure>>doc:xwiki: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 -Such cube systems rely, not on simple [[code lists>>doc:Glossary.Code list.WebHome]], but on [[hierarchical code>>doc:Glossary.Hierarchical code.WebHome]] sets (see section 8).
5 +Such cube systems rely, not on simple [[code lists>>doc:xwiki:Glossary.Code list.WebHome]], but on [[hierarchical code>>doc:xwiki:Glossary.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:Glossary.Data structure definition.WebHome]] structure (where each [[dimension>>doc:Glossary.Dimension.WebHome]] value, if coded, is taken from a flat [[code list>>doc:Glossary.Code list.WebHome]]) can be described by a cube definition and can be processed by cube aware systems. The [[SDMX-IM>>doc:Glossary.SDMX Information Model.WebHome]] supports the definition of such cubes in the following way:
9 +Data reported using a [[Data Structure Definition>>doc:xwiki:Glossary.Data structure definition.WebHome]] structure (where each [[dimension>>doc:xwiki:Glossary.Dimension.WebHome]] value, if coded, is taken from a flat [[code list>>doc:xwiki:Glossary.Code list.WebHome]]) can be described by a cube definition and can be processed by cube aware systems. The [[SDMX-IM>>doc:xwiki:Glossary.SDMX Information Model.WebHome]] supports the definition of such cubes in the following way:
14 14  
15 -* The [[Hierarchy>>doc:Glossary.Hierarchy.WebHome]] defines the (often complex) [[hierarchies>>doc:Glossary.Hierarchy.WebHome]] of [[codes>>doc:Glossary.Code.WebHome]].
11 +* The [[Hierarchy>>doc:xwiki:Glossary.Hierarchy.WebHome]] defines the (often complex) [[hierarchies>>doc:xwiki:Glossary.Hierarchy.WebHome]] of [[codes>>doc:xwiki:Glossary.Code.WebHome]].
16 16  * If required:
17 17  ** The StructureMap can group DataStructureDefinition that describe the cube
18 -** The HierarchyAssociation can provide a mechanism to apply a [[Hierarchy>>doc:Glossary.Hierarchy.WebHome]] to the [[Codes>>doc:Glossary.Code.WebHome]] in the Codelists used by the DataStructureDefinition, providing also the context of which the [[hierarchy>>doc:Glossary.Hierarchy.WebHome]] applies (e.g., a [[Dataflow>>doc:Glossary.Dataflow.WebHome]]).
14 +** The HierarchyAssociation can provide a mechanism to apply a [[Hierarchy>>doc:xwiki:Glossary.Hierarchy.WebHome]] to the [[Codes>>doc:xwiki:Glossary.Code.WebHome]] in the Codelists used by the DataStructureDefinition, providing also the context of which the [[hierarchy>>doc:xwiki:Glossary.Hierarchy.WebHome]] applies (e.g., a [[Dataflow>>doc:xwiki:Glossary.Dataflow.WebHome]]).
SKMS.Methodology.Code.MethodologyClass[0]
Index
... ... @@ -1,1 +1,0 @@
1 -7
SUZ.Methodology.Code.MethodologyClass[0]