Skip to content
OlaPy, an experimental OLAP engine based on Pandas
Python TSQL HTML JavaScript CSS Makefile Batchfile
Branch: master
Clone or download
Latest commit f92b213 Jul 31, 2019
Type Name Latest commit message Commit time
Failed to load latest commit information.
config use the new etl, ignore old one Aug 16, 2018
cubes_templates change foodmart time table Jan 29, 2019
demos format. Jul 31, 2019
docs Add from __future__ import absolute_import Apr 15, 2019
micro_bench Add from __future__ import absolute_import Apr 15, 2019
olapy format. Jul 31, 2019
pyodide Add from __future__ import absolute_import Apr 15, 2019
tests refactor: group similar tests in same module. Jul 31, 2019
.editorconfig refactor: dialect-related classes cleanup. Mar 24, 2018
.gitignore Ignore .venv May 2, 2019
.pre-commit-config.yaml format. Dec 23, 2017
.pylint.rc Initial import. Mar 10, 2017
.travis.yml tooling: checking if travis really need root access. Jul 30, 2019
CHANGES.rst update changes Feb 8, 2019
LICENSE Create LICENSE Mar 20, 2018 remove zip Nov 29, 2017
Makefile refactor: Small cleanups. Jul 30, 2019
README.rst sexy description Feb 8, 2019
dev-requirements.txt deps: cleanup deps slightly. Jul 31, 2019
queries_examples add queries examples May 2, 2017 deps: contraints numpy and pandas to stay on py2. Jul 30, 2019
requirements.txt deps: contraints numpy and pandas to stay on py2. Jul 30, 2019
setup.cfg Cleanup / format. Apr 14, 2019 Prepare release. Jul 31, 2019
tox.ini tooling: add some pylint checks. Jul 31, 2019


OlaPy, an experimental OLAP engine based on Pandas


OlaPy is an OLAP engine based on Python, which gives you a set of tools for the development of reporting and analytical applications, multidimensional analysis, and browsing of aggregated data with MDX and XMLA support.



This project is currently a research prototype, not suited for production use.


This project is currently licenced under the LGPL v3 licence.


Install from PyPI

You can install it directly from the Python Package Index:

pip install olapy

Install from Github

The project sources are stored in Github repository.

Download from Github:

git clone git://

To set up the application, run, ideally in a virtualenv:

cd olapy
python install

or just:

pip install -e .


you can use Spark instead of Pandas, to do so, you need just to install it:

pip install pyspark

and if you want to go back to pandas just uninstall spark with:

pip uninstall pyspark


Before running OlaPy, you need to initialize it with:

olapy init

and then you can run the server with:

olapy runserver

and then from excel, open new spreadsheet and go to : Data -> From Other Sources -> From Analysis Services and use as server name and click next, then you can chose one of default olapy demo cubes (sales, foodmart...) and finish.

that's it ! now you can play with data


This project must adhere to the Abilian Developer Guide.

Pull requests are welcome.


To run tests, run:

pytest tests

or simply (on Unix-like systems):

make test


This project is developed by Abilian SAS and partially funded by the French Government through the Wendelin project and the Investissement d'avenir programme.

You can’t perform that action at this time.