HypPerformAdhocOnForm
Cloud data provider types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Hyperion Planning
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 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