HypGetPagePOVChoices

Data Source types: Essbase, Planning, Financial Management, Hyperion Enterprise

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

Parameters

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

vtDimensionName: The dimension names in the POV

vtMbrNameChoices: Output parameter containing array of member names, if successful

vtMbrDescChoices: Output parameter containing array of member descriptions, if successful

Return Value

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

Example

Public Declare Function HypGetPagePOVChoices Lib "HsAddin As Long

Sub getpagepovchoices_test()
  Dim mbrName As Variant
  Dim mbrDesc As Variant
  sts = HypGetPagePOVChoices("Sheet7", "Entity", mbrName, mbrDesc)
  MsgBox (sts)  
 End Sub