|
Oracle™ Business Intelligence Beans Java API Reference | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--oracle.dss.dataSource.common.QueryDataAccess
QueryDataAccess DataView's DataAccess interface.
Method Summary | |
boolean |
dropChanges() |
void |
endGroupEdit() |
int |
findMember(int edge, int[] hPos, int memberLayer, java.lang.String s, java.lang.String type, int flags) Finds the location of a given string. |
boolean |
forceFetch(int[] startSlice, int[] endSlice) Ensures that a range of data has been fetched to the client for display, if possible. |
boolean |
forceFetch(long rowmin, long rowmax, long colmin, long colmax) Make sure the data (and metadata corresponding) for the given range has been fetched locally, if possible |
int |
getEdgeCount() Return the total number of edges in the data source. |
int[] |
getEdgeCurrentHPos(int edge) Retrieves the currently set position the given edge in relative hierarchical terms. |
int |
getEdgeCurrentSlice(int edge) Retrieves the number of the current slice. |
int |
getEdgeExtent(int edge) Retrieves the total number of members on the given edge. |
int[] |
getFirstHPos(int edge) Retrieves the hPos identifying the first member on the given edge. |
int[] |
getLastHPos(int edge) Retrieves the hPos identifying the last member on the given edge. |
int |
getLayerCount(int edge) Retrieves the number of layers on the specified edge. |
java.lang.Object |
getLayerMetadata(int edge, int layer, java.lang.String type) Retrieves a piece of metadata for a layer. |
QDR |
getLayerQDR(int edge, int layer, int flags) Retrieves the QDR object that represents the specified logical layer. |
int |
getMemberDepth(int edge, int layer, int slice) Retrieves the number of layers that a member spans at the specified location on the specified edge. |
int |
getMemberExtent(int edge, int depth, int slice) Retrieves the number of slices that a member spans. |
int[] |
getMemberHPos(int edge, int layer, int slice) Retrieves an array of indexes from a page number. |
int |
getMemberLogicalLayer(int edge, int layer, int slice) Return the logical layer that the member at the given edge, physical layer, and slice location is associated with. |
java.lang.Object |
getMemberMetadata(int edge, int[] hPos, int memberLayer, int hIndex, java.lang.String type) Retrieves specified metadata for a member at a specified location. |
java.lang.Object |
getMemberMetadata(int edge, int layer, int slice, java.lang.String type) Retrieves a piece of metadata for a dimension member. |
QDR |
getMemberQDR(int edge, int[] hPos, int memberLayer, int flags) Retrieves a QDR object that represents the specified member using hierarchical addressing. |
QDR |
getMemberQDR(int edge, int layer, int slice, int flags) Retrieves a QDR object that represents the data value for the member at the specified edge, layer, and slice. |
int |
getMemberSiblingCount(int edge, int[] hPos, int memberLayer) Retrieves the number of members at a particular layer and location. |
int |
getMemberStartLayer(int edge, int layer, int slice) Retrieves the starting slice of a member that spans a number of layers on the specified edge. |
int |
getMemberStartSlice(int edge, int layer, int slice) Retrieves the first slice that a member spans. |
int[] |
getNextHPos(int edge, int[] hPos) Retrieves the hPos identifying the next member on the given edge relative to a given hPos . |
int[] |
getPrevHPos(int edge, int[] hPos) Retrieves the hPos identifying the previous member on the given edge relative to a given hPos . |
java.util.Vector |
getQDRoverrideCollection() |
java.lang.Object |
getSliceLabel(int edge, int slice, java.lang.String type) Retrieves the label for the specified column. |
int |
getSliceMemberCount(int edge, int slice) Retrieves the number of logical layers at the specified location on the specified edge. |
int |
getSliceOutlineLayer(int edge, int slice) Retrieves the "starting" layer of a specified slice for outline form. |
QDR |
getSliceQDR(int edge, int slice, int flags) Retrieves a QDR object that represents the data value at the specified slice on the edge (that is, across all relevant logical layers of the slice). |
java.lang.Object |
getValue(int row, int col, java.lang.String type) Return a data value for the given row and column intersection. |
QDR |
getValueQDR(int row, int column, int flags) Retrieves a QDR object that represents the value at the specified row and column in the data area of the cursor. |
boolean |
isAutoSubmit() |
boolean |
isFetched(int[] startSlice, int[] endSlice) Indicates whether a range of data has been fetched to the client for display. |
boolean |
isFetched(long rowmin, long rowmax, long colmin, long colmax) Determine if the given range of data (and of corresponding metadata) has been fetched locally. |
boolean |
redoEdit() |
void |
release() Inform the holder of the data and metadata that the caller no longer needs this data. |
void |
setAutoSubmit(boolean bValue) |
boolean |
setValue(java.lang.Object data, int row, int col, java.lang.String type) |
void |
startGroupEdit() |
boolean |
submitChanges() |
boolean |
undoEdit() |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
public int getEdgeExtent(int edge) throws EdgeOutOfRangeException
edge
- Edge of interest.public int getEdgeCount()
public java.lang.Object getValue(int row, int col, java.lang.String type) throws RowOutOfRangeException, ColumnOutOfRangeException
row
- the row to getcol
- the column to gettype
- type specification defined by DataMap to indicate type to getRowOutOfRangeException
- thrown if row is too largeColumnOutOfRangeException
- thrown if column is too largepublic java.lang.Object getSliceLabel(int edge, int slice, java.lang.String type) throws EdgeOutOfRangeException, SliceOutOfRangeException
edge
- Edge of interest.slice
- The slice whose label is desired.type
- A constant that specifies the kind of metadata that you want. Valid type
values are defined in the MetadataMap.EdgeOutOfRangeException
- If edge
is out of range.SliceOutOfRangeException
- If slice
is negative or too large.public int getEdgeCurrentSlice(int edge) throws EdgeOutOfRangeException
Suppose that you have a Time dimension and a City dimension on the page edge. Suppose the City dimension has three members. The first five pages are as follows:
public int[] getEdgeCurrentHPos(int edge) throws EdgeOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.EdgeOutOfRangeException
- If edge
is out of range.public int getLayerCount(int edge) throws EdgeOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.EdgeOutOfRangeException
- If edge
is out of range.public int getSliceMemberCount(int edge, int slice) throws EdgeOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of interest. Constants are defined in the DataDirector implementation.slice
- The slice that identifies a location along the edge of interest. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer layer spans can be used.EdgeOutOfRangeException
- If edge
is out of range.SliceOutOfRangeException
- If slice
is negative or too large.public int getMemberDepth(int edge, int layer, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
This method is useful only in cases of asymmetry where the members on an edge do not all span one layer and have a depth of 1. Normally, all members have a member depth of 1.
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The starting layer of the member, as returned by getMemberStartLayer
.slice
- The location along the edge. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too large.SliceOutOfRangeException
- If slice
is negative or too large.public int getMemberStartLayer(int edge, int layer, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
This method is useful only in cases of asymmetry where the members on an edge do not all span one layer. Normally, all members have a member start layer equal to their layer.
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the dimensionslice
- The location along the edge. The slice is zero-based. Each dimension member in the innermost dimension has a unique slice. In outer layers, any slice that the outer member spans can be used.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too large.SliceOutOfRangeException
- If slice
is negative or too large.public int getMemberLogicalLayer(int edge, int layer, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
getLayerMetadata
.edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the memberslice
- The location along the edge. The slice is zero-based. Each member in the innermost dimension has a unique slice. In outer layers, any slice that the outer member spans can be used.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too large.SliceOutOfRangeException
- If slice
is negative or too large.public java.lang.Object getLayerMetadata(int edge, int layer, java.lang.String type) throws EdgeOutOfRangeException, LayerOutOfRangeException
edge
- The edge of interest. The constants are defined in the DataDirector implementation.dimension
- The layer for which you want metadata. Uses a depth computation to identify the location of the layer or layer member; 0 is the outer-most layer on the edge.type
- A constant that specifies the kind of metadata that you want. Valid type
values are defined in the LayerMetadataMap.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too large.public int getMemberExtent(int edge, int depth, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the dimension of interest. Valid values are zero to total layer at the specified slice.slice
- The location along the edge. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too largeSliceOutOfRangeException
- If slice
is negative or too largegetMemberStartSlice(int, int, int)
public int getMemberStartSlice(int edge, int layer, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
getMemberExtent
.edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the dimension of interest. Valid values are zero to total layer at the specified slice.slice
- The location along the edge. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.getMemberExtent
returns.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If layer
is negative or too large.SliceOutOfRangeException
- If slice
is negative or too large.getMemberExtent(int, int, int)
public java.lang.Object getMemberMetadata(int edge, int layer, int slice, java.lang.String type) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the member of interest. Valid values are zero to total layers at the specified slice.slice
- The location along the edge. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.type
- A constant that specifies the kind of metadata that you want. Valid type
values are defined in the MetadataMap.LayerOutOfRangeException
- If layer
is negative or too large.SliceOutOfRangeException
- If slice
is negative or too large.public QDR getValueQDR(int row, int column, int flags) throws RowOutOfRangeException, ColumnOutOfRangeException
row
- The row in the data cursor for which to return the QDR.column
- The column in the data cursor for which to return the QDR.QDR
object that refers to the data at the specified location.RowOutOfRangeException
- If the row
parameter is not valid.ColumnOutOfRangeException
- If the column
parameter is not valid.public QDR getSliceQDR(int edge, int slice, int flags) throws EdgeOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of in which to find the slice. The constants end with _EDGE
in DataDirector
.slice
- An absolute index (zero-based) that indicates the location of the slice along the specified edge.QDR
object that refers to the data at the specified location.EdgeOutOfRangeException
- If the edge
parameter is not valid.SliceOutOfRangeException
- If the slice
parameter is not valid.DataDirector.COLUMN_EDGE
, DataDirector.PAGE_EDGE
, DataDirector.ROW_EDGE
public QDR getMemberQDR(int edge, int layer, int slice, int flags) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of interest. The constants end with _EDGE
in DataDirector
.layer
- A zero-based index that represents the physical layer of the member for which the QDR object is requested.slice
- An absolute index (zero-based) that indicates the location, along the specified edge, of a slice that belongs to the member for which the QDR object is requested.QDR
object that refers to the data at the specified position.EdgeOutOfRangeException
- If edge
is not valid.LayerOutOfRangeException
- If layer
is not valid for the specified edge
.SliceOutOfRangeException
- If slice
is not valid for the specified edge
and layer
.DataDirector.COLUMN_EDGE
, DataDirector.PAGE_EDGE
, DataDirector.ROW_EDGE
public QDR getMemberQDR(int edge, int[] hPos, int memberLayer, int flags) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge in which to find the member. The constants end with _EDGE
in DataDirector
.hPos
- An array of relative indices that are organized by logical layer. The indices start at layer 0 and extend at least through the layer that is specified in memberLayer
.memberLayer
- The zero-based index into the hpos
array that indicates the layer in which to find the member.QDR
object that refers to the data at the specified hpos
and memberlayer
within the hpos
.EdgeOutOfRangeException
- If edge
is not valid.LayerOutOfRangeException
- If memberLayer
is not valid for the specified edge.SliceOutOfRangeException
- If the values in the hpos
array are not valid relative indices in the specified hierarchy.DataDirector.COLUMN_EDGE
, DataDirector.PAGE_EDGE
, DataDirector.ROW_EDGE
public QDR getLayerQDR(int edge, int layer, int flags) throws EdgeOutOfRangeException, LayerOutOfRangeException
edge
- A constant that represents the edge in which to find the logical layer. The constants end with _EDGE
in DataDirector
.layer
- The zero-based index of the logical layer for which to return the QDR.QDR
object that refers to the data in the specified layer.EdgeOutOfRangeException
- If edge
is not valid.LayerOutOfRangeException
- If the logical layer
is not valid for the specified edge
.DataDirector.COLUMN_EDGE
, DataDirector.PAGE_EDGE
, DataDirector.ROW_EDGE
public int getMemberSiblingCount(int edge, int[] hPos, int memberLayer) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
June | July | ||||||||||
Tents | Canoes | Tents | Canoes | ||||||||
NY | Boston | LA | Toronto | Winnepeg | NY | LA | NY | Boston | LA | Toronto | Winnepeg |
Views would call this method to find the number of Geography values under Canoes for June. This method provides the upper limit to the hIndex that the views pass in getMemberMetadata
.
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.hPos
- An array that contains an index for the parent values at each layer above the layer of the dimension of interest. These indexes are relative to the number of members for that parent at that layer. For the example above, hPos
would be {0,1}. At depth 0 (Month), June is index 0; at depth 1 (Product), Canoes is index 1. When a member spans more than one layer, any layers beyond the starting layer should have their place held by a -1 index.memberLayer
- Indicates the layer of interestEdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If memberLayer
is too large.SliceOutOfRangeException
- If any slice in hPos
is too large.getMemberMetadata(int, int, int, java.lang.String)
public java.lang.Object getMemberMetadata(int edge, int[] hPos, int memberLayer, int hIndex, java.lang.String type) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
getMemberSiblingCount
to find the number of members. Then they call this method to retrieve the metadata for each member.edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.hPos
- An array that contains an index for the parent values at each layer above the layer of interest. Views pass the same hPos
that was passed for getMemberSiblingCount
.memberLayer
- Indicates the layer of interesthIndex
- The index of the member whose metadata the view wants. Valid values are 0 to (getMemberSiblingCount() - 1)
.type
- A constant that specifies the kind of metadata that you want. Valid type
values are defined in the MetatdataMap.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If memberLayer
is too large.SliceOutOfRangeException
- If any slice in hPos
is too large, or if the hIndex
is too large.public int[] getMemberHPos(int edge, int layer, int slice) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
hPos
parameter in calls to getMemberSiblingCount
and getMemberMetadata
.
The array of indexes that this method returns has an index for each layer in the page edge. For example, imagine pivoting the following column header to the page edge.
June | July | ||||||||||
Tents | Canoes | Tents | Canoes | ||||||||
NY | Boston | LA | Toronto | Winnepeg | NY | LA | NY | Boston | LA | Toronto | Winnepeg |
If the current page were page 5 (June, Canoes, Winnepeg), this method would return the array {0, 1}. June is at index 0 in the dimension at depth 0. Canoes is at index 1 at depth 1 under June. To find the number of dimension members under Canoes under June, you would call getMemberSiblingCount
with the array {0}.
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.layer
- The layer of the dimension of interest. Valid values are zero to total layer at the specified slice.slice
- The location along the edge. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.public int[] getFirstHPos(int edge) throws EdgeOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.EdgeOutOfRangeException
- If edge
is too large.public int[] getLastHPos(int edge) throws EdgeOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.EdgeOutOfRangeException
- If edge
is too large.public int[] getPrevHPos(int edge, int[] hPos) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
hPos
.edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.hPos
- Identifies the member for which this call should return the previous member on the edgehPos
is the first one, null is returned.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If hPos
is too long.SliceOutOfRangeException
- If any slice in hPos
is too largepublic int[] getNextHPos(int edge, int[] hPos) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
hPos
.edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.hPos
- Identifies the member for which this call should return the next member on the edgehPos
is the last one, null is returned.EdgeOutOfRangeException
- If edge
is too large.LayerOutOfRangeException
- If hPos
is too long.SliceOutOfRangeException
- If any slice in hPos
is too largepublic int findMember(int edge, int[] hPos, int memberLayer, java.lang.String s, java.lang.String type, int flags) throws EdgeOutOfRangeException, LayerOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge along which to search. The constants are defined in the DataDirector implementation.hPos
- The hierarchically specified set of values to searchmemberLayer
- the layer at which to searchs
- The String
to find.type
- A constant that indicates the type of metadata to search. Valid flags
values are defined in the MetadataMap.flags
- type of search - not yet defined.instatus
is true, the return value is suitable to pass as the index
parameter to other DataAccess
methods that take edge
, depth
, and index
parameters. Returns -1 if the String
is not found.EdgeOutOfRangeException
- if edge is invalidLayerOutOfRangeException
- If hPos has invalid layersSliceOutOfRangeException
- If hPos has invalid indexespublic boolean isFetched(long rowmin, long rowmax, long colmin, long colmax)
rowmin
- low end of row rangerowmax
- high end of row rangecolmin
- low end of column rangecolmax
- high end of column rangetrue
if all the data is locally fetched. false
if it is not all locally fetched, or this method is unimplemented.public boolean forceFetch(long rowmin, long rowmax, long colmin, long colmax)
rowmin
- low end of row rangerowmax
- high end of row rangecolmin
- low end of column rangecolmax
- high end of column rangetrue
if the data was successfully locally fetched. false
if it could not be locally fetched, or if this method is unimplemented.public int getSliceOutlineLayer(int edge, int slice) throws EdgeOutOfRangeException, SliceOutOfRangeException
edge
- A constant that represents the edge of interest. The constants are defined in the DataDirector implementation.slice
- The location along the edge of interest. The slice is zero-based. Each member in the innermost layer has a unique slice. In outer layers, any slice that the outer member spans can be used.(getSliceMemberCount(edge, slice)-1)
.SliceOutOfRangeException
- If slice
is negative or too large.public boolean isFetched(int[] startSlice, int[] endSlice) throws SliceOutOfRangeException
startSlice
- start slicesendSlice
- matching end slicestrue
if all the data is fetched, false
if it is not all fetched, or this method is not implemented.SliceOutOfRangeException
- if any of the slices are invalidpublic boolean forceFetch(int[] startSlice, int[] endSlice) throws SliceOutOfRangeException
startSlice
- start slicesendSlice
- matching end slicestrue
if the data was successfully fetched. false
if it could not be fetched, or if this method is not implemented.SliceOutOfRangeException
- if any of the slices are invalidpublic void release()
public boolean setValue(java.lang.Object data, int row, int col, java.lang.String type) throws RowOutOfRangeException, ColumnOutOfRangeException
public java.util.Vector getQDRoverrideCollection()
public void startGroupEdit()
public void endGroupEdit()
public boolean redoEdit()
public boolean undoEdit()
public boolean submitChanges()
public boolean dropChanges()
public void setAutoSubmit(boolean bValue)
public boolean isAutoSubmit()
|
Oracle™ Business Intelligence Beans Java API Reference | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |