HypFindMember

HypFindMember() retrieves member information like dimension, alias, generation and level numbers.

HypFindMember (vtSheetName, vtMemberName, vtAliasTable, vtDimensionName, vtAliasName, vtGenerationName, vtLevelName)

ByVal vtSheetName As Variant

ByVal vtMemberName As Variant

ByVal vtAliasTable As Variant

ByRef vtDimensionName As Variant

ByRef vtAliasName As Variant

ByRef vtGenerationName As Variant

ByRef vtLevelName As Variant

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

vtMemberName: The name of the member. This parameter is required because there is no default value.

vtAliasTable: The name of the alias table to search for the alias name. If Null, the default alias table is searched.

vtDimensionName: The output parameter that contains the dimension, if successful.

vtAliasName: The output parameter that contains the alias name of the member, if successful.

vtGenerationName: The output parameter that contains the generation name of the member, if successful.

vtLevelName: The output parameter that contains the level name of the member, if successful.

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

Declare Function HypFindMember Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtMemberName As Variant, ByVal vtAliasTable As Variant, ByRef vtDimensionName as Variant, ByRef vtAliasName As Variant, ByRef vtGenerationName As Variant, ByRef vtLevelName As Variant) As Long

Sub FindMember() 
   X = HypFindMember(Empty, "100", "Default", dimName, aliasName, 
    genName, levelName) 
   MsgBox (dimName) 
   MsgBox (aliasName) 
   MsgBox (genName) 
   MsgBox (levelName)  
End Sub