Skip to main content

A python integration for the Saiku ad hoc analysis tool

Project description

Mara Mondrian

Build Status PyPI - License PyPI version Slack Status

A python interface for Mondrian Server, a Mondrian XMLA server combined with the Saiku ad hoc analysis tool. Comes with



To use the library directly, use pip:

pip install mara-mondrian


pip install git+

For an example of an integration into a flask application, have a look at the mara example project 1.


Running Saiku

From within a project, include .scripts/ in your project Makefile (as for example in

Running make setup-mondrian-server will create the required file. And then running make run-mondrian-server will start Saiku and the XMLA server on port 8080:


For running Mondrian Server in production, please have a look at



Mondrian schema generation

If you have a data warehouse schema defined in Mara Schema, then you can automatically create a Mondrian schema file using the function write_mondrian_schema in mara_mondrian/

Have a look at for an example.


Mondrian cache flushing

The function flush_mondrian_cache in mara_mondrian/ triggers a reload of the schema and a flushing of all caches in Mondrian Server.

This file also contains functions for making XMLA requests.


Saiku authentication via Mara ACL

Once you add the Saiku ACL resource in mara_mondrian/ to your project, you can easily control which users can query which cubes:

Saiku ACL

In this example, users from the "Management" group can query all cubes, and users from "Marketing" only "Customers" and "Leads" (with the exception of Thomas who can also query "Order items" and "Sellers").

Please have a look at for how to set this up.

Please make sure that the /mondrian/saiku/authorize endpoint is white-listed from the Mara ACL, as for example in

monkey_patch.patch(mara_acl.config.whitelisted_uris)(lambda: ['/mara-app/navigation-bar', '/mondrian/saiku/authorize'])


The easiest way to try out Mara Mondrian is to run the mara example project 1.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mara-mondrian-2.0.2.tar.gz (81.2 MB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page