欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
Odoo BI
来自开放百科 - 灰狐
（版本间的差异）
小 (Allen移动Odoo/business intelligence页面至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. | ||
| − | == | + | ==简介== |
| + | [[Artificial intelligence|人工智能]]驱动下的[[Business intelligence|商业智能]] | ||
| + | |||
| + | ==概念== | ||
*Schema: A schema is a collection of N dimensions. It's the meta description of cubes. | *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. | *Hierarchy: A schema is divided in hierarchy, which are divided in dimensions. | ||
| 第12行： | 第15行： | ||
*Value: A value is an instance of a measure. | *Value: A value is an instance of a measure. | ||
| − | |||
The cube will use: | The cube will use: | ||
| − | |||
*[[SQLAlchemy]] for all database communications | *[[SQLAlchemy]] for all database communications | ||
*[[XML-RPC]] for his external interfaces | *[[XML-RPC]] for his external interfaces | ||
*[[PyParser]] for MDX parsing | *[[PyParser]] for MDX parsing | ||
| − | == | + | ==模块== |
*olap http://doc.openerp.com/technical_guide/olap.html | *olap http://doc.openerp.com/technical_guide/olap.html | ||
*olap_crm http://doc.openerp.com/technical_guide/olap_crm.html | *olap_crm http://doc.openerp.com/technical_guide/olap_crm.html | ||
*olap_extract http://doc.openerp.com/technical_guide/olap_extract.html | *olap_extract http://doc.openerp.com/technical_guide/olap_extract.html | ||
*olap_sale http://doc.openerp.com/technical_guide/olap_sale.html | *olap_sale http://doc.openerp.com/technical_guide/olap_sale.html | ||
| − | == | + | ==指南== |
| + | <gallery> | ||
| + | image:openerp-bi-arch.png|odoo BI | ||
| + | image:openerp-bi-data-browser.png|向下钻取 | ||
| + | </gallery> | ||
| + | |||
| + | ==图集== | ||
| + | |||
==链接== | ==链接== | ||
*http://doc.openerp.com/bi | *http://doc.openerp.com/bi | ||
2017年7月27日 (四) 04:46的版本
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.
目录 |
简介
概念
- 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
模块
- olap http://doc.openerp.com/technical_guide/olap.html
- olap_crm http://doc.openerp.com/technical_guide/olap_crm.html
- olap_extract http://doc.openerp.com/technical_guide/olap_extract.html
- olap_sale http://doc.openerp.com/technical_guide/olap_sale.html
指南
odoo BI
向下钻取
图集
链接
分享您的观点
