MDX is a language-based data analysis mechanism to Essbase databases. MDX exhibits all of the following characteristics:
Provides advanced data extraction capability
Provides advanced reporting capability
Includes functions for identifying and manipulating very specific subsets of data
Is a data-manipulation language, complementing MaxL DDL (the data-definition language for Essbase)
Utilizes the platform-independent XML for Analysis specification
MDX is a joint specification of the XML for Analysis founding members. For more information about XML for Analysis, please visit http://www.xmlforanalysis.com.
MDX is a language for anyone who needs to develop scripts or applications to query and report against data and metadata in Essbase databases. The following prerequisite knowledge is assumed:
A working knowledge of the operating system your server uses and the ones your clients use.
An understanding of Essbase concepts and features.
Familiarity with XML.
In order for Essbase to receive MDX statements, you must pass the statements to Essbase. To pass statements, use either the MaxL Shell (essmsh) or MDX Script Editor in Administration Services. When using the MaxL Shell, terminate all statements with a semicolon. Results are returned in the form of a grid.