1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
.. i18n: .. _terminologies-link:
.. i18n:
.. i18n: Terminologies
.. i18n: =============
..
.. _terminologies-link:
Terminologies
=============
.. i18n: This page defines all terminologies. Objects in the OLAP cube use this convention.
..
This page defines all terminologies. Objects in the OLAP cube use this convention.
.. i18n: .. _schema-link:
.. i18n:
.. i18n: .. topic:: Schema
.. i18n:
.. i18n: A schema is a collection of N dimensions. It's the meta description
.. i18n: of cubes..
..
.. _schema-link:
.. topic:: Schema
A schema is a collection of N dimensions. It's the meta description
of cubes..
.. i18n: .. _hierarchy-link:
.. i18n:
.. i18n: .. topic:: Hierarchy
.. i18n:
.. i18n: A schema is divided in hierarchy, which are divided in dimensions.
.. i18n: The main use of hierarchy is to check that different axis can not
.. i18n: use dimensions of the same hierarchy.
..
.. _hierarchy-link:
.. topic:: Hierarchy
A schema is divided in hierarchy, which are divided in dimensions.
The main use of hierarchy is to check that different axis can not
use dimensions of the same hierarchy.
.. i18n: .. _dimension-link:
.. i18n:
.. i18n: .. topic:: Dimension
.. i18n:
.. i18n: A dimension is an attribute, or set of attributes, by which you can
.. i18n: divide measures into sub-categories. It's a tree structure that
.. i18n: define the axis of the cube. They can be explicitly defined:
.. i18n: partner_id.country_id.state_ids or recursive 'parent_id'.
.. i18n: A dimension is divided in levels.
..
.. _dimension-link:
.. topic:: Dimension
A dimension is an attribute, or set of attributes, by which you can
divide measures into sub-categories. It's a tree structure that
define the axis of the cube. They can be explicitly defined:
partner_id.country_id.state_ids or recursive 'parent_id'.
A dimension is divided in levels.
.. i18n: .. _level-link:
.. i18n:
.. i18n: .. topic:: Level
.. i18n:
.. i18n: One level of sub-categories defined by dimensions.
..
.. _level-link:
.. topic:: Level
One level of sub-categories defined by dimensions.
.. i18n: .. _measure-link:
.. i18n:
.. i18n: .. topic:: Measure
.. i18n:
.. i18n: Meta data of the quantity your are measuring. (value)
.. i18n: A measure may be complex, ex: the tuple (quantity,uom)
.. i18n: Attributes which are also objects:
.. i18n:
.. i18n: Agregator: an SQL function that define how we aggregate measures
.. i18n: "sum", "count", "min", "max", "avg", and "distinct-count"
.. i18n: FormatString
.. i18n: DataType (the measure/value datatype)
..
.. _measure-link:
.. topic:: Measure
Meta data of the quantity your are measuring. (value)
A measure may be complex, ex: the tuple (quantity,uom)
Attributes which are also objects:
Agregator: an SQL function that define how we aggregate measures
"sum", "count", "min", "max", "avg", and "distinct-count"
FormatString
DataType (the measure/value datatype)
.. i18n: .. _cube-link:
.. i18n:
.. i18n: .. topic:: Cube
.. i18n:
.. i18n: A cube is a collection of N axis. A cube is an instance of a schema.
.. i18n: A cube is mapped to a 'SQL' query through the use of his axis. (or several)
..
.. _cube-link:
.. topic:: Cube
A cube is a collection of N axis. A cube is an instance of a schema.
A cube is mapped to a 'SQL' query through the use of his axis. (or several)
.. i18n: .. topic:: Member
.. i18n:
.. i18n: A member is a point within a dimension determined by a particular set of
.. i18n: attribute values. (instances) A member is able to compute a part of the
.. i18n: SQL query.
..
.. topic:: Member
A member is a point within a dimension determined by a particular set of
attribute values. (instances) A member is able to compute a part of the
SQL query.
.. i18n: .. topic:: Axis
.. i18n:
.. i18n: An axis is composed by one or a set of members. In others terms, the axis is
.. i18n: defined by the part of the query preceding the "on rows", "on columns",
.. i18n: "on pages"... The MDX result is also a cube composed of axis.
..
.. topic:: Axis
An axis is composed by one or a set of members. In others terms, the axis is
defined by the part of the query preceding the "on rows", "on columns",
"on pages"... The MDX result is also a cube composed of axis.
.. i18n: .. topic:: Value
.. i18n:
.. i18n: A value is an instance of a measure. (one particular case of the cube).
..
.. topic:: Value
A value is an instance of a measure. (one particular case of the cube).
|