HypExecuteCalcScriptEx2

Describes the Oracle Smart View for Office VBA function, HypExecuteCalcScriptEx2.

Cloud data provider types: Oracle Essbase Cloud

On-premises data provider types: Oracle Essbase On-Premises

Description

HypExecuteCalcScriptEx2() uses a calculation script (business rule script) to initiate a calculation on the server. It picks up the selected POV on the active sheet, which is needed as input for running the script.

Note:

This VBA should only be used for calc scripts that require runtime POV input. For a script that does not require runtime POV input, use HypExecuteCalcScript instead.

Syntax

HypExecuteCalcScriptEx2 (vtSheetName, vtCalcScript)

ByVal vtSheetName As Variant

ByVal vtCalcScript As Variant

Parameters

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

vtCalcScript: The name of the calculation script on the server in the database directory to run. This script requires runtime POV variables as input, which can be picked up from the active grid.

Return Value

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

Example

Declare Function HypExecuteCalcScriptEx2 Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtCalcScriptName As Variant) As Long 
Sub RunCalcScriptWith_POV_RTSV() 
sts = HypExecuteCalcScriptEx2(Empty, "POV_CalcScr")
End Sub