欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
Odoo BI
来自开放百科 - 灰狐
（版本间的差异）
| 第1行： | 第1行： | ||
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. | 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. | ||
| + | |||
| + | [[Image:openerp-bi-arch.png|right|thumb|Open ERP BI]] | ||
| + | The cube will use: | ||
| + | [[Image:openerp-bi-data-browser.png|right|thumb|Drill Down on a Member]] | ||
| + | *[[SQLAlchemy]] for all database communications | ||
| + | *[[XML-RPC]] for his external interfaces | ||
| + | *[[PyParser]] for MDX parsing | ||
More details: http://doc.openerp.com/bi | More details: http://doc.openerp.com/bi | ||
2009年8月23日 (日) 10:36的版本
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.
The cube will use:
- SQLAlchemy for all database communications
- XML-RPC for his external interfaces
- PyParser for MDX parsing
More details: http://doc.openerp.com/bi
分享您的观点
