Cubes (OLAP server)
≈ 3 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
Cubes is a light-weight open source multidimensional modelling and OLAP toolkit for development reporting applications and browsing of aggregated data written in Python programming language released under the MIT License. Cubes provides to an analyst or any application end-user "understandable and natural way of reporting using concept of data Cubes – multidimensional data objects". Cubes was first publicly released in March 20111. The project was originally developed for Public Procurements of Slovakia. Cubes 1.0 was released in September 20141 and presented on the PyData Conference in New York
Evidence and sources
Cubes is a light-weight open source multidimensional modelling and OLAP toolkit for development reporting applications and browsing of aggregated data written in Python programming language released under the MIT License. Cubes provides to an analyst or any application end-user "understandable and natural way of reporting using concept of data Cubes – multidimensional data objects". Cubes was first publicly released in March 2011. The project was originally developed for Public Procurements of Slovakia.
Cubes 1.0 was released in September 2014 and presented on the PyData Conference in New York { "cubes": [ { "name": "sales", "label": "Our Sales", "dimensions": [ "date", "customer", "location", "product" ], "measures": [ "amount" ] } ] "dimensions": [ { "name": "product", "label": "Product", "levels": [ { "name":"category", "label":"Category", "attributes": [ "category_id", "category_label" ], }, { "name":"product", "label":"Product", "attributes": [ "product_id", "product_label" ], } ] }, ... ] } import cubes workspace = Workspace("slicer.ini") browser = workspace.browser("sales") result = browser.aggregate() print(result.summary) { "summary": { "contract_amount_sum": 10000000.0 }, "remainder": {}, "cells": [ { "date.year": 2012, "criteria.code": "ekonaj", "contract_amount_sum": 12345.0, "criteria.description": "economically best offer", "criteria.sdesc": "best offer", "criteria.id": 3 }, { "date.year": 2012, "criteria.code": "cena", "contract_amount_sum": 23456.0, "criteria.description": "lowest price", "criteria.sdesc": "lowest price", "criteria.id": 4 }, ...
"total_cell_count": 6, "aggregates": [ "contract_amount_sum" ], "cell": [ { "type": "range", "dimension": "date", "hierarchy": "default", "level_depth": 2, "invert": false, "hidden": false, "from": ["2012", "1" ], "to": ["2015", "6" ] } ], "levels": { "criteria": [ "criteria" ], "date": [ "year" ] } } The simple HTTP/JSON interface makes it very easy to integrate OLAP reports in web applications written in pure HTML and JavaScript.
The Slicer server contains endpoints describing the cube metadata which helps to create generic reporting applications that don't have to know the database model structure and conceptual hierarchies up-in-front. The Slicer server is written using the Flask (web framework).
Text derived from https://en.wikipedia.org/w/index.php?oldid=1329117944 under CC BY-SA 4.0; modifications have been made.
References
- ↩Wikipedia “Cubes (OLAP server)” release date (×2) · confidence 0.95 revision URL