Databases Reference
In-Depth Information
Example:
@MEDIAN(SKIPBOTH,@RANGE(Sales,@CHILDREN(Product)));
This example returns the median (middle value) of the
Product
dimension
based on the value of
Sales
.
Date and Time
The date and time category only has one function, and it is new for Essbase
version 9.x. That function is called
@TODATE()
.
@TODATE()
: Coverts a date string into numbers of seconds elapsed
since midnight, January 1, 1970.
Syntax:
@TODATE (FormatString, date)
Format of String can either be "mm-dd-yyyy" or "dd-mm-yyyy".
Example:
@TODATE("mm-dd-yyyy","12-12-2008");
Miscellaneous
Finally, we have a few miscellaneous calculation functions which do not belong in
any of the other categories. There are only three miscellaneous functions which are
@CALCMODE()
,
@CONCATENATION()
, and
@SUBSTRING()
.
•
@CALCMODE()
: This function tells the calc script how the formulas need to be
calculated. The
@CALCMODE()
function can tell Essbase to toggle between two
different calculation modes. First, you can toggle between
CELL
and
BLOCK
modes, then, in a second statement, you can toggle between formulas being
calculated in
TOPDOWN
or
BOTTOMUP
modes.
What a handy function!
Syntax:
@CALCMODE(CELL | BLOCK | TOPDOWN | BOTTOMUP);
Example:
@CALCMODE(CELL);
@CALCMODE(BOTTOMUP);
The two statements above will place Essbase in the CELL mode for
calculating and also calculate member formulas from the bottom up.
