Data provider types: Oracle Essbase

Description

HypExecuteCalcScriptString () executes a calculation script along with substitution variables.

Description

HypExecuteCalcScriptString () executes a calculation script, including any substitution variables.

Use with HypGetCalcScript.

This function requires Oracle Hyperion Provider Services 11.1.2.4.017 or higher.

Syntax

HypExecuteCalcScriptString (vtSheetName, vtCalcScript, vtSubstitutionVarList)

ByVal vtSheetName As Variant

ByVal vtCalcScript As Variant

ByVal vtSubstitutionVarList As Variant

Parameters

vtSheetName: Input parameter; the name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used, and the data source of the given sheet name will be used for connection.

vtCalcScript: Input parameter; the calculation script string being executed.

vtSubstitutionVarList: Input parameter; the list of substitution variables to be used during execution.

Return Value

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

Example

Sub calcScrVBATest2()
Script = "SET RUNTIMESUBVARS{salesNum =400;_mySales=300;myRTVar=@CHILDREN(~100~);myCOGS=30;};FIX (@INTERSECT(@CHILDREN(~100~), ~100-10~)) Sales = &_mySales;COGS=555;ENDFIX;"

Script = Replace(Script, Chr(126), Chr(34)) ‘replace ~ with "

Param = "_mySales=222;"

HypExecuteCalcScriptString("Sheet1", Script, Param)

End Sub"