Error (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Raises an error, optionally providing a specified error message.

Syntax


Error( [ Error_Text ] )  

Arguments

Error_Text
A valid string expression containing the error message to be returned.

Examples

The following query shows how to use the Error function inside a calculated measure:

WITH MEMBER MEASURES.ERRORDEMO AS ERROR("THIS IS AN ERROR")

SELECT

MEASURES.ERRORDEMO ON 0

FROM [Adventure Works]

See Also

MDX Function Reference (MDX)