Intermediate/Calculation Cube Collections

Use intermediate/calculation cube collections to organize data cubes and create intermediate calculations in an analytic model. These intermediate values are neither displayed to the end user nor persisted to the database. For this reason, do not map a main record to an intermediate/calculation cube collection. You can view intermediate/calculation cube collections in the Analytic Model Viewer.

Note:

Intermediate/calculation cube collections are optional.

The following table indicates which data cube types are allowed in an intermediate/calculation cube collection.

Data Cube Type	Allowed in Intermediate/Calculation Cube Collection?
Input data cubes	Yes Note: Although input data cubes are allowed in calculation cube collections, their data is not updated. For this reason, input data cubes serve no purpose in intermediate/calculation cube collections.
Calculation data cubes	Yes
Association data cubes	Yes
Virtual data cubes	Yes

See Input Data Cubes.