MDX Overview

The Multi-Dimensional Expressions (MDX) language is used to retrieve multi-dimensional data stored in Planful application cubes. At Planful, MDX formulas are referred to as Rules.

A rule represents data elements in the cube similar to rules created in Excel (similar to cells, rows and columns). As shown in the image below, when a rule is comprised of members from more than one dimension, it must be enclosed in parenthesis.

A Member is an item in a dimension that represents data. Each member has a member ID and code. The ampersand (&) character is used in a rule to differentiate the member ID from the code. For example:

[Account].&[380]   -- Member ID 

[Account].[Sales]   -- Member Code