Skip navigation links

oracle.olapi.data.cursor
Interface CompoundCursor

All Superinterfaces:

Cursor

public interface CompoundCursor

extends Cursor

A Cursor for a Source that has outputs. A CompoundCursor has a child base ValueCursor, the elements of which have the values specified by the Source. A CompoundCursor also has one or more outputs, one for each output of the Source. The outputs of the CompoundCursor are child CompoundCursor or ValueCursor objects.

The order of the outputs of a CompoundCursor is determined by the order of the outputs of the Source. The value of the base ValueCursor at any position in a CompoundCursor is determined by the set of the values of the elements of the outputs specified by that position.

For example, in the following code unitPrice is the Source for an MdmMeasure, and prodHier and calHier are StringSource objects for the default MdmLevelHierarchy objects for the Product and Time dimensions, which are the dimensions of the measure.

 Source productsSel =
        prodHier.selectValues(new String[] {"PROD_HIER::PRODUCT::1701",
                                            "PROD_HIER::PRODUCT::1815",
                                            "PROD_HIER::PRODUCT::1936",
                                            "PROD_HIER::PRODUCT::2054"};
 Source timesSel =
        calHier.selectValues(new String[] {"CAL_HIER::DAY::14-JUN-99",
                                           "CAL_HIER::DAY::14-JUN-00"};
 Source productsPriceForDay = unitPrice.join(productsSel).join(timesSel);

The productsPriceForDay Source specifies the price of the selected products on the selected days. It has the unitPrice values as element values, and it has productsSel and timesSel as outputs. The following code creates a CursorManager and a Cursor for productsPriceForDay. The dp object is the DataProvider.

 CursorManager cursorManager = dp.createCursorManager(productsPriceForDay);
 Cursor result = cursorManager.createCursor();

Because the productsPriceForDay has outputs, result is a CompoundCursor. The base ValueCursor has the values from unitPrice that are specified by the set of the values of the outputs. The outputs of the CompoundCursor are two ValueCursor objects. The first output has the element values of timesSel and the second output has the element values of productsSel.

The following table is a display of the values of result, formatted into columns. The table shows the current value of each ValueCursor at each position of the CompoundCursor. The left column has the values of the ValueCursor for the first output, the middle column has values of the ValueCursor for the second output, and right column has the values of the base ValueCursor. The display contains only the local values of the dimensions, not the three-part unique values.

    14-JUN-99   1701    56.00
    14-JUN-99   1815   276.50
    14-JUN-99   1936    10.00
    14-JUN-99   2054   112.00
    14-JUN-00   1701    44.80
    14-JUN-00   1815   316.00
    14-JUN-00   1936    10.00
    14-JUN-00   2054   160.40

The following table shows the positions of the CompoundCursor and the child Cursor objects and the value at each ValueCursor position. The left column has the positions of the parent CompoundCursor. The second column from the left has the positions of the ValueCursor for timesSel and the values at those positions. The third column from the left has the positions of the ValueCursor for productsSel and the values at those positions. The right column has the positions of the base ValueCursor and the values at those positions.

 CompoundCursor      Output 1               Output 2       Base ValueCursor
 --------------  --------------------   ----------------   -----------------
    Position     Position     Value     Position   Value   Position   Value
    --------     --------   ---------   --------   -----   --------   ------
       1            1       14-JUN-99      1       1701       1        56.00
       2            1       14-JUN-99      2       1815       1       276.50
       3            1       14-JUN-99      3       1936       1        10.00
       4            1       14-JUN-99      4       2054       1       112.00
       5            2       14-JUN-00      1       1701       1        44.80
       6            2       14-JUN-00      2       1815       1       316.00
       7            2       14-JUN-00      3       1936       1        10.00
       8            2       14-JUN-00      4       2054       1       106.40

In the example, each set of output values specifies only one unit price value. The base ValueCursor therefore has only one position for each set of output values.

Field Summary

Fields inherited from interface oracle.olapi.data.cursor.Cursor

FETCH_SIZE_NOT_SPECIFIED

Method Summary

java.util.List	getOutputs() Gets the outputs of the CompoundCursor.
ValueCursor	getValueCursor() Gets the base ValueCursor of the CompoundCursor.

Methods inherited from interface oracle.olapi.data.cursor.Cursor

getExtent, getFetchSize, getParentEnd, getParentStart, getPosition, getSource, next, setFetchSize, setPosition

Method Detail

getValueCursor

ValueCursor getValueCursor()

Gets the base ValueCursor of the CompoundCursor. The base ValueCursor has the values of the Source for the CompoundCursor.

Returns:

The base ValueCursor of the CompoundCursor.

getOutputs

java.util.List getOutputs()

Gets the outputs of the CompoundCursor. An output is a ValueCursor or a CompoundCursor. A CompoundCursor has one output for each output of the associated Source.

Returns:

A List that contains the outputs of this CompoundCursor.

Skip navigation links