Data provider types: Essbase
HypIsAttribute() checks to see if the specified member has a specific attribute.
HypIsAttribute(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 name of the dimension to which the member belongs
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 HypIsAttribute Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtDimensionName As Variant, ByVal vtMemberName As Variant, ByVal vtUDAString As Variant) As Variant Sub Example_HypIsAttribute() vtret = HypIsAttribute(Empty, "Market", "Connecticut", "MyAttribute") If vtret = -1 Then MsgBox ("Found MyAttribute") ElseIf vtret = 0 Then MsgBox ("MyAttribute not available for Connecticut") Else MsgBox ("Error value returned is" & vtret) End If End Sub