Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
HypGetPagePOVChoices() returns the available member names and member description for a given dimension.
HypGetPagePOVChoices(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: The dimension names in the POV
vtMbrNameChoices: Output parameter; the array of member names
vtMbrDescChoices: Output parameter; the array of member descriptions
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypGetPagePOVChoices Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtDimensionName As Variant, ByRef vtMbrNameChoices As Variant, ByRef vtMbrDescChoices As Variant) As Long Sub Example_HypGetPagePOVChoices() Dim mbrName As Variant Dim mbrDesc As Variant sts = HypGetPagePOVChoices(Empty, "Product", vtMbrNameChoices, vtMbrDescChoices) MsgBox (sts) End Sub