Skip navigation links

oracle.olapi.metadata.deployment
Class AWCubeOrganization

java.lang.Object
oracle.olapi.metadata.BaseMetadataObject
oracle.olapi.metadata.deployment.CubeOrganization
oracle.olapi.metadata.deployment.AWCubeOrganization

All Implemented Interfaces:

MetadataObject

public class AWCubeOrganization

extends CubeOrganization

A CubeOrganization for an analytic workspace. An AWCubeOrganization contains options that affect the data loading, aggregation method, storage, and querying of an MdmCube. You create an AWCubeOrganization with the createAWOrganization method of the MdmCube.

One option controls the creation of materialized views (MVs) for the measures and dimensions that are associated with the cube. MVs can be automatically refreshed, which can be useful in maintaining the analytic workspace. An MV can be used by the database query rewrite system, which can result in significantly enhanced performance of SQL queries. However, a cube that uses MVs has limitations because the cube must meet certain requirements, which are listed in the description of the setMVOption method. Another limitation is that a cube that has MVs can not have a derived measure.

The Oracle Database has systems for refreshing the data associated with an MV and for transparently rewriting a query so that it uses an MV. With the setMVOption method, you can specify whether or not to create an MV and the type of MV to create. The options that specify the creation of an MV determine the structure of the MV and the conditions required for the creation of the MV. For those requirements, see the setMVOption method. If you specify the creation of a MV, then you can use an MVCreationOptions object to set values that affect the actual creation of the MV and that can replace the default values.

For more information on cube partitioning, sparsity types, storage types, and the use of MVs, see Oracle OLAP User's Guide.

Field Summary

static java.lang.String	COMPLETE_REFRESH_MV_OPTION A constant that indicates that Oracle OLAP creates a materialized view that supports a complete refresh operation.
static java.lang.String	COMPRESSED_SPARSE_TYPE A constant that indicates an extremely sparse cube.
static java.lang.String	CREATE_ET_VIEW_OPTION A constant that indicates that Oracle OLAP does create an ET view for the cube.
static java.lang.String	DENSE_SPARSE_TYPE A constant that indicates a dense cube.
static java.lang.String	FAST_REFRESH_MV_OPTION A constant that indicates that Oracle OLAP creates a materialized view that supports a fast refresh operation.
static java.lang.String	FAST_REFRESH_READY_MV_OPTION A constant that indicates that Oracle OLAP determines that the conditions exist that permit the future creation of a materialized view that is capable of a fast refresh.
static java.lang.String	GENERIC_NULL_STORAGE A constant that indicates that Oracle OLAP does not distinguish between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.
static java.lang.String	INDEPENDENT_MEASURE_STORAGE A constant that indicates that Oracle OLAP stores the values of each of the measures of the cube in a separate object.
static java.lang.String	MV_READY_NULL_STORAGE A constant that indicates that Oracle OLAP makes a distinction between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.
static java.lang.String	NONE_ET_VIEW_OPTION A constant that indicates that Oracle OLAP does not create an ET view for the cube.
static java.lang.String	NONE_MV_OPTION A constant that indicates that Oracle OLAP does not a create materialized view for the cube.
static java.lang.String	REWRITE_MV_OPTION A constant that indicates that Oracle OLAP creates a materialized view that is accessible to the database query rewrite system.
static java.lang.String	REWRITE_READY_MV_OPTION A constant that indicates that Oracle OLAP determines that the conditions exist that permit the future creation of an materialized viewt that is accessible to the database query rewrite system.
static java.lang.String	SHARED_MEASURE_STORAGE A constant that indicates that Oracle OLAP stores the values of all of the measures of the cube in the same object.
static java.lang.String	SPARSE_GLOBAL_SPARSE_TYPE A constant that indicates a sparse cube that has partitions and that stores all of the partitioned data in a single object.
static java.lang.String	SPARSE_SPARSE_TYPE A constant that indicates a sparse cube.
static java.lang.String[]	VALID_ET_VIEW_OPTIONS A constant that has the valid values for the ET view options.
static java.lang.String[]	VALID_MEASURE_STORAGE_TYPES A constant that has the valid values for the types of measure storage.
static java.lang.String[]	VALID_MV_OPTIONS A constant that has the valid values for materialized view options.
static java.lang.String[]	VALID_NULL_STORAGE_TYPES A constant that has the valid values for the types of storage of null values.
static java.lang.String[]	VALID_SPARSE_TYPES A constant that has the valid values for sparsity type.

Method Summary

void	addBuildSpecification(BuildSpecification spec) Adds a BuildSpecification to the list of those associated with this AWCubeOrganization.
MVCreationOptions	findOrCreateMVCreationOptions() Gets the MVCreationOptions that is associated with this AWCubeOrganization or creates one if it does not already exist.
AW	getAW() Gets the analytic workspace that is associated with this AWCubeOrganization.
java.util.List<BuildSpecification>	getBuildSpecifications() Gets the BuildSpecification objects that are associated with this AWCubeOrganization.
java.lang.String	getCubeStorageType() Gets the data type for the shared measure storage.
BuildSpecification	getDefaultBuildSpecification() Gets the default BuildSpecification of this AWCubeOrganization.
java.lang.String	getETViewOption() Gets the ET view option for this AWCubeOrganization, which indicates whether Oracle OLAP creates ET views for the cube.
java.lang.String	getMeasureStorage() Gets the storage type of the measures of the cube that is associated with this AWCubeOrganization.
java.lang.String	getMVOption() Gets the materialized view option for the cube that is associated with this AWCubeOrganization.
java.lang.String	getNullStorage() Gets the null storage type of the measures of the cube that is associated with this AWCubeOrganization.
MdmHierarchyLevel	getPartitionLevel() Gets the dimension level that is the basis for the partitioning of the cube that is associated with this AWCubeOrganization.
SymmetricCondition	getPrecomputeCondition() Gets the SymmetricCondition that specifies the dimension members for which Oracle OLAP computes and stores aggregate measure values during a build or refresh operation.
int	getPrecomputePercent() Gets the percentage of the aggregate measure values for a compressed cube that Oracle OLAP computes and stores during a build or refresh operation.
int	getPrecomputePercentTop() Gets the percentage of the measure values for the top level of a hierarchy of a compressed and partitioned cube that Oracle OLAP computes and stores during a build or refresh operation.
java.lang.String	getSparseType() Gets the sparsity type of the cube that is associated with this AWCubeOrganization.
void	removeBuildSpecification(BuildSpecification spec) Removes a BuildSpecification from the list of those that are associated with this AWCubeOrganization.
void	setAW(AW aw) Sets the AW that the associated MdmCube will be create in
void	setCubeStorageType(java.lang.String exp) Specifies the data type for the shared measure storage for the cube that is associated with this AWCubeOrganization.
void	setDefaultBuildSpecification(BuildSpecification spec) Specifies a BuildSpecification to use as the default for this AWCubeOrganization.
void	setETViewOption(java.lang.String option) Specifies whether Oracle OLAP creates ET (embedded total) views for the cube.
void	setMeasureStorage(java.lang.String type) Specifies the measure storage type for the cube that is associated with this AWCubeOrganization.
void	setMVCreationOptions(MVCreationOptions mvCreationOptions) Specifies an MVCreationOptions to associate with this AWCubeOrganization.
void	setMVOption(java.lang.String option) Specifies the materialized view option for the cube that is associated with this AWCubeOrganization.
void	setNullStorage(java.lang.String type) Specifies the null storage type for the cube that is associated with this AWCubeOrganization.
void	setPartitionLevel(MdmHierarchyLevel level) Specifies the dimension level to use as the basis for the partitioning of the cube that is associated with this AWCubeOrganization.
void	setPrecomputeCondition(SymmetricCondition cond) Specifies a SymmetricCondition that identifies the dimension members for which Oracle OLAP computes and stores aggregate measure values during a build or refresh operation.
void	setPrecomputePercent(int val) Specifies the percentage of the aggregate measure values of a compressed cube for Oracle OLAP to compute and store during a build or refresh operation.
void	setPrecomputePercentTop(int val) Specifies the percentage of the measure values for the top level of a hierarchy for Oracle OLAP to compute and store during a build or refresh operation.
void	setSparseType(java.lang.String type) Specifies the sparsity type for the cube that is associated with this AWCubeOrganization.

Methods inherited from class oracle.olapi.metadata.deployment.CubeOrganization

addSparseDimension, getCube, getSparseDimensions, removeSparseDimension

Methods inherited from class oracle.olapi.metadata.BaseMetadataObject

getID, getOwner

Methods inherited from class java.lang.Object

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

Field Detail

DENSE_SPARSE_TYPE

public static final java.lang.String DENSE_SPARSE_TYPE

A constant that indicates a dense cube.

See Also:

Constant Field Values

COMPRESSED_SPARSE_TYPE

public static final java.lang.String COMPRESSED_SPARSE_TYPE

A constant that indicates an extremely sparse cube.

See Also:

Constant Field Values

SPARSE_SPARSE_TYPE

public static final java.lang.String SPARSE_SPARSE_TYPE

A constant that indicates a sparse cube.

See Also:

Constant Field Values

SPARSE_GLOBAL_SPARSE_TYPE

public static final java.lang.String SPARSE_GLOBAL_SPARSE_TYPE

A constant that indicates a sparse cube that has partitions and that stores all of the partitioned data in a single object.

See Also:

Constant Field Values

VALID_SPARSE_TYPES

public static final java.lang.String[] VALID_SPARSE_TYPES

A constant that has the valid values for sparsity type.

NONE_MV_OPTION

public static final java.lang.String NONE_MV_OPTION

A constant that indicates that Oracle OLAP does not a create materialized view for the cube.

See Also:

Constant Field Values

COMPLETE_REFRESH_MV_OPTION

public static final java.lang.String COMPLETE_REFRESH_MV_OPTION

A constant that indicates that Oracle OLAP creates a materialized view that supports a complete refresh operation.

See Also:

Constant Field Values

FAST_REFRESH_MV_OPTION

public static final java.lang.String FAST_REFRESH_MV_OPTION

A constant that indicates that Oracle OLAP creates a materialized view that supports a fast refresh operation.

See Also:

Constant Field Values

FAST_REFRESH_READY_MV_OPTION

public static final java.lang.String FAST_REFRESH_READY_MV_OPTION

A constant that indicates that Oracle OLAP determines that the conditions exist that permit the future creation of a materialized view that is capable of a fast refresh.

See Also:

Constant Field Values

REWRITE_MV_OPTION

public static final java.lang.String REWRITE_MV_OPTION

A constant that indicates that Oracle OLAP creates a materialized view that is accessible to the database query rewrite system.

See Also:

Constant Field Values

REWRITE_READY_MV_OPTION

public static final java.lang.String REWRITE_READY_MV_OPTION

A constant that indicates that Oracle OLAP determines that the conditions exist that permit the future creation of an materialized viewt that is accessible to the database query rewrite system.

See Also:

Constant Field Values

VALID_MV_OPTIONS

public static final java.lang.String[] VALID_MV_OPTIONS

A constant that has the valid values for materialized view options.

SHARED_MEASURE_STORAGE

public static final java.lang.String SHARED_MEASURE_STORAGE

A constant that indicates that Oracle OLAP stores the values of all of the measures of the cube in the same object.

See Also:

Constant Field Values

INDEPENDENT_MEASURE_STORAGE

public static final java.lang.String INDEPENDENT_MEASURE_STORAGE

A constant that indicates that Oracle OLAP stores the values of each of the measures of the cube in a separate object.

See Also:

Constant Field Values

VALID_MEASURE_STORAGE_TYPES

public static final java.lang.String[] VALID_MEASURE_STORAGE_TYPES

A constant that has the valid values for the types of measure storage.

GENERIC_NULL_STORAGE

public static final java.lang.String GENERIC_NULL_STORAGE

A constant that indicates that Oracle OLAP does not distinguish between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.

See Also:

Constant Field Values

MV_READY_NULL_STORAGE

public static final java.lang.String MV_READY_NULL_STORAGE

A constant that indicates that Oracle OLAP makes a distinction between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.

See Also:

Constant Field Values

VALID_NULL_STORAGE_TYPES

public static final java.lang.String[] VALID_NULL_STORAGE_TYPES

A constant that has the valid values for the types of storage of null values.

NONE_ET_VIEW_OPTION

public static final java.lang.String NONE_ET_VIEW_OPTION

A constant that indicates that Oracle OLAP does not create an ET view for the cube.

See Also:

Constant Field Values

CREATE_ET_VIEW_OPTION

public static final java.lang.String CREATE_ET_VIEW_OPTION

A constant that indicates that Oracle OLAP does create an ET view for the cube.

See Also:

Constant Field Values

VALID_ET_VIEW_OPTIONS

public static final java.lang.String[] VALID_ET_VIEW_OPTIONS

A constant that has the valid values for the ET view options.

Method Detail

findOrCreateMVCreationOptions

public MVCreationOptions findOrCreateMVCreationOptions()

Gets the MVCreationOptions that is associated with this AWCubeOrganization or creates one if it does not already exist. The MVCreationOptions specifies options that Oracle OLAP uses when it creates a materialized view for the MdmCube that is associated with this AWCubeOrganization.

With the setMVOptions method, you can specify the type of materialized view to create or you can specify not to create one for the cube. If you specify creating a type of materialized view, you can use an MVCreationOptions object to specify values that Oracle OLAP uses when it actually creates the MV.

Returns:

An MVCreationOptions that contains options that affect the creation of a materialized view.

setAW

public final void setAW(AW aw)

Sets the AW that the associated MdmCube will be create in

getPartitionLevel

public final MdmHierarchyLevel getPartitionLevel()

Gets the dimension level that is the basis for the partitioning of the cube that is associated with this AWCubeOrganization.

Returns:

The MdmHierarchyLevel that is the basis for the partitioning the cube associated with this AWCubeOrganization.

setPartitionLevel

public final void setPartitionLevel(MdmHierarchyLevel level)

Specifies the dimension level to use as the basis for the partitioning of the cube that is associated with this AWCubeOrganization.

Parameters:

level - The MdmHierarchyLevel to use as the basis for partitioning the cube associated with this AWCubeOrganization.

getSparseType

public final java.lang.String getSparseType()

Gets the sparsity type of the cube that is associated with this AWCubeOrganization.

Returns:

A String that contains the sparsity type of the cube.

setSparseType

public final void setSparseType(java.lang.String type)

Specifies the sparsity type for the cube that is associated with this AWCubeOrganization. You can specify a sparsity type for all of the dimensions of the cube by using this method or you can specify individual dimensions as sparse by using the addSparseDimension method.

The following table lists the constants that represent the valid values for the type parameter.

Constant	Description
DENSE_SPARSE_TYPE	Specifies that the data in the cube is dense, which means that data exists for 80% or more of the measure values of the cube.
SPARSE_SPARSE_TYPE	Specifies that the data in the cube is sparse, which means that no data exists for more than 20% of the measure values of the cube.
COMPRESSED_SPARSE_TYPE	Specifies that the data in the cube is extremely sparse, which means that the cube has seven or more dimensions, some of which have hundreds of thousands of members, and some dimension hierarchies have many levels in which a parent has only one child.
SPARSE_GLOBAL_SPARSE_TYPE	For a sparse cube that is partitioned, indicates the use of a single object to store data for all of the partitions. This type exists for backward compatibility. Do not specify this type for a new cube.

Parameters:

type - A String that contains a sparsity type for the cube.

getMVOption

public final java.lang.String getMVOption()

Gets the materialized view option for the cube that is associated with this AWCubeOrganization.

Returns:

A String that contains the materialized view option for the cube.

setMVOption

public final void setMVOption(java.lang.String option)

Specifies the materialized view option for the cube that is associated with this AWCubeOrganization. This option determines the structure of the materialized view. The different types of materialized view have different requirements.

To specify an MV option of COMPLETE_REFRESH_MV_OPTION, the cube must meet the following requirements.

• The null storage option must be MV_READY_NULL_STORAGE, which is the default if the MV option is other than NONE_MV_OPTION.
• The sparsity type must be COMPRESSED_SPARSE_TYPE.
• The cube must have at least one dimension.
• The MV option of all of the dimensions of the cube must be COMPLETE_REFRESH_MV_OPTION.

To specify an MV option of FAST_REFRESH_MV_OPTION or FAST_REFRESH_READY_MV_OPTION, the cube must meet the following requirements in addition to the requirements for the COMPLETE_REFRESH_MV_OPTION.

• The MV must not require aggregation or dimension joins.
• The measures and dimensions must be mapped to a physical fact table and not a view.
• The dimension members must have unique keys. The fact table must contain a primary key and the MV must include all columns of that primary key. The primary key constraints must be enabled and validated.

To specify an MV option of REWRITE_MV_OPTION or REWRITE_READY_MV_OPTION, the cube must meet the following requirements in addition to the requirements for the COMPLETE_REFRESH_MV_OPTION.

• The ConsistentSolveSpecification for the cube specify a single aggregation method over all of the hierarchies of all of the dimensions.
• The aggregation method must be SUM, MAX, or MIN.
• The leaf-level data in the analytic workspace must match the leaf-level data in the relational master tables; if it does not match, then a refresh must occur that uses the same aggregation method as the ConsistentSolveSpecification.
• No dimension of the cube can have a value hierarchy.
• No dimension can have a skip level or ragged hierarchy.
• The hierarchy consistency rule of all of the dimensions must be HIERARCHY_RULE_STAR_CONSISTENT.

The following table lists the constants that represent the valid values for the option parameter.

Constant	Description
NONE_MV_OPTION	Specifies that Oracle OLAP does not create a materialized view for the cube.
COMPLETE_REFRESH_MV_OPTION	Specifies that Oracle OLAP creates a materialized view for the cube.
FAST_REFRESH_MV_OPTION	Specifies that Oracle OLAP creates a materialized view that supports an incremental refresh.
FAST_REFRESH_READY_MV_OPTION	Specifies that Oracle OLAP determines that the conditions exist for the creation of a materialized view that is capable of a fast refresh but does not actually create the MV.
REWRITE_MV_OPTION	Specifies that Oracle OLAP creates a materialized view that the database query rewrite system can use.
REWRITE_READY_MV_OPTION	Specifies that Oracle OLAP determines that the conditions exist for the creation of a rewrite materialized view but does not actually create the MV.

If you specify the creation of a materialized view with this method, then you can use an MVCreationOptions object to specify options that Oracle OLAP uses when it actually creates the MV.

Parameters:

option - A String that contains a materialized view option for the cube.

getMeasureStorage

public final java.lang.String getMeasureStorage()

Gets the storage type of the measures of the cube that is associated with this AWCubeOrganization.

Returns:

A String that contains the measure storage type of the cube.

setMeasureStorage

public final void setMeasureStorage(java.lang.String type)

Specifies the measure storage type for the cube that is associated with this AWCubeOrganization. The following table lists the constants that represent the valid values for the type parameter.

Constant	Description
INDEPENDENT_MEASURE_STORAGE	Specifies that Oracle OLAP stores the values of each of the measures of the cube in separate objects.
SHARED_MEASURE_STORAGE	Specifies that Oracle OLAP stores the values of all of the measures of the cube in the same object. Specify the shared measure storage type only if all of the measures have the same data type. If you use this type of storage, then specify the data type with the setCubeStorageType method.

Parameters:

type - A String that contains a measure storage type for the cube.

getNullStorage

public final java.lang.String getNullStorage()

Gets the null storage type of the measures of the cube that is associated with this AWCubeOrganization.

Returns:

A String that contains the null storage type of the cube.

setNullStorage

public final void setNullStorage(java.lang.String type)

Specifies the null storage type for the cube that is associated with this AWCubeOrganization.

The following table lists the constants that represent the valid values for the type parameter.

Constant	Description
GENERIC_NULL_STORAGE	Specifies that Oracle OLAP does not distinguish between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.
MV_READY_NULL_STORAGE	Specifies that Oracle OLAP makes a distinction between a true NA value and an NA value that exists because Oracle OLAP has not yet calculated the value.

Parameters:

type - A String that contains a null storage type for the cube.

getCubeStorageType

public final java.lang.String getCubeStorageType()

Gets the data type for the shared measure storage.

Returns:

A String that contains data type for the shared measure storage.

setCubeStorageType

public final void setCubeStorageType(java.lang.String exp)

Specifies the data type for the shared measure storage for the cube that is associated with this AWCubeOrganization. If the measure storage type is SHARED_MEASURE_STORAGE, then use this method to specify the data type of the measure values.

Parameters:

exp - A String that contains an expression that resolves to the data type shared by all of the measures of the cube.

See Also:

setMeasureStorage(java.lang.String)

getPrecomputeCondition

public SymmetricCondition getPrecomputeCondition()

Gets the SymmetricCondition that specifies the dimension members for which Oracle OLAP computes and stores aggregate measure values during a build or refresh operation.

Returns:

The SymmetricCondition that specifies the dimension members for which Oracle OLAP precomputes measure values.

setPrecomputeCondition

public void setPrecomputeCondition(SymmetricCondition cond)

Specifies a SymmetricCondition that identifies the dimension members for which Oracle OLAP computes and stores aggregate measure values during a build or refresh operation. This precompute condition applies to any type of cube. If you specify a precompute condition, do not also specify precompute percent values.

Parameters:

cond - The SymmetricCondition that specifies the dimension members for which Oracle OLAP precomputes measure values.

getPrecomputePercent

public final int getPrecomputePercent()

Gets the percentage of the aggregate measure values for a compressed cube that Oracle OLAP computes and stores during a build or refresh operation.

Returns:

An integer that represents the percentage of the measure values that Oracle OLAP precomputes.

setPrecomputePercent

public final void setPrecomputePercent(int val)

Specifies the percentage of the aggregate measure values of a compressed cube for Oracle OLAP to compute and store during a build or refresh operation.

Parameters:

val - An integer that represents the percentage of the measure values for Oracle OLAP to precompute. The value can be 0 (zero) or greater.

getPrecomputePercentTop

public final int getPrecomputePercentTop()

Gets the percentage of the measure values for the top level of a hierarchy of a compressed and partitioned cube that Oracle OLAP computes and stores during a build or refresh operation.

Returns:

An integer that represents the percentage of the measure values for the top level of a hierarchy of a compressed and partitioned cube that Oracle OLAP precomputes.

setPrecomputePercentTop

public final void setPrecomputePercentTop(int val)

Specifies the percentage of the measure values for the top level of a hierarchy for Oracle OLAP to compute and store during a build or refresh operation.

Parameters:

val - An integer, which must be greater than 0 (zero), that represents the percentage of the measure values for the top level of a hierarchy of a compressed and partitioned cube for Oracle OLAP to precompute.

getAW

public final AW getAW()

Gets the analytic workspace that is associated with this AWCubeOrganization.

Returns:

The AW associated with this AWCubeOrganization.

addBuildSpecification

public void addBuildSpecification(BuildSpecification spec)

Adds a BuildSpecification to the list of those associated with this AWCubeOrganization.

Parameters:

spec - The BuildSpecification to add to this AWCubeOrganization.

removeBuildSpecification

public void removeBuildSpecification(BuildSpecification spec)

Removes a BuildSpecification from the list of those that are associated with this AWCubeOrganization.

Parameters:

spec - The BuildSpecification to remove from this AWCubeOrganization.

getBuildSpecifications

public java.util.List<BuildSpecification> getBuildSpecifications()

Gets the BuildSpecification objects that are associated with this AWCubeOrganization.

Returns:

A List of the BuildSpecification objects associated with this AWCubeOrganization.

getDefaultBuildSpecification

public BuildSpecification getDefaultBuildSpecification()

Gets the default BuildSpecification of this AWCubeOrganization.

Returns:

The default BuildSpecification for this AWCubeOrganization.

setDefaultBuildSpecification

public void setDefaultBuildSpecification(BuildSpecification spec)

Specifies a BuildSpecification to use as the default for this AWCubeOrganization.

Parameters:

spec - The BuildSpecification to use as the default for this AWCubeOrganization.

getETViewOption

public final java.lang.String getETViewOption()

Gets the ET view option for this AWCubeOrganization, which indicates whether Oracle OLAP creates ET views for the cube.

Returns:

A String that contains the ET view option for this AWCubeOrganization.

setETViewOption

public final void setETViewOption(java.lang.String option)

Specifies whether Oracle OLAP creates ET (embedded total) views for the cube. You can query ET views by using SQL statements. ET views are called OLAP views in Oracle OLAP User's Guide. For information on querying the views with a SQL application, see the user's guide.

The following table lists the constants that represent the valid values for the option parameter.

Constant	Description
CREATE_ET_VIEW_OPTION	Specifies that Oracle OLAP creates ET views for the cube.
NONE_ET_VIEW_OPTION	Specifies that Oracle OLAP does not create ET views for the cube. SQL queries that use the materialized views of the analytic workspace.

Parameters:

option - A String that contains an ET view option for this AWCubeOrganization.

setMVCreationOptions

public final void setMVCreationOptions(MVCreationOptions mvCreationOptions)

Specifies an MVCreationOptions to associate with this AWCubeOrganization. An MVCreationOptions contains options that Oracle OLAP uses when it creates a materialized view (MV) for an analytic workspace cube.

Parameters:

mvCreationOptions - The MVCreationOptions to associate with this AWCubeOrganization.

Skip navigation links