Choose your database:

Partners

Testimonials

Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".

Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

Download

Buy

MS SQL 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

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Jun 29, 2017

MS SQL Maestro 17.6 released

New version features support for SQL Server 2017, support for row-level security policies, custom labels and colors for server nodes in Database Explorer, and some other useful things.

Jul 27, 2015

MS SQL Maestro 15.7 released

New version features support for Azure SQL Database and SQL Server 2016, updated data export/import tools, colored tabs, new encryption algorithms in data grids and some other useful things.

More news

Feature of the day

Object Duplicating

MS SQL Maestro allows you to make a copy of a database object by dragging it from one database to another.

Code Folding

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

MS SQL Maestro online Help

Input SELECT query