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