public class MdmDerivedMeasure extends MdmMeasure
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
method of an findOrCreateDerivedMeasure
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.
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
LOOP_TYPE_DENSE
A static constant that represents the OLAP DML
$LOOP_TYPE system property value DENSE. |
static java.lang.String |
LOOP_TYPE_INNER
A static constant that represents the OLAP DML
$LOOP_TYPE system property value INNER. |
static java.lang.String |
LOOP_TYPE_OUTER
A static constant that represents the OLAP DML
$LOOP_TYPE system property value OUTER. |
Modifier and Type | Method and Description |
---|---|
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 . |
MdmViewColumn |
getETMeasureColumn()
Gets the ET (Embedded Totals) column for the MdmMeasure.
|
boolean |
getFailedCompile()
Gets the value of the OLAP DML
$FAILED_COMPILE system property for the measure in the analytic workspace. |
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 |
getLoopDenseThresholdOverride() |
java.lang.String |
getLoopInvariantOverride() |
java.lang.String |
getLoopInvariantValuesetOverride() |
java.lang.String |
getLoopType()
Gets the value of the OLAP DML
$LOOP_TYPE system property for 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 |
setLoopDenseThresholdOverride(java.lang.String val) |
void |
setLoopInvariantOverride(java.lang.String val) |
void |
setLoopInvariantValuesetOverride(java.lang.String val) |
void |
setLoopType(java.lang.String value)
Specifies the OLAP DML
$LOOP_TYPE system property for the derived 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 derived measure in the analytic workspace. |
void |
setMeasureExpression(Expression input)
Specifies an
Expression that determines the values of this MdmDerivedMeasure . |
addDimensionality, getColumnObject, getCube, getDimensionality, getLevel, getLevelDepth, getLocalValue, getMeasureDimension, getOwnerDimension, getParentLevel, getParentLocalValue, getParentValue, getPrecedence, getType, getUnits, getValue, getValueFormat, removeDimensionality, setCube, setUnits, setValueFormat
addDimension, getDimensions, isBooleanValued, setBooleanValued
getDataType, getSource
addDescription, addObjectClassification, findOrCreateDescription, getDescription, getDescription, getDescription, getDescriptions, getMetadataProvider, getObjectClassifications, getShortDescription, isClassifiedAs, removeDescription, removeObjectClassification, setDescription, setDescription, setDescription, setName, setShortDescription
getContainedByObject, getID, getName, getNewName, getOwner
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getDataType, getDescription, getShortDescription, getSource
getName
public static final java.lang.String LOOP_TYPE_INNER
$LOOP_TYPE
system property value INNER.public static final java.lang.String LOOP_TYPE_OUTER
$LOOP_TYPE
system property value OUTER.public static final java.lang.String LOOP_TYPE_DENSE
$LOOP_TYPE
system property value DENSE.public java.lang.Object acceptVisitor(MdmObjectVisitor visitor, java.lang.Object context)
visitMdmDerivedMeasure
method of the MdmObjectVisitor
and passes that method this MdmDerivedMeasure
and an Object
.acceptVisitor
in class MdmObject
visitor
- An MdmObjectVisitor
that is an instance of Mdm11_ObjectVisitor
.context
- An Object
.Object
returned by the visitMdmDerivedMeasure
method.public final Expression getMeasureExpression()
Expression
that determines the values of this MdmDerivedMeasure
.Expression
that determines the values of this MdmDerivedMeasure
.public final void setMeasureExpression(Expression input)
Expression
that determines the values of this MdmDerivedMeasure
.input
- An Expression
that determines the values of this MdmDerivedMeasure
.public final SQLDataType getSQLDataType()
MdmDerivedMeasure
.SQLDataType
that represents the SQL data type.public final java.lang.String getLoopVarOverride()
$LOOP_VAR
system property for the measure in the analytic workspace. For information on the $LOOP_VAR
property, see Oracle OLAP DML Reference.String
that contains the names of the OLAP DML variables that are specified by the $LOOP_VAR
property.public final void setLoopVarOverride(java.lang.String value)
$LOOP_VAR
system property for the derived measure in the analytic workspace. The $LOOP_VAR
property applies to the underlying formula for the measure. For information on OLAP DML variables, formulas, and system properties, see Oracle OLAP DML Reference.
The value specified by this method overrides the default $LOOP_VAR value set by Oracle OLAP. If you use this method to set the $LOOP_VAR value, then Oracle OLAP uses OUTER looping and ignores any value set by the setLoopType
method.
Note: You might want to use this method if the Expression
of the MdmDerivedMeasure
includes an OLAPDMLExpression
.
value
- A String
that contains the names of one or more variables on separate lines, as in "var1\nvar2"
.setLoopType(String value)
public final java.lang.String getLoopType()
$LOOP_TYPE
system property for the measure in the analytic workspace. For information on the $LOOP_TYPE
property, see Oracle OLAP DML Reference.String
that contains the value of the OLAP DML $LOOP_TYPE
system property.public final void setLoopType(java.lang.String value)
$LOOP_TYPE
system property for the derived measure in the analytic workspace. The $LOOP_TYPE
property controls the type of looping that Oracle OLAP does for a derived measure that has an Expression
that references measures from more than one cube. The value specified by this method overrides the default $LOOP_TYPE value set by Oracle OLAP, which is INNER.
The $LOOP_TYPE
property applies to the underlying formula for the measure. For information on OLAP DML composites, formulas, and system properties, see Oracle OLAP DML Reference.
Note: You might want to use this method if the Expression
of the MdmDerivedMeasure
includes an OLAPDMLExpression
.
value
- One of the static constants MdmDerivedMeasure.LOOP_TYPE_INNER
, MdmDerivedMeasure.LOOP_TYPE_OUTER
, or MdmDerivedMeasure.LOOP_TYPE_DENSE
.setLoopVarOverride(String value)
public final boolean getFailedCompile()
$FAILED_COMPILE
system property for the measure in the analytic workspace.Boolean
that contains the value of the OLAP DML $FAILED_COMPILE
property.public final java.lang.String getLoopDenseOverride()
$LOOP_DENSE
system property of the measure in the analytic workspace. For information on the $LOOP_DENSE
property, see Oracle OLAP DML Reference.String
that contains the names of the OLAP DML dimensions that are specified by the $LOOP_DENSE
property.public final void setLoopDenseOverride(java.lang.String value)
$LOOP_DENSE
system property of the measure in the analytic workspace. The value specified by this method overrides the default $LOOP_DENSE
value used by Oracle OLAP.
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.
Note: You might want to use this method if the Expression
of the MdmDerivedMeasure
includes an OLAPDMLExpression
.
value
- A String
that contains the names of one or more dimensions on separate lines, as in "dim1\ndim2"
.public final MdmViewColumn getETMeasureColumn()
getETMeasureColumn
in class MdmMeasure
MdmViewColumn
that represents the ET column. If the server compilation fails or is not yet sent over to the server, returns null.public final java.lang.String getLoopInvariantOverride()
public final void setLoopInvariantOverride(java.lang.String val)
public final java.lang.String getLoopInvariantValuesetOverride()
public final void setLoopInvariantValuesetOverride(java.lang.String val)
public final java.lang.String getLoopDenseThresholdOverride()
public final void setLoopDenseThresholdOverride(java.lang.String val)