Technical data

Chapter 7 Creating Cube Collections

• SALES_RW read/write cube collection.

On the General tab, map this cube collection to the SALES main record to receive and persist raw sales data.

This record must exist in the analytic type definition. This cube collection c ontains these data cubes:

- UNIT_COST data cube.

Map this data cube to the UNIT_COST field.

- UNIT_SOLD data cube.

Map this data cube to the UNIT_SOLD field.

• SALES_PRES presentation cube collection.

Map this cube collection to the SALES_WK derived/work record to calculate sales data and display the

calculated data to the end user at runtime. This cube collection contains the TOTAL_SALES data cube,

which is mapped to the TOTAL_SALES_WK field. The TOTAL_SALES data cube contains this formula:

UNIT_COST * UNIT_SOLD

This diagram p

rovides a visual representation of these cube collections:

UNIT_COST

UNIT_SOLD

TOTAL_SALES

SALES_IN Cube Collection SALES_WK Cube Collection

(no formula)

Formula:

UNIT_COST

UNIT_SOLD

SALES_IN and SALES_WK cube collections

Creating Cube Collections

To create a cube collection:

1. Select Pa

rt,New,CubeCollection.

The Edit P

art Name dialog box appears.

2. Enter the

name of the cube collection.

3. Click OK.

You c an no

w drag and drop the desired data cubes and dimensions into the cube collection.