Developing Essbase Applications

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 innite 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