MENU
    MDX Overview
    • 1 Minute to read
    • Dark
    • PDF

    MDX Overview

    • Dark
    • PDF

    Article summary

    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
    Shell

    Was this article helpful?