Technical data

Creating Cube Collections Chapter 7

Note. In the analytic type definition, you do not have to select the derived/work records that you want to

map to presentation cube collections. However the analytic type definition must include all derived/work

records that are mapped to cube collections on which you use the NetChanges parameter of the GetData

CubeCollection class method.

Note. When a cube collection is mapped to either a Writable-only record or a record with the Readable and

Writable attributes, all data cubes in the cube collection should share the same set of dimensions.

If desired, you can also use the General tab to map the cube collection to an aggregate record to persist the

cube collection’s aggregate data.

After you map the cube collection to the main and aggregate records, use the Field Map tab to map the cube

collection’s data cubes and dimensions to the fields of the main and aggregate records.

Note. You can map a data cube or dimension to one field within one record. Once you have mapped a data

cube or dimension to a particular record field, you c annot use that record field in another mapping. You can,

however, reuse the same field if that field is from a different record.

Use the Dimensions tab to define these additional attributes for the dimensions in the cube collection:

• How much aggregate data is saved.

•Sortorder.

• Filter user function.

TypesofCubeCollections

You create three different types of cube collections in an analytic model. This section p rovides overviews of:

• Read/write c

ube collections.

• Intermediat

e/calculation cube collections.

Note. Intermediate/calculation cube collections are optional.

• Presentation cube collections.

Read/Write Cube Collections

Use read/write cube collections to load data from the database, receive user input, and persist data back to the

database. For the main record, you can select any record type except derived/work records.

Note. The analytic type that you use with the analytic model must contain the records that you map

to read/write cube collections.

See Chapter 12, “Understanding the Relationship of Analytic Types to Analytic Models,” page 201.

This table indicates w hich data cube types are allowed in a read/write cube collection: