Technical data

Creating Cube Collections Chapter 7
Data Cube Ty pe
Allowed in Intermediate/Calculation
Cube Collection?
Association data cubes
See C
hapter 5, “Creating Data Cubes,” Association Data
Cubes, page 33.
Yes
Virtual data cubes
See C
hapter 5, “Creating Data Cubes,” Virtual Data Cu bes,
page 35.
Yes
Presentation Cube Collections
Use presentation cube collections to present data to the end user for the purposes of reporting and forecasting.
For forecasting purposes, end users may also enter data into presentation cube collections. You can only select
a derived/work record as the main record of a presentation cube collection. If you select any other type of
record, you will not be able to select the cube collection on the Analytics tab of the analytic grid.
Note. You must create the derived/work record before selecting it as the main record.
See Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Application Designer, “Creating Record
Definitions,” Creating a New Record.
Use the GetData and SetData methods to transfer data between presentation c ube collections and the
application server.
Th
is table indicates which data cube types are allowed in a presentation cube collection:
Data Cube Ty pe
AllowedinPresentation
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
Association data cubes
See C
hapter 5, “Creating Data Cubes,” Association Data
Cubes, page 33.
Yes
Virtual data cubes
See C
hapter 5, “Creating Data Cubes,” Virtual Data Cu bes,
page 35.
Yes
Example: Creating Two Cube Collections
Suppose you want to work with sales data in an analytic model. Create these cube collections:
56 Copyright © 1988-2007, Oracl e. All rights reserved.