Technical data

Chapter 10 Creating Rules, Formulas, and User Functions
Note. When %1 or %2 appears in this table, it denotes that the actual error message includes context-specific
information. For example, the Invalid Dimension %1 error message would yield the error Invalid dimension
PRODUCTS in the Output window if a rule referred to a nonexistent PRODUCTS dimension.
Error Message Description
A dimension ar
gument cannot be used here.
An invalid arg
ument was passed to the function. The function
does not take a dimension as an argument. Please check the
number and argument types for the functio n in question.
Analytic mod
el with nam e %1 not found.
The analytic
model was n ot found in the PeopleSoft database.
Please make sure that the model is saved before the validate is
called.
All dimensi
on arguments must be declared before any
expression arguments are declared.
All the dime
nsion arguments m ust be declared before expression
arguments are declared. Dimension arguments are declared
with a prefix of $, and expression arguments are declared with a
prefix of @
. For example:
ARGUMENTS($DIM, @ExprToLookup, @Condition,
@Directio
n := #FORWARD);
All required arguments must be declared before any
optional arguments are declared.
Optional arguments should be placed at the end of the
declaration. If there are two or more option al arguments, place
the most op
tional argument last. For example:
ARGUMENTS($Dim, @ExprToLookup, @Condition,
@Directio
n := #FORWARD);
In this example, @ Direction is an optional argument and is
placed aft
er the non-optional @Condition argument.
Note. Optional arguments should have a default value.
Circular
reference.
See “Circ
ular Reference.”
Comment is not terminated. The comment in a rule was not terminated with the symbols >>.
See C
hapt
er 10, “Creating Rules, Formulas, and User
Functi ons,” Inserti ng a B l ank Line into a Rule, page 130.
Data cube name is not terminated by a single quote. The data cube reference in a rule contained a starting single
quote bu
t was not ter minated with a single quote. Valid syntax
for a data cube reference is either of these:
DATA_CU
BE
’Data Cube’
Duplicate argument name %1. The argument mentioned in the error is a duplicate. Another
argume
nt with the same name is used in the context. Please
check the formula in question.
Copyright © 1988-2007, Oracl e. All rights reserved. 115