Database Reference
In-Depth Information
8
deeP InsIde the essBase Java aPI
T i Tim To w
Contents
8.1 Introduction
275
8.2
Essbase Java API object model
276
8.3
Essbase Connections
282
8.4
retrieving Data from Essbase
285
8.5
Sending Data to Essbase
292
8.6
Calculating Essbase Databases
295
8.7
member Information
297
8.7.1
Accessing Essbase member Information via IEssmember objects
297
8.7.2
getting IEssmember objects using IEssCube.getmember
298
8.7.3
getting IEssmember objects using IEssCubeoutline.findmember
300
8.7.4
getting IEssmember objects using IEssmemberSelection.
executeQuery
301
8.7.5
getting IEssmember objects using IEssCubeoutline.executeQuery
306
8.8
getting member Information using member Queries
307
8.9 Summary
311
8.1 introDuCtion
one of the key differences between an application and a platform is the presence of an
application programming interface, or API. The Essbase platform was created from the
ground up on a robust API, and, in fact, nearly all functionality in the Essbase product is
also available to developers through the API. This is important as it allows developers to
tailor Essbase applications in nearly infinite ways to meet their business requirements.
It also allows Essbase to be used in ways above and beyond the vision of the Essbase
product team.
This chapter assumes you are not yet familiar with Java, so it will introduce you to
some of the terminology and organization techniques used in Java. once you know a lit-
tle about the terminology of Java, we can introduce you to the objects you will encounter
when writing code with the Essbase Java API. After you are familiar with the objects,
you will be introduced to some of the techniques you can use to connect to Essbase,
query data from the database, and query members from the Essbase outline. Along the
way, you may learn a bit about how Essbase works under-the-covers.
275
