2
.. _terminologies-link:
7
This page define all terminolgies. Objects in the OLAP cube use this convention.
13
A schema is a collection of N dimensions. It's the meta description
20
A schema is divided in hierarchy, which are divided in dimensions.
21
The main use of hierarchy is to check that different axis can not
22
use dimensions of the same hierarchy.
28
A dimension is an attribute, or set of attributes, by which you can
29
divide measures into sub-categories. It's a tree structure that
30
define the axis of the cube. They can be explicitly defined:
31
partner_id.country_id.state_ids or recursive 'parent_id'.
32
A dimension is divided in levels.
38
One level of sub-categories defined by dimensions.
44
Meta data of the quantity your are measuring. (value)
45
A measure may be complex, ex: the tuple (quantity,uom)
46
Attributes which are also objects:
48
Agregator: an SQL function that define how we aggregate measures
49
"sum", "count", "min", "max", "avg", and "distinct-count"
51
DataType (the measure/value datatype)
57
A cube is a collection of N axis. A cube is an instance of a schema.
58
A cube is mapped to a 'SQL' query through the use of his axis. (or several)
62
A member is a point within a dimension determined by a particular set of
63
attribute values. (instances) A member is able to compute a part of the
68
An axis is composed by one or a set of members. In others terms, the axis is
69
defined by the part of the query preceeding the "on rows", "on colmuns",
70
"on pages"... The MDX result is also a cube coumposed of axis.
74
A value is an instance of a measure. (one particular case of the cube).