Package oracle.olapi.metadata.mtm

Contains classes that map objects in the multidimensional model (MDM) for metadata to the relational tables and views on which those objects are based.

See:
Description

Interface Summary

MtmObjectVisitor

A visitor object that can execute operations on some of the classes in the MtmObject class hierarchy.

Class Summary

MtmAggregationSpecification	An MtmSolveSpecification that specifies how to solve an MtmUnsolvedCube, that is, which SQL function to apply when aggregating the data of the measures specified by the dimensions of the cube, the order in which to process the dimensions, and other aspects of the aggregation operations.
MtmAggregationStep	An MtmObject that specifies the SQL function and other aspects of operations to perform when Oracle OLAP aggregates the values of the measures of an MtmUnsolvedCube for the dimension hierarchies of the MtmDimensionMap objects of this MtmAggregationStep.
MtmAttributeMap	An MtmSourceMap for an MdmAttribute.
MtmAWColumnExpression	An MtmColumnExpression that is based on a single column in a relational table or view for an analytic workspace.
MtmAWView	An MtmTableOrView that is mapped to a dynamically generated inline view, for a dynamic analytic workspace, or to a static relational view, for a non-dynamic analytic workspace.
MtmBaseCube	An MtmCube that describes the dimensionality and measures for one hierarchy combination of an MtmPartitionedCube.
MtmColumnExpression	An MtmValueExpression that is based on a single column in a relational table or view.
MtmCompoundExpression	An MtmExpression that is made up of two or more MtmExpression objects, which are the subexpressions of the MtmCompoundExpression.
MtmCompoundTable	An MtmTabularSource that represents a logical table that is based on the join of two component logical tables.
MtmCube	An MtmObject that describes a cube, which has no equivalent object in the MDM metadata model but which is used for mapping MdmDimension and MdmMeasure objects to the SQL tables and expressions on which they are based.
MtmCubeDimensionality	An MtmObject that stores information about the fact table and dimension tables (for one MdmDimension) that Oracle OLAP joins to construct the MdmMeasure objects that share the same MtmBaseCube.
MtmCustomExpression	An MtmValueExpression based on a text string that evaluates to a valid SQL expression and was created by an application developer using the createCustomExpression method in the MdmCustomObjectFactory class.
MtmCustomObjectFactory	An object that creates custom MtmObject objects.
MtmDataType	Specifies the SQL data type characteristics for the mapping of an OLAP API data type to a SQL representation of that data type.
MtmDerivedAttributeMap	An MtmAttributeMap for an MdmAttribute whose values are not explicitly stored but are derived from a column or columns in a dimension table.
MtmDimensionMap	An MtmSourceMap for an MdmDimension.
MtmDimensionOrderSpecification	An MtmObject that records the order in which elements of an MdmLevelHierarchy are arranged.
MtmExpression	An MtmObject that represents a SQL expression whose form is appropriate for inclusion in the select list of a SELECT statement.
MtmFirstLastAggregationStep	An MtmAggregationStep that specifies that Oracle OLAP use the measure value specified by the first or last child element of the current dimension node element when aggregating measure values specified by a dimension of the MtmAggregationStep.
MtmHierarchyMap	An MtmSubDimensionMap for an MdmHierarchy.
MtmLevelHierarchyMap	An MtmHierarchyMap for an MdmLevelHierarchy, which can be either solved or unsolved.
MtmLevelMap	An MtmSubDimensionMap for an MdmLevel.
MtmLiteralExpression	An MtmValueExpression based on a text string that evaluates to a valid SQL expression.
MtmMeasureMap	An MtmSourceMap for an MdmMeasure.
MtmNoAggregationStep	An MtmAggregationStep that specifies that Oracle OLAP does not aggregate the leaf-level measure data to the higher levels of the hierarchy of a dimension of the MtmAggregationStep.
MtmObject	An object that describes the underlying SQL tables and expressions on which MDM metadata objects are based and records the mapping between the metadata and the underlying SQL structures.
MtmObjectFactory	Creates MtmAggregationStep objects that you can use to specify the SQL function and other aspects of aggregating measure data from the leaf level to higher levels of a hierarchy of an MtmUnsolvedCube.
MtmPartitionedCube	An MtmCube that has one or more MtmBaseCube objects, each of which holds information about one of the hierarchy combinations that are possible for the MtmPartitionedCube.
MtmPrimaryDimensionMap	An MtmDimensionMap for an MdmPrimaryDimension.
MtmRDBMSColumnExpression	An MtmValueExpression that is based on a single column in a relational table or view.
MtmRdbmsTableOrView	An MtmTableOrView that represents a table or view that is based on relational data, and not on analytic workspace data.
MtmSelectStatement	An MtmTabularSource that represents a logical table based on a SQL SELECT statement.
MtmSimpleAggregationStep	An MtmAggregationStep that specifies a SQL function and a weighting factor to apply to the calculation of the measure values for the node levels of the hierarchies of the dimensions of this MtmAggregationStep.
MtmSolvedCube	An MtmBaseCube for which both leaf-level and aggregate data is available directly from a relational table or view.
MtmSolvedCubeDimensionality	An MtmCubeDimensionality object for one hierarchy in a solved MtmBaseCube.
MtmSolvedETCubeDimensionality	An MtmSolvedCubeDimensionality object for one hierarchy in a solved MtmBaseCube whose fact table includes both detail (leaf) data and aggregate data for the associated measures.
MtmSolvedGroupingSetCubeDimensionality	An MtmSolvedLevelBasedCubeDimensionality for one hierarchy in an MtmBaseCube whose fact table is structured in Grouping Set aggregation form.
MtmSolvedLevelBasedCubeDimensionality	An MtmSolvedCubeDimensionality object for one hierarchy in a solved MtmBaseCube whose fact table includes only detail (leaf) data for the associated measures.
MtmSolvedLevelHierarchyMap	An MtmLevelHierarchyMap for a solved MdmLevelHierarchy.
MtmSolvedRollupCubeDimensionality	An MtmSolvedLevelBasedCubeDimensionality for one hierarchy in an MtmBaseCube whose fact table is structured in Rollup aggregation form.
MtmSolveSpecification	An MtmObject that specifies how to solve an MtmUnsolvedCube, that is, which SQL function to apply when calculating the measure data for the node elements of the dimensions of the cube, the order in which to process the dimensions, and other aspects of the calculations.
MtmSourceMap	An MtmObject that maps the relationship between an MdmSource and the underlying SQL tables and expressions on which the MdmSource is based.
MtmStoredAttributeMap	An MtmAttributeMap for an MdmAttribute whose values are explicitly stored in a particular column or columns of a dimension table.
MtmSubDimensionMap	An MtmDimensionMap for an MdmSubDimension.
MtmTableOrView	An MtmTabularSource that represents a logical table that is based on an existing table or view in the data store.
MtmTabularSource	An MtmObject that represents a logical table based on an existing table or view, a SELECT statement, or the join of two tables.
MtmUnsolvedCube	An MtmBaseCube for which only leaf-level data is available directly from a relational table or view, and for which aggregate values are supplied by Oracle OLAP.
MtmUnsolvedCubeDimensionality	An MtmCubeDimensionality object for one hierarchy in an unsolved MtmBaseCube.
MtmUnsolvedLevelHierarchyMap	An MtmLevelHierarchyMap for an unsolved MdmLevelHierarchy.
MtmValueExpression	An MtmExpression that represent a single expression, and so it does not have subexpressions.
MtmValueHierarchyMap	An MtmHierarchyMap for an MdmValueHierarchy.
MtmValueLevelHierarchyMap	An MtmValueHierarchyMap that provides access to the MtmSolvedLevelHierarchyMap for an MdmValueHierarchy.
MtmWeightedAverageAggregationStep	An MtmAggregationStep that specifies a weighted average aggregation of the measure values for the node levels of the hierarchies of the dimensions of this MtmAggregationStep.

Exception Summary

MtmInvalidMetadataException

Indicates that the requested operation on an MTM object cannot be performed, most likely because the specified parameters for the method are not valid.

Package oracle.olapi.metadata.mtm Description

Contains classes that map objects in the multidimensional model (MDM) for metadata to the relational tables and views on which those objects are based.