MicroStrategy ONE

Teradata

The tables listed below describe the MicroStrategy function support for Teradata databases:

Teradata 12

Function type Functions that can be evaluated on the database

Basic functions

Add

Average

Avg

Count

GeoMean

Max

Min

Multiply

Product

Stdev

StdevP

Sum

Var

VarP

Date and time functions

AddDays

AddMonths

CurrentDate

CurrentDateTime

CurrentTime

Date

DayOfMonth

DayOfYear

DaysBetween

Hour

MilliSecond

Minute

Month

MonthEndDate

MonthsBetween

MonthStartDate

Quarter

Second

Year

YearEndDate

YearStartDate

Internal functions

Banding

BandingC

Coalesce

Null and Zero functions

IsNotNull

IsNull

NullToZero

ZeroToNull

OLAP functions

Lag

Lead

MovingAvg

MovingCount

MovingMax

MovingMin

MovingStdev

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

Sin

Sinh

Sqrt

Tan

Tanh

Trunc

Statistical functions

Correlation

Covariance

Fisher

Intercept

InverseFisher

Kurtosis

Pearson

RSquare

Skew

Slope

Standardize

SteYX

Teradata 13

Function type Functions that can be evaluated on the database

Basic functions

Add

Average

Avg

Count

GeoMean

Max

Min

Multiply

Product

Stdev

StdevP

Sum

Var

VarP

Date and time functions

AddDays

AddMonths

CurrentDate

CurrentDateTime

CurrentTime

Date

DayOfMonth

DayOfYear

DaysBetween

Hour

MilliSecond

Minute

Month

MonthEndDate

MonthsBetween

MonthStartDate

Quarter

Second

Year

YearEndDate

YearStartDate

Internal functions

Banding

BandingC

Coalesce

Null and Zero functions

IsNotNull

IsNull

NullToZero

ZeroToNull

OLAP functions

Lag

Lead

MovingAvg

MovingCount

MovingMax

MovingMin

MovingStdev

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

Sin

Sinh

Sqrt

Tan

Tanh

Trunc

Statistical functions

Correlation

Covariance

Fisher

Intercept

InverseFisher

Kurtosis

Pearson

RSquare

Skew

Slope

Standardize

SteYX

Teradata 13.10

Function type Functions that can be evaluated on the database

Basic functions

Add

Average

Avg

Count

GeoMean

Max

Min

Multiply

Product

Stdev

StdevP

Sum

Var

VarP

Date and time functions

AddDays

AddMonths

CurrentDate

CurrentDateTime

CurrentTime

Date

DayOfMonth

DayOfYear

DaysBetween

Hour

MilliSecond

Minute

Month

MonthEndDate

MonthsBetween

MonthStartDate

Quarter

Second

Year

YearEndDate

YearStartDate

Internal functions

Banding

BandingC

Coalesce

Null and Zero functions

IsNotNull

IsNull

NullToZero

ZeroToNull

OLAP functions

Lag

Lead

MovingAvg

MovingCount

MovingMax

MovingMin

MovingStdev

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

Sin

Sinh

Sqrt

Tan

Tanh

Trunc

Statistical functions

Correlation

Covariance

Fisher

Intercept

InverseFisher

Kurtosis

Pearson

RSquare

Skew

Slope

Standardize

SteYX

Teradata 14.0

Function type Functions that can be evaluated on the database

Basic functions

Add

Average

Avg

Count

GeoMean

Greatest

Least

Max

Min

Multiply

Product

Stdev

StdevP

Sum

Var

VarP

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

MovingStdev

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

Teradata 14.10

Function type Functions that can be evaluated on the database

Basic functions

Add

Average

Avg

Count

GeoMean

Greatest

Least

Max

Min

Multiply

Product

Stdev

StdevP

Sum

Var

VarP

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

MovingStdev

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