4
Introduction to the OpenObject Module
5
-------------------------------------
7
The :ref:`OLAP <olap-link>` module is used in validating , running and formatting the output of *MDXExamples/MDX Queries*
9
The general flow is of :ref:`OLAP <olap-link>` module is shown in following diagram:
11
.. image:: images/Cube_olap_schema.png
13
Explanation of the components
14
-----------------------------
18
This is the layer provided by the base of Open ERP, protocols: NET-RPC (fast binary), XML-RPC, over HTTP or HTTPS
22
Layer provided by Open ERP that provides: authentification (normal/ldap), users management, access rights, workflows, module management, ...
26
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.
31
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.
35
It will run the query on the basis of objects using SQLAlchemy and return different subsets.
36
On the basis of it the cube is virtually made in the form of matrix.
37
And it fills the cube by values using axis mapping
41
The layer provided by SQL Alchemy, it supports: mysql, postgresql, oracle, ...
43
The schema definition is in the Open ERP database.