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

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

Managing user permissions

DB2 Maestro allows you to grant user/group in two manners: using the Object (to grant the permission on) Editor or within the User (grantor) Editor.

Database Designer

You can create ER Diagrams to represent objects in your DB2 databases in a couple clicks with Database Designer.

DB2 Maestro online Help

Input SELECT query