Technical data

Chapter 7 Creating Cube Collections
Data Cube Type
AllowedinRead/Write
Cube Collection?
Input data cubes
See C
hapter 5, “Creating Data Cubes,” Input Data Cubes,
page 32.
Yes
Calculation data cubes
See C
hapter 5, “Creating Data Cubes,” Input Data Cubes,
page 32.
Yes
Note. Initial data values for calculation data cubes are
loaded from the database. Calculated values are written
back to the database.
Association data cubes
See C
hapter 5, “Creating Data Cubes,” A ssociati on Data
Cubes, page 33.
Yes
Virtual data cubes
See C
hapter 5, “Creating Data Cubes,” Virtual Data Cu bes,
page 35.
No
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.
This table indicates which data cube types are allowed in an intermediate/calculation cube collection:
Data Cube Type
AllowedinIntermediate/Calculation
Cube Collection?
Input data cubes
See C
hapter 5, “Creating Data Cubes,” Input Data Cubes,
page 32.
Yes
Note. Although inpu t data cubes are a llowed in
calculation cube collections, th e ir data is n ot updated.
For this reason, input data cubes serve no purpose in
intermediate/calcul ation cube co llect ions.
Calculation data cubes
See C
hapter 5, “Creating Data Cubes,” Input Data Cubes,
page 32.
Yes
Copyright © 1988-2007, Oracl e. All rights reserved. 55