Database Reference
In-Depth Information
Table 8.4
Attribute Methods
Member Cells
Data Cells
getDimensionnumber
getAccessmode
isDimensiontop
isCellnoteLinked
isDrillThrough
isDrillThrough
isDynCalc
isobjectsLinked
isExpShare
isPartitionLinked
isImpShare
isurLDrillThrough
isLabelonly
isurlLinked
isneverShare
isWinAppLinked
isnonunique
isStoreData
iszoominable
if (cell.getCellType().equals(IEssCell.EEssCellType.DATA)) {
// print data cell attribute value
System.out.print(gv.getDataCellAttributes(row, col));
} else if (cell.getCellType().equals(IEssCell.EEssCellType.MEMBER)) {
// print member cell attribute value
System.out.print(gv.getMemberCellAttributes(row, col));
}
The attribute numbers are below. one thing that is immediately apparent is that cells
containing members generally have a large attribute number. The reason for the large
number is that member cell attribute numbers use the first five bits to store the dimen-
sion number.
536870928 402653200 134217744
134
134
134
134
268435475
1
1
1
1
you can use bitwise math to convert the attribute number back to an attribute value
understandable by humans. For example, the algorithm for converting the attribute
number to the dimension number for a member cells is:
1 + (attribute number & 0xF8000000) / 134217728 (or 2
27
)
This is not the kind of math that most of us are used to on a daily basis, but when you
use the Java API, it is useful to know that the attribute numbers are there in case you
need to package or store the attributes for a large number of cells.
you are probably starting to see that there is quite a bit more to Essbase than just the
data that you commonly see on a worksheet. The fact that there is more information
available is exactly what makes the Java API so powerful. It allows you, as a developer,
to leverage this information to better serve your customers.
So far in this section, you saw that there are a number of tasks that need to be per-
formed before an operation can be completed. once these basic tasks are completed,
however, you can perform multiple operations using the same objects. to continue
with our example, we could now use the objects in place to complete a zoom In oper-
ation. The zoom In operation is a good example of an operation object that requires
