Technical data

CHAPTER 5

Creating Data Cubes

This chapter provides overviews of data cubes and the relationship between field definition attributes and data cube

formats and discusses how to:

• Create input data cubes.

• Create calculation data cubes.

• Create association data cubes.

• Create virtual data cubes.

• Define data cube properties.

• Audit data cubes at design time.

Understanding Data Cubes

This section provides overviews of:

• Definition of a data cube.

• Input data cubes.

• Calculation data cubes.

• Association data cubes.

• Virtual data cubes.

Definition of a Data Cube

A data cube is a container for one kind of data that you use in cube collections.

You can place the same data cube in more than one cube collection. For example, you can place

the EMPLOYEE_EXPENSE data cube in both an EMPLOYEE_ANALYSIS cube collection and an

INCOME_STATEMENT cube collection. To populate the data cubes w ith data from the database, you map

fields to the data cubes within the c ube collection’s properties.

See C

hapter 7, “Creating Cu be Collections,” Mapping Data Cubes and Dimensions to Fields, page 59.

Within PeopleSoft Pure Internet Architecture p ages with analytic grids, end users view cube collections and

drag and drop data cubes to view their relationships to other data cubes.

You create four different types of data cubes that you use w ithin an analytic model:

• Input data cubes.

• Calculation data cubes.