Error (MDX)

SQL Server 2008 R2

Raises an error, optionally providing a specified error message.

Copy 

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]

Community Additions

ADD
Show: