Skip navigation links

oracle.olapi.metadata.mdm
Class MdmDerivedMeasure

java.lang.Object
oracle.olapi.metadata.BaseMetadataObject
oracle.olapi.metadata.mdm.MdmObject
oracle.olapi.metadata.mdm.MdmSource
oracle.olapi.metadata.mdm.MdmDimensionedObject
oracle.olapi.metadata.mdm.MdmMeasure
oracle.olapi.metadata.mdm.MdmDerivedMeasure

All Implemented Interfaces:

MdmMember, MdmViewColumnOwner, MetadataObject

public class MdmDerivedMeasure

extends MdmMeasure

An MdmMeasure that has values that Oracle OLAP derives from an Expression. The values of an MdmDerivedMeasure are calculated on the fly by Oracle OLAP and are not stored in the database. An MdmDerivedMeasure does not have an associated ConsistentSolveSpecification.

With the findOrCreateDerivedMeasure method of an MdmCube, you can get an existing MdmDerivedMeasure or create a new one. Committing the Transaction in which you create a derived measure makes the MdmDerivedMeasure a persistent object. It adds the MdmDerivedMeasure to the data dictionary, which makes it available to other applications.

Method Summary

java.lang.Object	acceptVisitor(MdmObjectVisitor visitor, java.lang.Object context) Calls the visitMdmDerivedMeasure method of the MdmObjectVisitor and passes that method this MdmDerivedMeasure and an Object.
java.lang.String	getLoopDenseOverride() Gets the value of the OLAP DML $LOOP_DENSE system property of the measure in the analytic workspace.
java.lang.String	getLoopVarOverride() Gets the value of the OLAP DML $LOOP_VAR system property for the measure in the analytic workspace.
Expression	getMeasureExpression() Gets the Expression that determines the values of this MdmDerivedMeasure.
SQLDataType	getSQLDataType() Gets the SQL data type for this MdmDerivedMeasure.
void	setLoopDenseOverride(java.lang.String value) Specifies the OLAP DML dimensions for the OLAP DML $LOOP_DENSE system property of the measure in the analytic workspace.
void	setLoopVarOverride(java.lang.String value) Specifies the OLAP DML variables for the OLAP DML $LOOP_VAR system property for the measure in the analytic workspace.
void	setMeasureExpression(Expression input) Specifies an Expression that determines the values of this MdmDerivedMeasure.

Methods inherited from class oracle.olapi.metadata.mdm.MdmMeasure

addDimensionality, getCube, getDimensionality, getETMeasureColumn, getLevel, getLevelDepth, getLocalValue, getMeasureDimension, getOwnerDimension, getParentLevel, getParentLocalValue, getParentValue, getPrecedence, getType, getUnits, getValue, getValueFormat, removeDimensionality, setCube, setUnits, setValueFormat

Methods inherited from class oracle.olapi.metadata.mdm.MdmDimensionedObject

addDimension, getDimensions, isBooleanValued, setBooleanValued

Methods inherited from class oracle.olapi.metadata.mdm.MdmSource

getDataType, getSource

Methods inherited from class oracle.olapi.metadata.mdm.MdmObject

addDescription, addObjectClassification, findOrCreateDescription, getDescription, getDescription, getDescription, getDescriptions, getMetadataProvider, getName, getNewName, getObjectClassifications, getShortDescription, isClassifiedAs, removeDescription, removeObjectClassification, setDescription, setDescription, setDescription, setName, setShortDescription

Methods inherited from class oracle.olapi.metadata.BaseMetadataObject

getContainedByObject, getID, getOwner

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface oracle.olapi.metadata.mdm.MdmMember

getDataType, getDescription, getShortDescription, getSource

Method Detail

acceptVisitor

public java.lang.Object acceptVisitor(MdmObjectVisitor visitor,
                                      java.lang.Object context)

Calls the visitMdmDerivedMeasure method of the MdmObjectVisitor and passes that method this MdmDerivedMeasure and an Object.

Specified by:

acceptVisitor in class MdmObject

Parameters:

visitor - An MdmObjectVisitor that is an instance of Mdm11_ObjectVisitor.

context - An Object.

Returns:

The Object returned by the visitMdmDerivedMeasure method.

getMeasureExpression

public final Expression getMeasureExpression()

Gets the Expression that determines the values of this MdmDerivedMeasure.

Returns:

The Expression that determines the values of this MdmDerivedMeasure.

setMeasureExpression

public final void setMeasureExpression(Expression input)

Specifies an Expression that determines the values of this MdmDerivedMeasure.

Parameters:

input - An Expression that determines the values of this MdmDerivedMeasure.

getSQLDataType

public final SQLDataType getSQLDataType()

Gets the SQL data type for this MdmDerivedMeasure.

Returns:

A SQLDataType that represents the SQL data type.

getLoopVarOverride

public final java.lang.String getLoopVarOverride()

Gets the value of the OLAP DML $LOOP_VAR system property for the measure in the analytic workspace.

Returns:

A String that contains the names of the OLAP DML variables that are specified by the $LOOP_VAR property.

setLoopVarOverride

public final void setLoopVarOverride(java.lang.String value)

Specifies the OLAP DML variables for the OLAP DML $LOOP_VAR system property for the measure in the analytic workspace. The $LOOP_VAR property applies to the underlying formula for the derived measure. For information on the $LOOP_VAR property, see Oracle OLAP DML Reference.

The value specified by this method overrides the default value used by Oracle OLAP. You might want to use this method if the Expression of the MdmDerivedMeasure includes an OLAPDMLExpression.

Parameters:

value - A String that contains the names of one or more variables on separate lines, as in "var1\nvar2".

getLoopDenseOverride

public final java.lang.String getLoopDenseOverride()

Gets the value of the OLAP DML $LOOP_DENSE system property of the measure in the analytic workspace.

Returns:

A String that contains the names of the OLAP DML dimensions that are specified by the $LOOP_DENSE property.

setLoopDenseOverride

public final void setLoopDenseOverride(java.lang.String value)

Specifies the OLAP DML dimensions for the OLAP DML $LOOP_DENSE system property of the measure in the analytic workspace. The $LOOP_DENSE property applies to the underlying formula for the derived measure. For information on the $LOOP_DENSE property, see Oracle OLAP DML Reference.

The value specified by this method overrides the default value used by Oracle OLAP. You might want to use this method if the Expression of the MdmDerivedMeasure includes an OLAPDMLExpression.

Parameters:

value - A String that contains the names of one or more dimensions on separate lines, as in "dim1\ndim2".

Skip navigation links