Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management
Description
HypGetPagePOVChoices() returns the available member names and member description for a given dimension.
Syntax
HypGetPagePOVChoices(vtSheetName, vtDimensionName, vtMbrNameChoices, vtMbrDescChoices)
ByVal vtSheetName As Variant
ByVal vtDimensionName As Variant
ByRef vtMbrNameChoices As Variant
ByRef vtMbrDescChoices As Variant
Parameters
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
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
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