2
.. i18n: .. _terminologies-link:
8
.. _terminologies-link:
13
.. i18n: This page defines all terminologies. Objects in the OLAP cube use this convention.
16
This page defines all terminologies. Objects in the OLAP cube use this convention.
18
.. i18n: .. _schema-link:
20
.. i18n: .. topic:: Schema
22
.. i18n: A schema is a collection of N dimensions. It's the meta description
30
A schema is a collection of N dimensions. It's the meta description
33
.. i18n: .. _hierarchy-link:
35
.. i18n: .. topic:: Hierarchy
37
.. i18n: A schema is divided in hierarchy, which are divided in dimensions.
38
.. i18n: The main use of hierarchy is to check that different axis can not
39
.. i18n: use dimensions of the same hierarchy.
46
A schema is divided in hierarchy, which are divided in dimensions.
47
The main use of hierarchy is to check that different axis can not
48
use dimensions of the same hierarchy.
50
.. i18n: .. _dimension-link:
52
.. i18n: .. topic:: Dimension
54
.. i18n: A dimension is an attribute, or set of attributes, by which you can
55
.. i18n: divide measures into sub-categories. It's a tree structure that
56
.. i18n: define the axis of the cube. They can be explicitly defined:
57
.. i18n: partner_id.country_id.state_ids or recursive 'parent_id'.
58
.. i18n: A dimension is divided in levels.
65
A dimension is an attribute, or set of attributes, by which you can
66
divide measures into sub-categories. It's a tree structure that
67
define the axis of the cube. They can be explicitly defined:
68
partner_id.country_id.state_ids or recursive 'parent_id'.
69
A dimension is divided in levels.
71
.. i18n: .. _level-link:
73
.. i18n: .. topic:: Level
75
.. i18n: One level of sub-categories defined by dimensions.
82
One level of sub-categories defined by dimensions.
84
.. i18n: .. _measure-link:
86
.. i18n: .. topic:: Measure
88
.. i18n: Meta data of the quantity your are measuring. (value)
89
.. i18n: A measure may be complex, ex: the tuple (quantity,uom)
90
.. i18n: Attributes which are also objects:
92
.. i18n: Agregator: an SQL function that define how we aggregate measures
93
.. i18n: "sum", "count", "min", "max", "avg", and "distinct-count"
95
.. i18n: DataType (the measure/value datatype)
102
Meta data of the quantity your are measuring. (value)
103
A measure may be complex, ex: the tuple (quantity,uom)
104
Attributes which are also objects:
106
Agregator: an SQL function that define how we aggregate measures
107
"sum", "count", "min", "max", "avg", and "distinct-count"
109
DataType (the measure/value datatype)
111
.. i18n: .. _cube-link:
113
.. i18n: .. topic:: Cube
115
.. i18n: A cube is a collection of N axis. A cube is an instance of a schema.
116
.. i18n: A cube is mapped to a 'SQL' query through the use of his axis. (or several)
123
A cube is a collection of N axis. A cube is an instance of a schema.
124
A cube is mapped to a 'SQL' query through the use of his axis. (or several)
126
.. i18n: .. topic:: Member
128
.. i18n: A member is a point within a dimension determined by a particular set of
129
.. i18n: attribute values. (instances) A member is able to compute a part of the
135
A member is a point within a dimension determined by a particular set of
136
attribute values. (instances) A member is able to compute a part of the
139
.. i18n: .. topic:: Axis
141
.. i18n: An axis is composed by one or a set of members. In others terms, the axis is
142
.. i18n: defined by the part of the query preceding the "on rows", "on columns",
143
.. i18n: "on pages"... The MDX result is also a cube composed of axis.
148
An axis is composed by one or a set of members. In others terms, the axis is
149
defined by the part of the query preceding the "on rows", "on columns",
150
"on pages"... The MDX result is also a cube composed of axis.
152
.. i18n: .. topic:: Value
154
.. i18n: A value is an instance of a measure. (one particular case of the cube).
159
A value is an instance of a measure. (one particular case of the cube).