CustomData (MDX)

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

Returns the value of the CustomData connection string property if defined; otherwise, null.

Syntax


CustomData()  

Return Value

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.

Example

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]  

See Also

MDX Function Reference (MDX)