Technical data

Creating Hierarchies Chapter 9

Data Cube or Dimension to Map Field in Main Record

SOMEDATE dimension SOMEDATE field

Data type: Date

SALES data cube NUM_ SALES field

Data type: Number

PRICE_PER_UNIT data cube PRICE_PER_UNIT field

Data type: Number

8. Select the AGGRDATE record as the aggregate record.

The AGGRDATE database record currently contains no data. T his table describes the fields within

the record:

Field Name Data Ty pe

DEPARTMENT

String

TREE_DATE

String

NUM_SALES

Number

Notice that even though the DEPARTMENT and TREE_DATE fields are of the String data type, none

of the main record’s fields are of this same data type. The DEPARTMENT and TREE_DATE fields are

of the String data type because the hierarchy’s members display strings, not dates or numbers. The

data types of the aggregate record’s fields must match the data types and lengths of the hierarchy’s

aggregate members. However, the data types of the aggregate record’s fields d o not need to match the

data types of the main record’s fields.

Note. If you design a tree’s nodes so that the fields of the nodes are of the same data type as the

fields of the detail members, you can use the same data type for both the dimension’s aggregate

record fields and main record fields.

9. Map dimensions and data cubes to fields in the aggregate record.

This table provides the mappings:

Data Cube or Dimension to Map Field in Aggregate Record

DEPARTMENT dimension DEPARTMENT field

SOMEDATE dimension TREE_DATE field

SALES data cube NUM_ SALES field

10. Use PeopleSoft Tree manager to create two trees.

Note. In the two tables, italicized children represent detail values. Remember, PeopleSoft Analytic

Calculation Engine creates detail members out of the tree’s detail values to establish a dimension’s

parent-child relationships (in a tree, detailvaluescanserveaschildrenandparents).