HypDeleteCalc
Describes the Oracle Smart View for Office VBA function, HypDeleteCalc.
Data provider types: Oracle Essbase
Description
HypDeleteCalc() deletes a calculation script from an Oracle Essbase server.
Syntax
HypDeleteCalc (vtSheetName, vtApplicationName, vtDatabaseName, vtCalcScript)
ByVal vtSheetName As Variant
ByVal vtApplicationName As Variant
ByVal vtDatabaseName As Variant
ByVal vtCalcScript As Variant
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtApplicationName: The name of the application name that contains the calculation script
vtDatabaseName: The name of the database that contains the calculation script
vtCalcScript: The name of the calculation script to be deleted
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypDeleteCalc Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtApplicationName As Variant, ByVal vtDatabaseName As Variant, ByVal vtCalcScript As Variant) As Long
Sub Example_HypDeleteCalc
Dim X as Long
X = HypDeleteCalc (Empty,"Sample","Basic","CalcYear")
End Sub