Technical data

CHAPTER 7

Creating Cube Collections

This chapter provides overviews of cube collections and types of cube collections and discusses how to:

• Create cube collections.

• Define cube collection properties.

Understanding Cube Collections

A cube collection is a collection of related data cubes. You create cube collections to load data from the

database into the analytic model, receive user input, persist data back to the database, and display calculated

data to the end user at runtime.

When the end user loads an analytic instance, PeopleSoft Analytic Calculation Engine loads the data from the

database into the data cubes of the analytic model. These data cubes exist within cube collections. You map

the main record from the database to the cube collection, and the main record’s fields to the data cubes and

dimensions within the cube collection.

After loading an analytic instance, the end user has access to one or more cube collections within the

application. These cube collections—which are displayed in PeopleSoft Pure Internet Architecture pages

with analytic grids—contain the data that end users can view or edit. Yo u create these pages in PeopleSoft

Application Designer.

See C

hapter 1 3, “Creating Analytic Grids,” page 211.

Note. The analytic model may contain cube collections that are not visible to the end user.

For each record you want to work with in the analytic model, you generally create read/write cube collection

to load data into the analytic model, and a presentation cube collection for end user input, reporting and

forecasting. The presentation cube collection calculates the data from the read/write cube collection’s data

cubes and displays the c alculated data to the end user. Presentation cube collections may also receive end

user input.

You can also create an intermediate/calculation cube collection to organize data cubes and create calculations

whose results are not displayed to the end user.

In the General tab of the cube collection’s properties, you map the main record, which stores the fact data that

you want to load and persist. For a read/write cube collection, select one of the records that you selected in the

analytic type definition that corresponds to the analytic model. For a presentation cube collection, select a

derived/work record from the list of available recor ds.

Note. Do n

ot map intermediate/calculation cube collections to any records.