Data provider types: Essbase
HypIsUDA() determines whether a member has a specific UDA.
HypIsUDA (vtSheetName, vtDimensionName, vtMemberName, vtUDAString)
ByVal vtDimensionName As Variant
ByVal vtMemberName As Variant
ByVal vtUDAString As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtDimensionName: The dimension of the member
vtMemberName: The member for which to retrieve information. Required; there is no default value.
vtUDAString: Input string that is compared against the attributes of the member.
Returns a variant in which -1 is true, 0 is false; otherwise, returns the appropriate error code.
Declare Function HypIsUDA Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtDimensionName As Variant, ByVal vtMemberName As Variant, ByVal vtUDAString As Variant) As Variant Sub Example_HypIsUDA() vtret = HypIsUDA(Empty, "Market", "Connecticut", "MyUDA") If vtret = -1 Then MsgBox ("Found MyUDA") ElseIf vtret = 0 Then MsgBox ("Did not find MyUDA") Else MsgBox ("Error value returned is" & vtret) End If End Sub