275
8
deeP InsIde the essBase Java aPI
Tim Tow
8.1 INTRODUCTION
One of the key dierences between an application and a platform is the presence of an
application programming interface, or API. e 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. is is important as it allows developers to
tailor Essbase applications in nearly innite 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.
is 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. Aer 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.
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.ndMember 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

Get Developing Essbase Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.