Technical data

Creating Data Cubes Chapter 5
Understanding the Relationship Between Field Definition
Attributes an
dDataCubeFormats
Because data cubes receive data from fields, it is importa nt to correctly set both the attributes of field
definitions and the formats of data cubes to ensure compatibility. The following table describes compatibilities
between field definition attributes and data cube formats. Cells marked Yes indicate compatibility. Cells
marked No indicate incompatibility. Cells marked Warn indicate potential compatibility and yield a warning
during design time. During runtime, the analytic calculation engine generates an error if it determines that
the mapping is not compatible.
Field Definition
Attributes
Data Cube Format:
Number
Data Cube Format:
Date
Data Cube
Format:
Member
Data Cube
Format: Tex t
Char
Warn Warn Yes Yes
Number
Yes No Yes Yes
Signed Number
Yes No Yes Yes
Date No Yes Yes Yes
Time
No No No No
Date Time
No Warn
Note. When a
date-formatted data cube
is mapped to a field with
aDateTimeattribute,
time-specific data is
truncated in the data cube
data.
Yes Yes
Image No No No No
Long Char
No No No No
See Also
Chapter 5, “Creating Data Cubes,” Defining General Data Cube Properties, page 40
Enterprise PeopleTools 8.49 PeopleBook: PeopleSoft Application Designer, “Creating Field Definitions”
Creating Input D ata Cubes
To create an input data cube:
1. Select Part, New, Data Cube.
The Edit Part Name dialog box appears.
38 Copyright © 1988-2007, Oracl e. All rights reserved.