oracle.olapi.data.source
Class NumberParameter

java.lang.Object
  |
  +--oracle.olapi.data.source.Parameter
        |
        +--oracle.olapi.data.source.NumberParameter

public class NumberParameter

extends Parameter

A Parameter that specifies a number value that you use in creating a query. After creating the query, you can change the value of the NumberParameter and thereby change the selection of dimension or measure elements that the query represents.

You use a NumberParameter to create a parameterized NumberSource with the createParameterizedSource(NumberParameter param) method of the DataProvider you used to create the NumberParameter. You then use the parameterized NumberSource as a parameter to a method that selects one or more elements of another Source and produces a derived Source. You can commit the Transaction and create a Cursor for the Source to retrieve the results of the query.

You can change the selection of elements that the derived Source represents by changing the value of the NumberParameter with the appropriate setValue method. The Cursor for the query Source then has the values of the new selection. You do not need to commit the Transaction nor create a new Cursor. You can instead just set the position of the existing Cursor to its first position and get the values for the new selection from the Cursor.

The following example creates a NumberParameter with the value 1000 and uses it to create a parameterized NumberSource. The dp object is the DataProvider and tp is the TransactionProvider. The example joins Source objects for a measure of product units sold, and for single selections from the default hierarchies of three of the four dimensions of the measure. The example then produces a selection of product values, paramProdSel, for which the number of units sold is greater than the value of the NumberParameter. It joins the paramProdSel to the Source for the short description attribute for the product dimension, which produces the results Source. Finally, the example creates a Cursor for results.

 NumberParameter numParam = new NumberParameter(dp, 1000);
 NumberSource numParamSrc = dp.createParameterizedSource(numParam);
 NumberSource qualifiedUnits =
          (NumberSource) units.join(timeHier, "CALENDAR::YEAR::4")
                              .join(custHier, "SHIPMENTS_ROLLUP::REGION::9")
                              .join(chanHier,"CHANNEL_ROLLUP::CHANNEL::4");
 Source paramProdSel = prodHier.select(qualifiedUnits.gt(numParamSrc));
 Source results = prodShortDescr.join(paramProdSel);

 // try, catch block omitted for brevity
 tp.prepareCurrentTransaction();
 tp.commitCurrentTransaction();

 CursorManagerSpecification cMngrSpec =
                dp.createCursorManagerSpecification(results);
 SpecifiedCursorManager  spCMngr = dp.createCursorManager(cMngrSpec);
 Cursor resultsCursor = spCMngr.createCursor();

The following table displays the values of resultsCursor and adds column heading.

 Product                           Short Description
 --------------------------------  -----------------
 PRODUCT_ROLLUP::TOTAL_PRODUCT::1  Total Product
 PRODUCT_ROLLUP::CLASS::2          Hardware
 PRODUCT_ROLLUP::FAMILY::9         Modems/Fax
 PRODUCT_ROLLUP::FAMILY::11        CD-ROM
 PRODUCT_ROLLUP::CLASS::3          Software/Other
 PRODUCT_ROLLUP::FAMILY::6         Operating Systems
 PRODUCT_ROLLUP::FAMILY::7         Accessories

The following continuation of the example sets the value of the NumberParameter to 1500. It then sets the position of resultsCursor back to the first position of the Cursor.

 numParam.setValue(1500);
 // Reset the Cursor position to 1
 resultsCursor.setPosition(1);

The following table displays the values that resultsCursor now contains and adds column heading.

 Product                           Short Description
 --------------------------------  -----------------
 PRODUCT_ROLLUP::TOTAL_PRODUCT::1  Total Product
 PRODUCT_ROLLUP::CLASS::2          Hardware
 PRODUCT_ROLLUP::CLASS::3          Software/Other
 PRODUCT_ROLLUP::FAMILY::7         Accessories

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       java.lang.Short initialValue)

Creates a NumberParameter that has the specified Short value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The Short that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       short initialValue)

Creates a NumberParameter that has the specified short value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The short that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       java.lang.Integer initialValue)

Creates a NumberParameter that has the specified Integer value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The Integer that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       int initialValue)

Creates a NumberParameter that has the specified integer value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The int that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       java.lang.Long initialValue)

Creates a NumberParameter that has the specified Long value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The Long that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       long initialValue)

Creates a NumberParameter that has the specified long value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The long that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       java.lang.Float initialValue)

Creates a NumberParameter that has the specified Float value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The Float that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       float initialValue)

Creates a NumberParameter that has the specified float value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The float that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       java.lang.Double initialValue)

Creates a NumberParameter that has the specified Double value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The Double that you want this NumberParameter to have.

NumberParameter

public NumberParameter(DataProvider dataProvider,
                       double initialValue)

Creates a NumberParameter that has the specified double value.

Parameters:

dataProvider - The DataProvider that you are using.

initialValue - The double that you want this NumberParameter to have.

acceptVisitor

public final java.lang.Object acceptVisitor(ParameterVisitor visitor,
                                            java.lang.Object context)

Calls the visitNumberParameter method of the specified ParameterVisitor and passes that method this NumberParameter and the specified context Object.

Parameters:

visitor - An instance a class derived from the ParameterVisitor class.

context - An Object.

Returns:

The Object returned by the visitNumberParameter method of the specified ParameterVisitor.

Overrides:

acceptVisitor in class Parameter

getShortValue

public final short getShortValue()

Gets the value of this NumberParameter as a short.

Returns:

The value of this NumberParameter as a short.

getIntValue

public final int getIntValue()

Gets the value of this NumberParameter as an integer.

Returns:

The value of this NumberParameter as a int.

getLongValue

public final long getLongValue()

Gets the value of this NumberParameter as a long.

Returns:

The value of this NumberParameter as a long.

getFloatValue

public final float getFloatValue()

Gets the value of this NumberParameter as a float.

Returns:

The value of this NumberParameter as a float.

getDoubleValue

public final double getDoubleValue()

Gets the value of this NumberParameter as a double.

Returns:

The value of this NumberParameter as a double.

getValue

public final java.lang.Number getValue()

Gets the value of this NumberParameter as an OLAP API Number.

Returns:

The value of this NumberParameter as an OLAP API Number.

getValueObject

public final java.lang.Object getValueObject()

Gets the value of this NumberParameter as an Object.

Returns:

The value of this NumberParameter as an Object.

Overrides:

getValueObject in class Parameter

setValue

public final void setValue(java.lang.Short value)

Sets the value of this NumberParameter to the specified Short.

Parameters:

value - The Short that you want this NumberParameter to have.

setValue

public final void setValue(short value)

Sets the value of this NumberParameter to the specified short.

Parameters:

value - The short that you want this NumberParameter to have.

setValue

public final void setValue(java.lang.Integer value)

Sets the value of this NumberParameter to the specified Integer.

Parameters:

value - The Integer that you want this NumberParameter to have.

setValue

public final void setValue(int value)

Sets the value of this NumberParameter to the specified integer.

Parameters:

value - The int that you want this NumberParameter to have.

setValue

public final void setValue(java.lang.Long value)

Sets the value of this NumberParameter to the specified Long.

Parameters:

value - The Long that you want this NumberParameter to have.

setValue

public final void setValue(long value)

Sets the value of this NumberParameter to the specified long.

Parameters:

value - The long that you want this NumberParameter to have.

setValue

public final void setValue(java.lang.Float value)

Sets the value of this NumberParameter to the specified Float.

Parameters:

value - The Float that you want this NumberParameter to have.

setValue

public final void setValue(float value)

Sets the value of this NumberParameter to the specified float.

Parameters:

value - The float that you want this NumberParameter to have.

setValue

public final void setValue(java.lang.Double value)

Sets the value of this NumberParameter to the specified Double.

Parameters:

value - The Double that you want this NumberParameter to have.

setValue

public final void setValue(double value)

Sets the value of this NumberParameter to the specified double.

Parameters:

value - The double that you want this NumberParameter to have.