Odoo BI

Open Object Business Intelligence system aims to be a full featured open source Business Intelligence system written in Python. It implements a HOLAP (Hybride OLAP = ROLAP + MOLAP) cube and a MDX query engine based on SQLAlchemy.

Terminology

Schema: A schema is a collection of N dimensions. It's the meta description of cubes.
Hierarchy: A schema is divided in hierarchy, which are divided in dimensions.
Dimension: A dimension is an attribute, or set of attributes. A dimension is divided in levels.
Level: One level of sub-categories defined by dimensions.
Measure: Meta data of the quantity your are measuring.
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.
Member: A member is a point within a dimension determined by a particular set of attribute values.
Axis: An axis is composed by one or a set of members.
Value: A value is an instance of a measure.