|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface CellSet
Result of executing an OLAP Statement.
An Cell ordinals and coordinates There are two ways to identify a particular cell: ordinal and coordinates.
Suppose that there are The ordinal number of a cell whose tuple ordinals are
p
axes, and each axis k
(k
between 0 and p - 1
) has
Uk
positions.
There are U
= U0 * ... * Up - 1
cells in total.
Then:
ordinal
is an integer between 0 and
U - 1
.coordinates
are a list of p
integers,
indicating the cell's position on each axis.
Each integer is between 0 and Up-1
.(S0, S1, ... Sp-1)
is
Σi=0p-1 Si . Ei
where
E0 = 1
and
Ei = Πi=0p-1 Uk
Field Summary |
---|
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Method Summary | |
---|---|
int |
coordinatesToOrdinal(java.util.List<java.lang.Integer> coordinates)
Converts a list of cell coordinates to a cell ordinal. |
java.util.List<CellSetAxis> |
getAxes()
Retrieves a list of CellSetAxis objects containing the result. |
Cell |
getCell(int ordinal)
Returns the Cell at an ordinal. |
Cell |
getCell(java.util.List<java.lang.Integer> coordinates)
Returns the Cell at a given set of coordinates. |
Cell |
getCell(Position... positions)
Returns the Cell at the intersection of a set of axis positions. |
CellSetAxis |
getFilterAxis()
Retrieves the CellSetAxis representing the filter axis. |
CellSetMetaData |
getMetaData()
Retrieves the description of this CellSet 's axes
and cells. |
java.util.List<java.lang.Integer> |
ordinalToCoordinates(int ordinal)
Converts a cell ordinal to a list of cell coordinates. |
Methods inherited from interface java.sql.ResultSet |
---|
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Methods inherited from interface org.olap4j.OlapWrapper |
---|
isWrapperFor, unwrap |
Method Detail |
---|
CellSetMetaData getMetaData() throws OlapException
CellSet
's axes
and cells.
getMetaData
in interface java.sql.ResultSet
CellSet
's axes
and cells
OlapException
- if a database access error occursjava.util.List<CellSetAxis> getAxes()
The list contains axes according to their ordinal: 0 is the columns axis, 1 the rows axis, and so forth.
CellSetAxis getFilterAxis()
This axis always has one row, and contains one member for each dimension not included in any other axis. Some of these dimensions may have been explicitly mentioned in the WHERE clause of the MDX statement; others dimensions are represented by their default member.
Cell getCell(java.util.List<java.lang.Integer> coordinates)
coordinates
- List of 0-based coordinates of the cell
java.lang.IndexOutOfBoundsException
- if coordinates are outside CellSet
boundsCell getCell(int ordinal)
Equivalent to
getCell(ordinalToCoordinates(ordinal))
ordinal
- 0-based ordinal of the cell
java.lang.IndexOutOfBoundsException
- if ordinal lies outside CellSet boundsCell getCell(Position... positions)
Equivalent to
getCell( Arrays.asList( positions[0].ordinal(), positions[1].ordinal() [, ...]))
positions
- Array of positions
java.lang.IllegalArgumentException
- if positions does not have the same
number of members as the cell set has axes
java.lang.IndexOutOfBoundsException
- if positions lie outside CellSet
boundsjava.util.List<java.lang.Integer> ordinalToCoordinates(int ordinal)
ordinal
- Cell ordinal
int coordinatesToOrdinal(java.util.List<java.lang.Integer> coordinates)
coordinates
- Cell coordinates
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |