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.
You can install it directly from the Python Package Index:
pip install olapy
The project sources are stored in Github repository.
Download from Github:
git clone git://github.com/abilian/olapy.git
To set up the application, run, ideally in a virtualenv:
cd olapy python setup.py install
or just:
pip install -e .
[OPTIONAL]
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 http://127.0.0.1:8000/ 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.