HypGetMemberInformationEx

Data source types: Essbase

Description

HypGetMemberInformationEx returns all information about a member in an array.

Syntax

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

Parameters

vtSheetName: For future use currently the active sheet is used.

vtMemberName: The name of the members whose properties are to be returned.

vtPropertyNames: The property name array

vtPropertyValues: The property value array

vtPropertyValueStrings: The property string value array

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.

Example

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 HypGetMemberInformationEx()
 sts = HypGetMemberInformationEx(Empty, "100-10", proper   tynames, propertyvalues, propertyvaluestrings)
End Sub