1
Introduction to the OpenObject Module
2
=====================================
5
The OLAP module is used in validating , running and formatting the output of MDXExamples
7
The general flow is of OLAP module is shown in following diagram:
10
.. image:: images/Cube_olap_schema.png
13
Explanation of the components
14
-----------------------------
19
This is the layer provided by the base of Open ERP, protocols: NET-RPC (fast binary), XML-RPC, over HTTP or HTTPS
24
Layer provided by Open ERP that provides: authentification (normal/ldap), users management, access rights, workflows, module management, ...
29
It parses the MDX query and convert it in the form of python objects. It uses pyparsing module of python to do this . It split the query in form of objects of axis, level, sub level, slicer (if any) and measures.
35
It parse all the objects created and map it to the browse object ofOpen ERP resource. For example, the axis object will receive a link to the Open ERP browse record on the related olap.axis object.
40
It will run the query on the basis of objects using SQLAlchemy and return different subsets.
41
On the basis of it the cube is virtually made in the form of matrix.
42
And it fills the cube by values using axis mapping
47
The layer provided by SQL Alchemy, it supports: mysql, postgresql, oracle, ...
49
The schema definition is in the Open ERP database.