A list of OBIEE functions

Avg     Aggregate
AvgDistinct     Aggregate
BottomN     Aggregate
Count     Aggregate
CountDistinct     Aggregate
CountStar     Aggregate
First     Aggregate
GroupByColumn     Aggregate
GroupByLevel     Aggregate
Last     Aggregate
Max     Aggregate
Median     Aggregate
Min     Aggregate
Ntile     Aggregate
Percentile     Aggregate
PeriodAgo     Aggregate
PeriodToDate     Aggregate
Rank     Aggregate
StdDev     Aggregate
Sum     Aggregate
SumDistinct     Aggregate
TopN     Aggregate
Mavg     RunningAggregate
Msum     RunningAggregate
Rsum     RunningAggregate
Rcount     RunningAggregate
Rmax     RunningAggregate
Rmin     RunningAggregate
Ascii     String
Bit_length     String
Char     String
Char_Length     String
Concat     String
Insert     String
Left     String
Length     String
Locate     String
LocateN     String
Lower     String
OctetLength     String
Position     String
Repeat     String
Replace     String
Right     String
Substring     String
TrimBoth     String
TrimLeading     String
TrimTrailing     String
Upper     String
Abs     Math
Acos     Math
Asin     Math
Atan     Math
Atan2     Math
Ceiling     Math
Cos     Math
Cot     Math
Degrees     Math
Exp     Math
Floor     Math
Log     Math
Log10     Math
Mod     Math
Pi     Math
Power     Math
Radians     Math
Rand     Math
RandFromSeed     Math
Round     Math
Sign     Math
Sin     Math
Sqrt     Math
Tan     Math
Truncate     Math
Current_date     Calendar/Date/Time
Current_time     Calendar/Date/Time
Current_TimeStamp     Calendar/Date/Time
Day_Of_Quarter     Calendar/Date/Time
DayName     Calendar/Date/Time
DayOfMonth     Calendar/Date/Time
DayOfWeek     Calendar/Date/Time
DayOfYear     Calendar/Date/Time
Hour     Calendar/Date/Time
Minute     Calendar/Date/Time
Month     Calendar/Date/Time
Month_Of_Quarter     Calendar/Date/Time
MonthName     Calendar/Date/Time
Now     Calendar/Date/Time
Quarter_Of_Year     Calendar/Date/Time
Second     Calendar/Date/Time
TimeStampAdd     Calendar/Date/Time
TimeStampDiff     Calendar/Date/Time
Week_Of_Quarter     Calendar/Date/Time
Week_Of_Year     Calendar/Date/Time
Year     Calendar/Date/Time
Cast     Conversion
Choose     Conversion
IfNull     Conversion
IndexCol     Conversion
ValueOf     Conversion
User     Conversion
DateBase     Conversion
Case(Switch)     Expression
Case(If)     Expression