Odoo BI

2017年7月28日 (五) 09:33的版本

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

功能

报告

• 表式图

利用完全适应您研究领域的单一表格即可概览所有数据

• 柱状图、折线图和饼图

针对相同数据在不同视图风格间转换，以便获得最具说明性的视图。

• 筛选数据

利用内置筛选条件在您的搜索字段内收集信息，并创建之后可保存和使用的自定义筛选条件。

• 导出数据

轻击几下即可从收集的数据中创建 Excel表格文件。

• 定制版面

创建自定义版面，仅包含您认为与自己业务更为相关的信息，轻轻一击，即可访问。

• 保存

创建筛选条件并将其保存在收藏夹列表中，以便之后随时访问。

模块

• 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

指南

项目

• 通过pydruid集成druid.io

图集

• 

  odoo BI

• 

  向下钻取

链接

• http://doc.openerp.com/bi
• https://code.launchpad.net/openobject-bi