Cloud data provider types: Oracle Analytics Cloud - Essbase
On-premises data provider types: Oracle Essbase
Description
HypIsUDA() determines whether a member has a specific UDA.
Syntax
HypIsUDA (vtSheetName, vtDimensionName, vtMemberName, vtUDAString)
ByVal vtSheetName As Variant
ByVal vtDimensionName As Variant
ByVal vtMemberName As Variant
ByVal vtUDAString As Variant
Parameters
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.
Return Value
Returns a variant in which -1 is true, 0 is false; otherwise, returns the appropriate error code.
Example
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