MicroStrategy ONE
IBM Red Brick
The tables listed below describe the MicroStrategy function support for IBM Red Brick databases:
IBM Red Brick 6.3
| Function type | Functions that can be evaluated on the database |
|
Basic functions |
Add Average Avg Count Max Min Multiply Sum |
|
Date and time functions |
AddDays AddMonths CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween Hour MilliSecond 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 |
Lag Lead MovingAvg MovingCount MovingMax MovingMin MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin 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 Ceiling Exp Floor Int Int2 Ln Mod Quotient Round Round2 Sqrt |
|
Statistical functions |
None |