HypIsUDA
Describes the Oracle Smart View for Office VBA function, HypIsUDA.
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