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