Databases Reference
In-Depth Information
Close the report
Disconnect from a database
Logout from the server
Terminate the API
End Sub
As you can see each Essbase API call has an ending or terminating call that must
be executed when the desired function has completed.
Many code editors support the nested coding style by automatically
indenting the next line of written code to the same indentation
as the previous line making nested code writing even easier. The
Visual Basic editor supports nested code writing and Oracle Essbase
recommends you use the nested coding style when coding Essbase
API functions.
Essbase API function declarations
For your convenience your Essbase package comes with a VB code module that has
all of the Essbase API functions and declarations already coded for you. All you need
to do is add the module to your VB/VBA/COM+ project then start coding the API
calls and functions. The file's name is
esb32.bas
and is a wonderful time saver.
