DeepSee MDX—Overview

MDX is the query language for cubes. DeepSee analyzer generates MDX queries that can be viewed and modified if needed. A DeepSee result set can be returned to your application via the %DeepSee API.

DeepSee MDX—Basic Concepts

MDX queries can have up to seven axes. An aggregate value in a cell is the aggregate of the intersection of the axes. Specifying dimensions and measures in an MDX query defines the axes and aggregates.

DeepSee MDX—Additional Concepts

MDX provides several functions for use with dimensions and measures. There are also several DeepSee specific functions. Sets and tuples can be included in your MDX query. Filters limit the scope of the dimensions and aggregates in the cube.