Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
HypGetMembers() gets the list of selected or used members for a given dimension present in the grid.
For Essbase and Planning, member names are based on the selected alias table.
For Financial Management, the second array returns the descriptions.
For POV (in forms), Page (in ad hoc) and user variables, a single member is returned.
To uniquely identify the user variable, provide the user variable name rather than the dimension name.
HypGetMembers (vtSheetName, vtDimensionName, vtMbrNameChoices, vtMbrDescChoices)
ByVal vtSheetName As Variant
ByVal vtDimensionName As Variant
ByRef vtMbrNameChoices As Variant
ByRef vtMbrDescChoices 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: Input variable; the name of the dimension for which the selected member list is to be returned
vtMbrNameChoices: Output variable; the array of member names used
vtMbrDescChoices: Output variable; the array of member name descriptions. For Essbase and Planning, this is the same as member names. This list will be empty if the dimension is a row or column dimension.
Returns 0 if successful; otherwise, returns the appropriate error code.
This example assumes that the worksheet is connected and has a grid.
Public Declare Function HypGetMembers Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtDimensionName As Variant, ByRef vtMbrNameChoices As Variant, ByRef vtMbrDescChoices As Variant) As Long Sub Example_HypGetMembers() sts = HypGetMembers("Sheet1", "Year", vtMbr, vtDes) End Sub