Choose your database:

Partners

Testimonials

Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".

Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

Download

Buy

DB2 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

SQL Maestro Group wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

Company news

May 18, 2023

DB2 Maestro 23.5 released

New version comes with colored tabs, new encryption algorithms in data grids, updated BLOB Editor, database profile usage statistics and a lot of other useful things.

Nov 9, 2013

DB2 Maestro 13.11 released

A new reporting tool, advanced SQL Dump wizard, updated SQL Editor, enhanced data grids, redesigned Start Page, improved Database Explorer, and a lot of other useful things.

May 16, 2011

DB2 Maestro 11.5 released

Completely redesigned Data Export and Data Import wizards, improved database profile management, updated OLAP viewer and a lot of other improvements.

More news

Resources

How to add inline buttons to a webpage created with PHP Generator?

The article shows how to implement an AJAX-based one-click editor for a logical column.

Investigating NBA demo. Part 1: Customizing common templates

This article begins a series of step-by-step tutorials on how we made the NBA demo. It explains how to add new items to the menu, implement run-time theme selection, and tweak the login form.

How to add a chart to a webpage created with PHP Generator?

The article illustrates how to use various chart libraries with PHP Generator.

More resources

Feature of the day

Data Analysis

Data Analysis tool allows you to quickly analyze DB2 tables data that has been summarized into multidimensional views and hierarchies.

Support of UTF-8 data

DB2 Maestro supports UTF-8 data in grids.

DB2 Maestro online Help

Input SELECT query

Christmas Sale