Technical data

Index
GROUPMAX function 160
GROUPMIN function 161
GROUPSUM funct
ion 162
GROW function 163
H
hierarchies
creating 71
default 71
example of creating with aggregate and
detail members
109
relationship to PeopleS oft trees 71
understanding 71
hierarchy root m
embers 74
historical trends, analyzing 190
I
IF function 164
implicit tuples
66
import maps, converting 261
importDirections.txt 246
INC function 164
INCDATE function 165
indirect causes, understanding 44
indirect circul
ar formulas,
understanding 134
indirect circular references 118
indirect effects
displaying 45
understanding 44
input data cubes
and formulas 39
creating 38
understanding 32
INPUT function 165
inputs
displaying 45
understanding 44
viewing with Analytic Model
Viewer 229
INSUBTREE function 166
interactive reports 211
INTERCEPT functio
n167
intermediate/calculation cube collections
data cube types allowed in 55
understanding 55
Internal error. Uncompiled user function
reference made in the formula. (error
message) 116
Invalid constant (error messa ge) 116
Invalid dimension %1 (error
message) 116
Invalid function %1 (error message) 116
Invalid member reference (error
message) 117
Invalid member reference syntax. Valid
syntax is [DIMENSION:Member]. (error
message) 117
Invalid number (error message) 117
invisible fields 216
IRR function 16
7
ISINPUT function 166
iterations
specifying the
maximum number
of 137
understanding 135
K
key fields, sug
gestions for mapping 60
L
label properties, setting 217
Layout tab, moving columns on 224
leaf members
creating 76
understanding 74
leaf ranges, re
lationship to new
members 78
LEFT function 168
LEN function 16
9
levels 76
LN function 168
Load method 8
log fence
PeopleSoft Analytic Calculation
Engine 243
log file 264
logical operators 123
LOWER function 1
69
M
main records, mapping to c ube
collections 58
MATCH function 1
69
mathematical operators 125
MAX function 170
MBR2TEXT functi
on
referencing b lank members with 127
Copyright © 1988-2007, Oracl e. All rights reserved. 297