HypPerformAdhocOnForm

Data provider types: Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud

Description

HypPerformAdhocOnForm() enables ad hoc analysis in Excel worksheets for Planning web forms.

Syntax

HypPerformAdhocOnForm(vtSheetName, vtFormName)

ByVal vtSheetName As Variant

ByVal vtFormName As Variant

Parameters

vtSheetName: Input variable; the name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtFormName: Input variable; the name of the Planning web form, including its full path; for example, /Forms/Financials/Financials Summary

Return Value

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

Example

Public Declare Function HypPerformAdhocOnForm Lib  "HsAddin" (ByVal  vtSheetName As Variant, ByVal  vtFormName  As Variant)  As Long
Sub Example_PerformAdhocOnForm
sts = HypPerformAdhocOnForm(Empty, "/Forms/Financials/Financials Summary")
End Sub