Deep Inside the Essbase Java API • 295
e gridview now contains the following data.
Budget New York Sales
Jan Feb Mar Qtr1
Cola 100.0 100.0 100.0 300.0
Diet Cola 100.0 100.0 100.0 300.0
Colas 100.0 100.0 100.0 300.0
ere are a couple of points to examine in this grid. First, our code wrote the value
100 into the Qtr1 column for both Cola and Diet Cola, but the value shown in the cell is
300. How can that be? e reason Qtr1 does not contain 100 is that the Qtr1 member is
marked as a dynamically calculated member in the outline and, as such, the block does
not store this number. Further, as the number was dynamically calculated when it was
retrieved, it automatically reects the sum of its children as it was dened in the Essbase ...