Databases Reference
In-Depth Information
On this screen, you are presented with a list of database calculation scripts that
your ID has access to run. You are also presented with buttons for the options to
Calculate
,
Cancel
, and the option to access
Help
. It should be pretty obvious to you,
what each of these buttons will do when clicked!
Finally, there is a
Stop
button on this screen. While we never recommend stopping
a database calculation script, doing so by letting Essbase determine when it is safe,
is at least the best way. Keep in mind that Essbase will interrupt the calculation
script when it deems it is safe and this could leave your data partially calculated.
Also, Essbase has what is known as the
point of no return
where it will decide to
let the process complete rather than interrupt it.
Running a Calculation Script using Microsoft
Excel VBA
This example is only for Microsoft Excel
Visual Basic for Applications (VBA)
.
Yes, it's true, you can code functionality in VBA almost exactly how it would be
done in Microsoft
Visual Basic (VB)
, and if that is what you want to do, then see
the VB example.
The reason we get excited about this is because Essbase provides a full library
of functions for Microsoft Excel's VBA, including specific macro functions that
automate all of the menu choices contained in the Essbase Add-In for Microsoft Excel.
This is a nice feature is because the macros can quickly and easily be coded to allow for
RAD (Rapid Application Development)
on your Essbase/Microsoft Excel project.
To begin with, much like declaring an API function in VB, you will need to declare
the macro function using the example below. This declaration statement can be
anywhere in your project:
Declare Function EssVCalculate Lib "essexcln.xll" (ByVal SheetName
As Variant, ByVal calcScript As Variant, ByVal synchronous As
Variant) As Long
The actual command you code in your sub-routine looks like the following statement:
Application.Run macro:=EssVCalculate(SheetName, calcScript,
synchronous)
