Databases Reference
In-Depth Information
There are three distinct sets of API programming libraries for your programming
convenience. There is a full Visual Basic library of API functionality, a full C library
of API functionality, and a full Java function library as well.
For the sake of consistency throughout this topic and the usability in Microsoft Excel
VBA, we will discuss the Visual Basic or VB API library of functions. Complete
documentation can be found in the online technical reference included with and
accessible from the EAS tool.
Oracle Essbase also supports a complete Java API framework with a vast array of
predefined packages and functions that allow the Essbase installation to exist on a
distributed server environment that supports a full web-based application. Custom
functions and controls are also supported. In order to run the Java API you need to
install the Hyperion provider services. Much more information about the Java API
can be found in the N-tier Application Programming Interface guide included with
your Oracle Essbase installation package.
Remember that COM+ objects are written in VB code, and
any API functionality can be written into one as easily as
into a formal Visual Basic program.
The benefit of COM+ objects is that their functionality can
be available on a server to support client calls, as well as
web-based calls.
What functions are available in the
Essbase API
There is a vast array of functionality available in the Essbase API. In the easily
available Essbase API documentation the API functions are divided into two
functional group categories.
The first category is the Visual Basic Main API group of functions. These
functions perform tasks that you would perform during day-to-day operations.
