| description | CustomData (MDX) |
|---|---|
| title | CustomData (MDX) | Microsoft Docs |
| ms.date | 02/17/2022 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
Returns the value of the CustomData connection string property if defined; otherwise, null.
CustomData()
The CustomData function can retrieve the CustomData connection string property and pass a configuration setting to be used by Multidimensional Expressions (MDX) functions and statements, such as UserName (MDX) and CALL Statement (MDX). For example, this function can be used in a dynamic security expression to select the allowed/denied set members for the string value in the CustomData connection string property.
The following query displays the value returned by the CustomData function in a calculated measure:
WITH MEMBER [Measures].CUSTOMDATADEMO AS CUSTOMDATA()
SELECT [Measures].CUSTOMDATADEMO ON 0
FROM [Adventure Works]