Technical data
Index
understanding 171
MEDIAN function 171
Member format 4
1
MEMBER function 172
members,Seedimension members
menu bar 21, 22
metadata
changing using PeopleCode 9
viewing with Ana
lytic Model
Viewer 229
Metadata classes 9
MID function 173
MIN function 173
MOD function 174
Model Viewer,Se
e Analytic Model Viewer
MONTH function 174
Move, Down command 23
Move, Up command 2
3
multiplication (operator) 125
N
#N/A predefined constant 125
names
blank spaces in 28
of total members 48
underscores in 28
viewing for dimensions 43
naming conventions 28
New, Cube Collect
ion c ommand 23
New, Data Cube command 23
New, Dimension command 23
New, Organizer com
mand 23
New, User Function command 23
NEXT function 175
node levels 76
NodeName parameter 74
non-dimensional fields 216
non-key fields, ma
pping 60
nonalphanumeric characters 28
NONE, selecting 80
notes xix
notes bar
understanding 21
using 30
Notes Bar command 23
notes, entering 30
NPER function 176
NPV function 176
NUM2TEXT function 177
Number format 41
NUMMEMBERS function 177
O
operators
comparison 122
execution order of 126
logical 123
mathematical 1
25
OPRID function 177
order of precedence 125
Order tab, movin
g columns on 224
organizers
converting 261
creating 29
entering notes for 30
naming conventions for 28
understanding 2
0
viewing in part browser 25
viewing properties with Analytic Model
Viewer 241
orphan members 75
output window 22
overrides
assigning to trees 84
example of creating 91
understanding 81
understanding order of precedence
in 82
viewing with Anal
ytic Model
Viewer 229
P
PARENT function 179
parent member dat
a, pushing down 143
part browser
changing order of dimensions in 51
in Analytic Model
Viewer 231
in PeopleSoft Application Designer 25
Part menu commands 23
part properties d
ialog box 231
part property editor 21
parts
converting names o
f255
dragging and dropping 25
entering notes for 30
finding 30
naming conventions for 28
understanding 15
Paste Cube Name com
mand 22
298 Copyright © 1988-2007, Oracl e. All rights reserved.