
This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information
only.
To access multiple databases:
1. Select Essbase > Connect.
2. In the Essbase System Login dialog box, select the server that you want to access from the Server list box (or
type in the name of the server).
3. Press Tab to move to the Username text box and type your username.
4. Press Tab to move to the Password text box and type your password.
5. Click OK to connect to the server.
When the server connection is complete, a list of available application and database pairs is displayed in
the Application/Database list.
6. Double-click the Application/Database pair that you want to connect to in the Application/Database list.
Alternatively, you can select the Application/Database pair and click OK.
If the application is not already running, Essbase automatically starts it. There may be a brief pause as the
application loads; the time required to start an application depends on the number of databases, the sizes
of the databases, and the sizes of the indexes of the databases contained within the application.
7. Open a new worksheet and repeat the steps to connect to additional databases. You can open one database at
a time per worksheet.
For information on connecting to multiple databases from Essbase Query Designer, refer to
Chapter 3.
Ways to View Active Database Connections
If you frequently connect to multiple databases, you may need to check the active database for
each worksheet. You can view the database connection status in two ways:
● The Style tab of the Essbase Options dialog box contains a Connection Information text
box. This box displays connection information for the active worksheet.
● The Essbase Disconnect dialog box lists all active worksheets and their connection
information. This dialog box also enables you to disconnect one or more worksheets from
their respective databases.
Ways to Access Linked Partitions
Linked partitions are part of the Essbase Partitioning product. They provide the ability to link
Essbase databases that contain different dimensions without losing access to all dimensions of
both databases. If your organization has purchased and implemented the partitioning product,
you can take advantage of its capabilities. The Hyperion Essbase - System 9 Database
Administrator's Guide describes how to design and implement a linked partition. The Essbase
application designer usually sets up partitioning.
Ways to Access Linked Partitions
145
Kommentare zu diesen Handbüchern