Technical data

Contents
Mapping a Cube Collection to Main and Aggregate Records.................................................58
Mapping Data Cubes and Dimensions to Fields...............................................................59
Defining Addi
tional Cube Collection Dimension Properties........................ ...................
........60
Chapter 8
Creating Explicit Dimension Sets................................................................. ........63
Understanding Explicit Dimension Sets ........................... .. ........... ............................. ........63
Understandi
ng Implicit Tuples and Explicit Tuples.........................................................
........66
Defining Explicit Dimension Sets............................................................................. ........67
Viewing Explicit Dimension Set Properties......................................................................67
Editing or A
dding New Explicit Dimension Sets........................................................
........68
Chapter 9
Creating Hierarchies................................................................................. ........71
Understanding the Relationship of PeopleSoft Trees to Analytic Models............................... ........71
Purpose o
f PeopleSoft Trees and Analytic Model Hierarchies.......................................
........71
PeopleCode Usage with PeopleSoft Trees and Analytic Models.. ... ..... ... ... ... ... ..... ... ..............72
Understanding BAM Model Total Members................................................................. ........73
Underst
anding Dimension Members.........................................................................
........73
Types of Dimension Members....................................................................................73
Purpose of Node Levels in Creating Hierarchies...............................................................76
Creatio
n of New Members at Runtime...................................................................
........78
Understanding the Calculation of Aggregate Data......................................................... ........78
Dimension Order Impact on Calculation.........................................................................78
Logic f
or Determining the Order of Members...........................................................
........78
Understanding the Persistence of Aggregate Data.................................. ............. ......... ........79
Persistence of Aggregate and Detail Data......................................................................79
Aggre
gate Record Properties.............................................................................
........80
Pushed Down Data.................................................................................................80
Data Type Considerations.........................................................................................81
Work
ing with Overrides........................................................................................
........81
Understanding Default Aggregation..............................................................................81
Understanding Override Order of Precedence.................................................................82
Unde
rstanding the PSACETREEOVRD Subrecord....................................................
........84
Example: Using Default Aggregation.... ........................................................................84
Example: Creating Overrides.....................................................................................91
Exa
mple: Creating a Hierarchy with Mixed Aggregate and Detail Members.. ... ....... ... ... ... ..
.......109
viii Copyright © 1988-2007, Oracl e. All rights reserved.