Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypSetPOV() sets the POV for the selected sheet.
HypSetPOV(vtSheetName ParamArray MemberList())
ByVal vtSheetName As Variant
ParamArray MemberList() As Variant
vtSheetName: For future use. Currently the active sheet is used.
MemberList: A list of strings which describe the member combination for which a data value will be retrieved. If MemberList is Null or Empty, the top level value is used.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypSetPOV Lib "HsAddin" (ByVal vtSheetName, ParamArray MemberList() As Variant) As Long
Sub SetPOV()
X=HypSetPOV (Empty,”Year#Qtr1”, “Market#East”)
End Sub