Choose your database:

Partners

Testimonials

Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".

Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

Download

Buy

SQLite Maestro online Help

Return to chapter overview

To get an OLAP cube, enter SELECT query as a snowflake schema, represented by centralized fact tables (with numeric data) which are connected to multiple dimensions (the numeric data to be categorized by). Input the query text in the SQL Editor area directly or use "drag-n-drop" operation SQL Editor or Visual Query Builder areas and the Query tab of Data Analisis.

Return to chapter overview

Company news

May 5, 2021

SQLite Maestro 21.5 released

New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.

Nov 14, 2016

SQLite Maestro 16.11 released

New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.

Jan 12, 2015

SQLite Maestro 15.1 released

New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.

More news

Feature of the day

Code Folding

All editors of SQLite Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.

Data Export

SQLite Maestro provides an ability to export your data to any of 14 available data formats.

SQLite Maestro online Help

Input SELECT query