Database Reference
In-Depth Information
6
PraCtICal mdX For essBase develoPers
Gary Crisci
Contents
6.1 Introduction
185
6.2 objectives
186
6.3 housekeeping
186
6.4
mDx Basics
187
6.4.1
terms and Syntax
187
6.5 Properties
190
6.6 Functions
190
6.6.1 Crossjoin
191
6.7
Query Structure
192
6.7.1 Axis
192
6.7.2
Where Slicer
193
6.7.3
Solve order
196
6.7.4
ASo member Formulas
197
6.8
Advanced mDx
197
6.8.1
Conditional Logic
197
6.9
time Functionality
201
6.9.1 Period-to-Date
201
6.9.2
Analytic Dimensions
202
6.9.3
time Balancing
205
6.10 tips and tricks
207
6.10.1 Querying metadata
207
6.10.2 Calculating optimal Sparse Dimension order
222
6.11 Closing
223
6.1 introDuCtion
multidimensional Expressions (mDx) is a query language written for retrieving data
from multidimensional databases. Similar in some ways to Structured Query Language
(SQL) for relational databases, it is a flexible language that allows the user to not only
retrieve data, but also to manipulate the data and perform numerous other func-
tions. mDx should not be considered a robust reporting language, due to its limited
185
