Technical data

Index
inserting for dimension m embers 129
inserting for dimensions 129
of blank member
s127
of data cubes 126
of dimension members 126
related documen
tation xvi
REPLACE function 186
reporting, using cube collections for 56
RETURN function
186
#REVERSE predefined constant 125
RIGHT function 186
right-click men
us 23
ROOT, selecting 80
ROUND function 187
rule bar
display behavior of 114
understanding 21
Rule Bar command 2
3
rules 112
See Also formulas; user functions
converting code i
n 256
entering member references into 129
inserting blank lines into 130
inserting built-i
n functions into 128
inserting comments into 130
inserting user functions into 128
performing except
ions to 130
referring to data cubes in 129
referring to dimension members in 129
referring to dimen
sions in 129
understanding elements of 120
understanding error messages for 114
using predefined c
onstants in 123
using values in 128
S
Scenario Managed record attribute 207
security 12
SELF function 187
Servers page 8
SET function 188
SetData method 56
Show Circular System command 25
SIN function 188
slices, referring to 130
SLN function 189
SLOPE function 189
SmartViews,Seeinteractive reports
sorting
with Analytic Model Viewer 235
with PeopleSoft Application
Designer 61
spaces in names 28
SQRT function 191
status bar 22
STDEV function 192
strictly enforced method 76
sub-organizer
s20
subtraction (operator) 125
suggestions, submitting xx
Summary page 8
SYD function 192
synchronization order, setting 208
Syntax error (er
ror message) 117
syntax errors, understanding 119
T
table views, converting 260
TAN function 193
terms 265
Text format 42
Text not terminat
ed by quote (error
message) 117
TEXT2MBR function
referencing blan
k members with 127
understanding 194
TEXT2NUM function 194
The ARGUMENTS dec
laration must
appear at the beginning of a user function
(error message) 117
The following err
or occurred while
preprocessing user function %1 – %2
(error message) 116
This argument ha
s not been declared
in the ARGUMENTS section (error
message) 117
THIS function 19
4
THISCUBE function 195
tool bar 21
Tools menu comma
nds 24
Total Member Name field 49
total m embers,SeeBAM total members
tree discard lev
el 77
trees,SeePeopleSoft trees
#TRUE predefined constant 125
TRUNC function 19
6
truth functions 122
typographical conventions xviii
300 Copyright © 1988-2007, Oracl e. All rights reserved.