Edit

Share via

Supported MDX (MDX)

  • Article

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

The following statements and functions are supported within Multidimensional Expressions (MDX) Script:

(Comment) (MDX)

-- (Comment) (MDX)

Comment (MDX)

ALTER CUBE Statement (MDX)

Note

Only altering the default member is supported in MDX Scripting.

CALCULATE Statement (MDX)

CASE Statement (MDX)

CREATE CELL CALCULATION Statement (MDX)

CREATE MEMBER Statement (MDX)

CREATE SET Statement (MDX)

EXISTING Keyword (MDX)

FREEZE Statement (MDX)

IF Statement (MDX)

This (MDX)

Note

MDX supports assignment to the following cell properties: BACK_COLOR, FORE_COLOR, FORMAT_STRING, FONT_FLAGS, FONT_NAME, and FONT_SIZE. For more information, see Using Cell Properties (MDX). MDX also supports assignment to the NON_EMPTY_BEHAVIOR property of the CREATE MEMBER statement.

SCOPE Statement (MDX)

See Also

The Basic MDX Script (MDX)