Databases Reference
In-Depth Information
This command can be run at any time from your VBA program. The following
parameters are used by passing them to the function:
•
SheetName
: This is supposed to be the Microsoft Excel workbook worksheet
that was active at the time the
EssVCalculate
command was executed.
Essbase does not require the sheet name for this function, so you can simply
enter the
vbEmpty
verb.
•
calcScript
: This variable is the name of the database calculation script
you wish to run. If there is a drawback to using this function, it is that the
calculation script must reside in the default Application|Database folder
location on the analytic server. To run the default database calculation script,
assign the value of
[Default]
to the
calcScript
variable.
•
synchronous
: This tells Microsoft Excel whether to wait for the calculation
script to finish or not, before executing the next line of code in your
program. It is always a good idea to wait for the calc to complete, if you
may need the calculated data elsewhere in the program. Running a calc
with
synchronous
= True
means the program will wait for the calc script
to complete before it resumes execution.
Whew! Knowing that the Essbase database calculation script (calc) is such an integral
part of the Essbase machine, are you surprised there are so many ways to execute it?
We didn't think so!
Summary
Yes, there was a lot to digest in this chapter! Essbase database calculations are very
complex and powerful tools. It takes time and experience to really get good at
writing a database calculation script and you may never meet someone who has the
nerve to introduce himself as an Essbase database calculation expert.
Like anything else, you now have a good foundation to build on. You know the
differences between member formulas and calc script functionality. You've learned
about the various ways you can accomplish a database calculation. You've also been
provided with some insights into the calc topic that can only be gotten from someone
who has laughed and cried over Essbase database calculations.
So go ahead and start building. Try to remember, at first, baby steps are good!
Up next, we cover actually using your Essbase database or cube for the purpose
which it was intended for; data analysis and reporting. What are you waiting for?!
