Example: Creating Two Cube Collections

Suppose you want to work with sales data in an analytic model. Create these 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 contains 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 provides a visual representation of these cube collections.