MicroStrategy ONE
Oracle
The tables listed below describe the MicroStrategy function support for Oracle databases:
Oracle 10g
Function type | Functions that can be evaluated on the database |
Basic functions |
Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Var VarP |
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate |
Internal functions |
Banding BandingC Coalesce |
Null and Zero functions |
IsNotNull IsNull NullToZero ZeroToNull |
OLAP functions |
FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum |
Rank and NTile functions |
Rank |
String functions |
Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim |
Arithmetic operators |
- x + / U- |
Comparison operators |
< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like |
Comparison operators for rank |
*<= *<> *= *>= *Between Not*Between |
Logical operators |
AND IF Not Or |
Data mining functions |
None |
Financial functions |
None |
Mathematical functions |
Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh Trunc |
Statistical functions |
Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX |
Oracle 10gR2
Function type | Functions that can be evaluated on the database |
Basic functions |
Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Var VarP |
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate |
Internal functions |
Banding BandingC Coalesce |
Null and Zero functions |
IsNotNull IsNull NullToZero ZeroToNull |
OLAP functions |
FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum |
Rank and NTile functions |
Rank |
String functions |
Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim |
Arithmetic operators |
- x + / U- |
Comparison operators |
< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like |
Comparison operators for rank |
*<= *<> *= *>= *Between Not*Between |
Logical operators |
AND IF Not Or |
Data mining functions |
None |
Financial functions |
None |
Mathematical functions |
Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh Trunc |
Statistical functions |
Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX |
Oracle 11g
Function type | Functions that can be evaluated on the database |
Basic functions |
Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Var VarP |
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate |
Internal functions |
Banding BandingC Coalesce |
Null and Zero functions |
IsNotNull IsNull NullToZero ZeroToNull |
OLAP functions |
FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum |
Rank and NTile functions |
Rank |
String functions |
Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim |
Arithmetic operators |
- x + / U- |
Comparison operators |
< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like |
Comparison operators for rank |
*<= *<> *= *>= *Between Not*Between |
Logical operators |
AND IF Not Or |
Data mining functions |
None |
Financial functions |
None |
Mathematical functions |
Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh Trunc |
Statistical functions |
Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX |
Oracle 11g R2
Function type | Functions that can be evaluated on the database |
Basic functions |
Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Var VarP |
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate |
Internal functions |
Banding BandingC Coalesce |
Null and Zero functions |
IsNotNull IsNull NullToZero ZeroToNull |
OLAP functions |
FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum |
Rank and NTile functions |
Rank |
String functions |
Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim |
Arithmetic operators |
- x + / U- |
Comparison operators |
< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like |
Comparison operators for rank |
*<= *<> *= *>= *Between Not*Between |
Logical operators |
AND IF Not Or |
Data mining functions |
None |
Financial functions |
None |
Mathematical functions |
Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh Trunc |
Statistical functions |
Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX |
Oracle 12c
Function type | Functions that can be evaluated on the database |
Basic functions |
Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Var VarP |
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour Minute Month MonthEndDate MonthsBetween MonthStartDate Quarter Second Week Year YearEndDate YearStartDate |
Internal functions |
Banding BandingC Coalesce |
Null and Zero functions |
IsNotNull IsNull NullToZero ZeroToNull |
OLAP functions |
FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum |
Rank and NTile functions |
Rank |
String functions |
Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim |
Arithmetic operators |
- x + / U- |
Comparison operators |
< <= <> = > >= Begins With Between Contains Ends With In Like Not Begins With Not Between Not Contains Not Ends With Not In Not Like |
Comparison operators for rank |
*<= *<> *= *>= *Between Not*Between |
Logical operators |
AND IF Not Or |
Data mining functions |
None |
Financial functions |
None |
Mathematical functions |
Abs Acos Acosh Asin Asinh Atan Atan2 Atanh Ceiling Cos Cosh Degrees Exp Floor Int Int2 Ln Log Log10 Mod Power Quotient Radians Round Round2 Sin Sinh Sqrt Tan Tanh Trunc |
Statistical functions |
Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX |