Technical data

Using Built-in Functio ns in Analytic Models Chapter 11
Returns
The arc-cosine
of Data.
Example
The following examples employ the ACOS built-in function:
• ACOS(0.5) returns 1.0471975512 (angle in radians).
• ACOS(0.5) * 180 / PI( ) returns 60 (angle in degrees).
• ACOS(SQRT(2) / 2) returns 0.7853981634 (angle in radians).
• ACOS(SQRT(2) / 2) * 180 / PI( ) returns 45 (angle in degrees).
ARGUMENTS Declaration
Syntax
ARGUMENTS(argument1), argument2... argumentN
Description
The ARGUMENTS
declaration passes values to functions within a user function.
Use the following guidelines to make user functions more powerful by giving them arguments:
Enter an ARGUMENTS declaration at the beginning of the rule, followed by an opening parenthesis.
Enter any dime
nsion arguments next, separated by commas. A dimension argument always begins with a
$,asin$Dim.U
nlike the built-in functions, which never have more than one dimension argument, user
functions can
have multiple dimension arguments.
Include any expression arguments next, separated by commas. An expression argument always begins with a
@,asin@Expr. To give the argument a default value, follow it with := and any valid expression.
Note. All optional arguments (that is, those with default values) must appear after all required arguments.
Enter a closin
g parenthesis and a semicolon.
Example
ARGUMENTS($D
im, @ExprToLookup, @Condition, @Direction := #FORWARD);
FORMEMBERS($Dim, @Direction,
IF(@Condition, RETURN(@ExprToLookup))
);
RETURN(0)
ASC
Syntax
ASC(Text)
140 Copyright © 1988-2007, Oracl e. All rights reserved.