Creating Cube Views
A cube view is a spreadsheet representation of the data contained in
an Essbase database. Retrieving data into an empty spreadsheet returns
the dimensions of the Essbase database. Use
the cube view to verify that data exists in the Essbase database.
To create a cube view:
- Select an Essbase database in the navigation panel,
then right-click.
- From the right-click menu, select Create > Cube
View.
- In the dialog box that is displayed, enter a name
for the cube view; for example, January
Sales.
- Select one or more of the following options:
Use Conn. Pool - Uses a connection
from the available pool for the duration of a session or until the connection
is closed.
Use Conn. Per Op - Uses a connection
from the available pool for the duration of an operation. After each operation
is completed, the connection returns to the pool so that others can use
it.
Use Cluster - Specifies using
a cluster.
- Click Enter.
A spreadsheet is displayed in the workspace panel of the Essbase Enterprise
Services Console window. The spreadsheet displays the members of the Essbase
database that you selected. In the spreadsheet, you can perform tasks,
such as retrieve, pivot, and drill down. See the Hyperion Essbase Spreadsheet
Add-in Online Help that is installed with Hyperion Essbase for documentation
on using the spreadsheet.
Note: The sample spreadsheet program that is included with Essbase Enterprise
Services is not the actual Hyperion Essbase Spreadsheet Add-in product.
The sample spreadsheet is an example of the type of custom application
program that can be developed for Essbase Enterprise Services.