Technical data

Using Built-in Functio ns in Analytic Models Chapter 11
Description
The SQRT functi
on returns the square root of Data.IfthevalueofData is negative, SQRT returns an error
value.
Returns
The square root of Data. If the value of Data is negative, SQRT returns an error value.
Example
These examples employ the SQRT built-in function:
• SQRT(25) retu
rns 5.
• SQRT(2) retur
ns 1.4142135624.
• SQRT(-25) ret
urns an error value.
STDEV
Syntax
STDEV(Dimens
ion, Val u e s , {Type}, {Condition})
Description
The STDEV function returns the s tandard deviation of Va l u e s .IfType is zero or omitted, STDEV calculates
a population standard deviation; otherwise, STDEV calculates a sample standard deviation. If Condition is
omitted, the function uses all Val u e s .IfCondition is included, the function uses only those Va l u e s where
Condition is true.
Example
Suppose that an analytic model contains a data cube called SALES that uses dimensions called PEOPLE and
MONTHS.
Use this form
ula to calculate the standard deviation over time for each person:
STDEV(MONTH
S, SALES, 0)
Use this formula to calculate the standard deviation of sales over 5000 for each month:
STDEV(PEOPL
E, SALES, 0, SALES > 5000)
SYD
Syntax
SYD(Cost, Sa
lvage, Life, Period)
Description
The SYD function returns the depreciation on an asset using the Sum-of-the-Years’-Digits method, an
accelerated depreciation method. The SYD function takes these arguments:
192 Copyright © 1988-2007, Oracl e. All rights reserved.