MDX queries in Essbase

MDX is a language-based data analysis mechanism to Analytic Services

databases.

MDX exhibits all of the following characteristics:

->Provides advanced data extraction capability.
->Provides advanced reporting capability.
->Includes functions for identifying and manipulatig
very specific subsets of data.

Is a data-manipulating language, complementing MaxL DDL

(the data-definition language for Essbase)

Every query using the SELECT statement has the following basic format.
Items in [brackets] are optional.

[with_section]
SELECT [axis_specification
[,axis_specification..]]
[FROM[cube_specification]]
[WHERE[slicer_specification]]

A tuple is a collection of mkember(s) with the restriction that
no two members can be from the same dimension. For example, (actual,
Sales) is a tuple. (actual,Budget0 is not a tuple, as both members are
from the same dimension.

A tuple represents a single data cell of all dimensions are represented.
For example, this tuple from sample basic is a single data value:

([qtr1],[sales],[cola],[florida],[Actual])

Set specification

A set is a collection of tuples. In each tuple of the set,
members must represent the same dimension as do the members of
other tuples of the set. additionally, the dimensions must be
represented in the same order.

Select
Filter([product].levels(0).members,
[product].CurrentMember.Caffeinated and
[product].CurrentMember.[Pkg Type]="Can")
Dimension Properties
[caffeinated],[Pkg Type] or columns