Database Reference
In-Depth Information
additional information to complete successfully. If you think about how you do a
zoom In operation in the Excel add-ins, you have to first select one or more mem-
bers on which you wish the zoom In to occur. In the Java API, you will write code
to select the member cells. First, you will need to create an
IEssOpZoomIn
operation
object.
// do another operation on the same grid
IEssOpZoomIn zoomIn = cv.createIEssOpZoomIn();
once you have the object, you can add a single cell to the selection using the
IEssOpZoomIn.addCell
method or add a range of cells using the
IEssOpZoomIn.
addRange
method. In our example, we will simply select the cell that currently contains
the member name “Product.”
// tell Essbase which cell or cells to zoom
zoomIn.addCell(2, 0);
now that a cell has been selected for the zoom operation, you can perform the
operation.
// perform the zoom
cv.performOperation(zoomIn);
The zoom In operation occurs on the existing grid and results in the following
output.
Actual
New York
Sales
Qtr1
Qtr2
Qtr3
Qtr4
Colas
1998.0
2358.0
2612.0
1972.0
Root Beer
1778.0
1989.0
1879.0
2293.0
Cream Soda 2033.0
2543.0
2421.0
2308.0
Fruit Soda 1896.0
2195.0
2413.0
2010.0
now that we have discussed the tasks necessary to perform retrieval operations from
the cube, let us take a look at how to send data back to the Essbase database.
8.5 senDing Data to essBase
The task sequence necessary to send data to the Essbase database is only slightly differ-
ent than the tasks required for a retrieve operation. The good news, if you have used the
classic Excel add-in, is that you are probably already familiar with the primary differ-
ence between retrieve and send operations. In the Classic Add-in, updating the Essbase
database is often referred to as
lock and send
. As the name implies, you must first lock
the cells before you send data to the database. There are other considerations that must
be made when updating Essbase databases. First, you must consider whether the cells
you intend to update are actually writable. There are a number of reasons that cells may
be read-only. First, the user's security may not allow writing back to a member com-
bination. The member combination also may contain a dynamically calculated mem-
ber that is not writable. If the database is an ASo (aggregate storage option) database,
