Error (MDX)

 

Updated: March 2, 2016

Raises an error, optionally providing a specified error message.

  
Error( [ Error_Text ] )  

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

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]

MDX Function Reference (MDX)

Community Additions

ADD
Show: