| 
 | 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 large
public 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 large
public 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 large
public 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 indexes
public 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 invalid
public 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 | ||||||||