Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

CustomData (MDX)

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]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft