HypDeleteCalc

Data source types: Essbase

Description

HypDeleteCalc() allows the user to delete a calculation script object from an Analytic 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: For future use. Currently the active sheet is used.

vtApplicationName: Specify the application name containing the calculation script.

vtDatabaseName: Specify the database name containing the calculation script.

vtCalcScript: Specify the calculation script name 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 Sample_HypDeleteCalc
Dim X as Long
   X = HypDeleteCalc (Empty,”Sample”,”Basic”,”CalcYear”)
End Sub