Database Reference
In-Depth Information
Figure 8.3
Database restructure. (From Oracle Essbase Administration Services. With permission.)
happen under the covers. For example, when you modify and save an outline in EAS,
you can see the various steps that EAS performs as it verifies and saves the outline and
then restructures the database (Figure 8.3).
When working with the Java API, there are times where there is neither sample code
nor a way to visually observe the operation. In those cases, the only way to find the
proper task sequence is by trial and error or by contacting oracle Support.
now that you know a bit more about the objects inside the Java API and have been
introduced to the concept of a task sequence, we can start working with some actual
Java code. In the next section, you will learn how to connect to an Essbase server and
access a specific database.
8.3 essBase ConneCtions
If you think about accomplishing a given task in Smart view, the first thing you do is
connect to a specific Essbase database. In other words, the first
operation
in your Smart
view
task sequence
is to connect to the database. Likewise, when you are working with
the Java API, the first thing in your task sequence is to connect to the database.
In reality, the process of connecting to a database has its own task sequence, as there
are a number of steps that must be taken to create the connection to a specific database.
generally, the steps required to connect to a database include:
• Initialize the API
• Create an
IEssOlapServer
object for the desired server
• Connect to the server
• get a reference to the specified application and cube
• Set the cube active on the connection
