Data provider types: Planning (forms only), Financial Management (forms only), Hyperion Enterprise (forms only)
HypSetPages() sets the page members for the selected sheet.
HypSetPages (ByVal vtSheetName, ParamArray MemberList())
ByVal vtSheetName As Variant
ParamArray MemberList() As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
ParamArray MemberList(): The list of desired page member items in the form Dimension#Current Member. If MemberList is Null or Empty, the top level value is used.
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypSetPages Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray MemberList() As Variant) As Long Sub Example_HypSetPages() X=HypSetPages (Empty,"Entity#Operations","Scenario#Current") End Sub