1.    It is powered by the SQLAlchemy which supports multiple databases including PostgreSQL, MySQL, Oracle, simple sqlite and many others.

2.    Cubes install:

url: http://cubes.readthedocs.io/en/v1.0.1/install.html

3.    Cubes purpose:

Purpose is to provide a framework for giving analyst or any application end-user understandable and natural way of reporting using concept of data Cubes – multidimensional data objects.

Analytical Workspace:

The analyital workspace manages cubes, shared (public) dimensions, data stores, model providers and model metadata. Provides aggregation browsers and maintains database connections

 

 

 

Stores:

Cube data are stored somewhere or might be provided by a service. We call this data source a data store. A workspace might use multiple stores to get content of the cubes.

Supported SQL dialects (by SQLAlchemy) are: Drizzle, Firebird, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase

Model Providers:

Model provider creates models of cubes, dimensions and other analytical objects. The models can be created from a metadata, database or an external source, such as API.