title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|---|
Error (MDX) |
Error (MDX) |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
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]