Oracle 9i OLAP Services. Developer’s Guide to the Oracle OLAP AP

The Oracle 9i OLAP Services Developer s Guide to the Oracle OLAP API introduces Java programmers to the Oracle OLAP API the Java application programming interface for Oracle OLAP Services. Through OLAP Services, the OLAP API provides access to data stored in an Oracle database. The OLAP API’s capabilities for querying, manipulating, and presenting data are particularly suited to applications that perform Online Analytical Processing.

---

Table of contents :
Send Us Your Comments……Page 7
Preface……Page 9
Documentation Accessibility……Page 11
OLAP API Overview……Page 13
Access to Data and Metadata Through the OLAP API……Page 16
OLAP API Software Components……Page 20
Developing an OLAP API Application……Page 25
Tasks That an OLAP API Application Performs……Page 29
2 Understanding OLAP API Metadata……Page 33
OLAP Metadata Objects in Oracle Enterprise Manager……Page 34
Overview of MDM Metadata Objects in the OLAP API……Page 37
MdmDimension Class……Page 40
MdmLevel Class……Page 43
MdmHierarchy Class……Page 44
MdmListDimension Class……Page 50
MdmMeasure Class……Page 51
MdmAttribute Class……Page 54
Overview of the Connection Process……Page 57
Connection Classes in the OLAP API……Page 60
Establishing a Connection……Page 63
Interrupting a Connection……Page 67
Overview of the Procedure for Discovering Metadata……Page 69
Creating an MdmMetadataProvider……Page 71
Getting the Root MdmSchema……Page 72
Getting the Contents of the Root MdmSchema……Page 74
Getting the Characteristics of Metadata Objects……Page 75
Getting the Source for a Metadata Object……Page 76
Sample Code for Discovering Metadata……Page 77
How Does the OLAP API Represent Queries?……Page 95
Getting Primary Source Objects……Page 97
Creating Derived Source Objects……Page 99
Getting and Working with Fundamental Source Objects……Page 103
Creating Constant, List and Range Source Objects……Page 106
Selecting Elements Based on Key Values……Page 107
Selecting Elements Based on Element Values……Page 111
Selecting Elements Based on Rank……Page 113
Selecting Elements Based on Hierarchical Position……Page 118
Performing Numerical Operations……Page 125
Making Numerical Comparisons……Page 128
Working with Standard Numerical Functions……Page 129
Working with Aggregation Methods……Page 131
Creating Your own Numerical Functions……Page 134
Working With Strings……Page 135
About Transaction Objects……Page 139
About TransactionProvider Objects……Page 148
Retrieving the Results of a Query……Page 153
Navigating a CompoundCursor for Different Displays of Data……Page 161
Specifying the Behavior of a Cursor……Page 169
Calculating Extent and Starting and Ending Positions of a Value……Page 171
Specifying Fetch Sizes and Fetch Blocks……Page 175
10 Understanding Cursor Classes and Concepts……Page 181
Overview of the OLAP API Cursor Objects……Page 182
Cursor Class……Page 184
CursorManagerSpecification Class……Page 190
CursorSpecification Class……Page 191
CursorManager Class……Page 195
CursorManagerUpdateListener Class……Page 200
About Cursor Positions and Extent……Page 202
About Fetch Sizes and Fetch Blocks……Page 212
About Template Objects……Page 217
Overview of Template and Related Classes……Page 219
Example of a Template……Page 224
Component Overview……Page 235
Location of Files on the OLAP Services Computer……Page 236
Setting Up on Your Application Development Computer……Page 237
Considerations for Deploying Your Application……Page 238
Role of a Naming Service in the Connection Process……Page 239
Getting the CORBA Stub Using VisiBroker Smart Agent……Page 240
Index……Page 243