Analytical Engine Support for Functions

The functions listed in the following table are supported by the MicroStrategy Analytical Engine. This allows metrics to be evaluated by MicroStrategy in cases where functions cannot be evaluated by a database. It also allows metrics to support smart metric functionality (see the Advanced Reporting Help).

Function type	Functions supported by the MicroStrategy Analytical Engine
Basic functions	Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Mode Multiply Product Stdev StdevP Sum Var VarP
Date and time functions	All date and time functions are supported by the MicroStrategy Analytical Engine
Internal functions	Banding BandingC BandingP Case CaseV
Null and Zero functions	IsNotNull IsNull NullToEmpty NullToZero ZeroToNull
OLAP functions	ExpWghMovingAvg ExpWghRunningAvg FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingDifference MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum
Rank and NTile functions	NTile NTileSize NTileValue NTileValueSize Percentile Rank
String functions	Concat ConcatBlank InitCap LeftStr Length Lower LTrim Position RightStr RTrim SubStr Trim Upper
Arithmetic operators	All Arithmetic functions are supported by the MicroStrategy Analytical Engine
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 NotBetween
Logical operators	AND IF Not Or
Data mining functions	All data mining functions are supported by the MicroStrategy Analytical Engine.
Financial functions	All financial functions are supported by the MicroStrategy Analytical Engine.
Mathematical functions	All mathematical functions are supported by the MicroStrategy Analytical Engine.
Statistical functions	All statistical functions are supported by the MicroStrategy Analytical Engine.