Data provider types: Essbase
HypGetMemberInformationEx returns all information about a member in an array.
HypGetMemberInformationEx (vtSheetName, vtMemberName, vtPropertyNames, vtPropertyValues, vtPropertyValueStrings)
ByVal vtSheetName As Variant
ByVal vtMemberName As Variant
ByRef vtPropertyNames As Variant
ByRef vtPropertyValues As Variant
vtPropertyValueStrings As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtMemberName: The member for which to retrieve information. This parameter is required because there is no default value.
vtPropertyNames: The property name array
vtPropertyValues: The property value array
vtPropertyValueStrings: The property string value array
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypGetMemberInformationEx Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtMemberName As Variant, ByRef vtPropertyNames As Variant, ByRef vtPropertyValues As Variant, ByRef vtPropertyValueStrings As Variant) As Long sub Example_HypGetMemberInformationEx() sts = HypGetMemberInformationEx(Empty, "100-10", propertynames, propertyvalues, propertyvaluestrings) End Sub