public interface

EnumDSSXMLFunction

com.microstrategy.webapi.EnumDSSXMLFunction
Known Indirect Subclasses

Class Overview

This enumeration is a list of possible functions for operator nodes in expressions.

Summary

Constants
int DssXMLFunctionMultiply
int DssXMlFunctionAverage
int DssXmlFunctionAbs Absolute value
int DssXmlFunctionAdd
int DssXmlFunctionAnd And
int DssXmlFunctionApplyAggregation Apply aggregation
int DssXmlFunctionApplyComparison Apply comparison
int DssXmlFunctionApplyLogic Apply logic
int DssXmlFunctionApplyRelative Apply Relative
int DssXmlFunctionApplySimple Apply simple
int DssXmlFunctionAvg Average
int DssXmlFunctionBanding Banding
int DssXmlFunctionBandingC C-banding
int DssXmlFunctionBandingM
int DssXmlFunctionBandingP P-banding
int DssXmlFunctionBeginsWith Begins with
int DssXmlFunctionBetween Between.
int DssXmlFunctionBetweenEnhanced Enhanced between
int DssXmlFunctionCase Case
int DssXmlFunctionCaseV V-case
int DssXmlFunctionConcat Concatenation
int DssXmlFunctionConcatNoBlank No blank concatenation
int DssXmlFunctionContains Contains
int DssXmlFunctionCount Count
int DssXmlFunctionCurrentDate Current date
int DssXmlFunctionCurrentDateTime Current date-time
int DssXmlFunctionCurrentTime Current time
int DssXmlFunctionCustom Custom
int DssXmlFunctionDayOfMonth Day of month
int DssXmlFunctionDayOfWeek Day of week
int DssXmlFunctionDayOfYear Day of year
int DssXmlFunctionDescendants
int DssXmlFunctionDivide Divide
int DssXmlFunctionEndsWith Ends with
int DssXmlFunctionEqualEnhanced Enhanced equal
int DssXmlFunctionEquals Function for testing equality.
int DssXmlFunctionExpWghMovingAvg Exp.
int DssXmlFunctionExpWghRunningAvg Exp.
int DssXmlFunctionFirstInRange In range
int DssXmlFunctionGeomean Geomin
int DssXmlFunctionGreater Greater than.
int DssXmlFunctionGreaterEqual Greater than or equal to.
int DssXmlFunctionGreaterEqualEnhanced Enhanced greater or equal
int DssXmlFunctionGreatest
int DssXmlFunctionHour Hour
int DssXmlFunctionIn The in operator.
int DssXmlFunctionInitCap Init cap
int DssXmlFunctionIntersect Intersect
int DssXmlFunctionIntersectIn Intersect in
int DssXmlFunctionIsNotNull Is not null
int DssXmlFunctionIsNull Is null
int DssXmlFunctionLTrim L-time
int DssXmlFunctionLastInRange Last in range
int DssXmlFunctionLeast
int DssXmlFunctionLeftStr Left string
int DssXmlFunctionLength Length
int DssXmlFunctionLess Less than.
int DssXmlFunctionLessEqual Less than or equal to.
int DssXmlFunctionLessEqualEnhanced Enhanced less or equal
int DssXmlFunctionLike Like (Generally used for string comparisons).
int DssXmlFunctionLower Lower
int DssXmlFunctionMax Maximum
int DssXmlFunctionMedian Median
int DssXmlFunctionMilliSecond MilliSecond
int DssXmlFunctionMin Minimum
int DssXmlFunctionMinus Minus
int DssXmlFunctionMinute Minute
int DssXmlFunctionMode Mode
int DssXmlFunctionMonth Month
int DssXmlFunctionMovingAvg Moving average
int DssXmlFunctionMovingCount Moving count
int DssXmlFunctionMovingDifference Moving Difference
int DssXmlFunctionMovingMax Moving maximum
int DssXmlFunctionMovingMin Moving minimum
int DssXmlFunctionMovingStdev Moving standard deviation
int DssXmlFunctionMovingStdevP Moving P-standard deviation
int DssXmlFunctionMovingSum Moving sum
int DssXmlFunctionNTile N-tile
int DssXmlFunctionNTileS N-tile S
int DssXmlFunctionNTileVS N-tile VS
int DssXmlFunctionNot Not
int DssXmlFunctionNotBeginsWith Not begins with
int DssXmlFunctionNotBetween Not between.
int DssXmlFunctionNotBetweenEnhanced Enhanced not between
int DssXmlFunctionNotContains Not contains
int DssXmlFunctionNotEndsWith Not ends with
int DssXmlFunctionNotEqual Function for testing nonequality.
int DssXmlFunctionNotEqualEnhanced Enhanced not equal
int DssXmlFunctionNotIn Not in.
int DssXmlFunctionNotLike Not like.
int DssXmlFunctionNullToZero Null to zero
int DssXmlFunctionOr Or
int DssXmlFunctionPercentile Percentile
int DssXmlFunctionPlus Plus
int DssXmlFunctionPosition Position
int DssXmlFunctionProduct Product
int DssXmlFunctionQuarter Quarter
int DssXmlFunctionRTrim R-time
int DssXmlFunctionRank Rank qualification.
int DssXmlFunctionReserved Reserved.
int DssXmlFunctionReservedLastOne
int DssXmlFunctionRightStr Reght string
int DssXmlFunctionRunningAvg Running Average
int DssXmlFunctionRunningCount Running count
int DssXmlFunctionRunningMax Running maximum
int DssXmlFunctionRunningMin Running Minimum
int DssXmlFunctionRunningStdev Running standard deviation
int DssXmlFunctionRunningStdevP Running P-standard deviation
int DssXmlFunctionRunningSum Running sum
int DssXmlFunctionSearch
int DssXmlFunctionSecond Second
int DssXmlFunctionStdev Standard deviation
int DssXmlFunctionStdevP P-case
int DssXmlFunctionSubStr Substirng
int DssXmlFunctionSum Sum
int DssXmlFunctionTimes Times
int DssXmlFunctionTrim Trim
int DssXmlFunctionTuple Tuple
int DssXmlFunctionUcase Upper case
int DssXmlFunctionUnaryMinus Unary minus
int DssXmlFunctionValueSegment Value segment
int DssXmlFunctionVar Variance
int DssXmlFunctionVarP P-varience
int DssXmlFunctionWeek Week
int DssXmlFunctionYear Year
int DssXmlFunctionZeroToNull Zero to null

Constants

public static final int DssXMLFunctionMultiply

Constant Value: 136 (0x00000088)

public static final int DssXMlFunctionAverage

Constant Value: 135 (0x00000087)

public static final int DssXmlFunctionAbs

Absolute value

Constant Value: 24 (0x00000018)

public static final int DssXmlFunctionAdd

Constant Value: 134 (0x00000086)

public static final int DssXmlFunctionAnd

And

Constant Value: 19 (0x00000013)

public static final int DssXmlFunctionApplyAggregation

Apply aggregation

Constant Value: 50 (0x00000032)

public static final int DssXmlFunctionApplyComparison

Apply comparison

Constant Value: 52 (0x00000034)

public static final int DssXmlFunctionApplyLogic

Apply logic

Constant Value: 51 (0x00000033)

public static final int DssXmlFunctionApplyRelative

Apply Relative

Constant Value: 53 (0x00000035)

public static final int DssXmlFunctionApplySimple

Apply simple

Constant Value: 49 (0x00000031)

public static final int DssXmlFunctionAvg

Average

Constant Value: 14 (0x0000000e)

public static final int DssXmlFunctionBanding

Banding

Constant Value: 40 (0x00000028)

public static final int DssXmlFunctionBandingC

C-banding

Constant Value: 41 (0x00000029)

public static final int DssXmlFunctionBandingM

Constant Value: 137 (0x00000089)

public static final int DssXmlFunctionBandingP

P-banding

Constant Value: 42 (0x0000002a)

public static final int DssXmlFunctionBeginsWith

Begins with

Constant Value: 77 (0x0000004d)

public static final int DssXmlFunctionBetween

Between.

Constant Value: 17 (0x00000011)

public static final int DssXmlFunctionBetweenEnhanced

Enhanced between

Constant Value: 39 (0x00000027)

public static final int DssXmlFunctionCase

Case

Constant Value: 82 (0x00000052)

public static final int DssXmlFunctionCaseV

V-case

Constant Value: 83 (0x00000053)

public static final int DssXmlFunctionConcat

Concatenation

Constant Value: 72 (0x00000048)

public static final int DssXmlFunctionConcatNoBlank

No blank concatenation

Constant Value: 104 (0x00000068)

public static final int DssXmlFunctionContains

Contains

Constant Value: 76 (0x0000004c)

public static final int DssXmlFunctionCount

Count

Constant Value: 13 (0x0000000d)

public static final int DssXmlFunctionCurrentDate

Current date

Constant Value: 90 (0x0000005a)

public static final int DssXmlFunctionCurrentDateTime

Current date-time

Constant Value: 98 (0x00000062)

public static final int DssXmlFunctionCurrentTime

Current time

Constant Value: 99 (0x00000063)

public static final int DssXmlFunctionCustom

Custom

Constant Value: -1 (0xffffffff)

public static final int DssXmlFunctionDayOfMonth

Day of month

Constant Value: 91 (0x0000005b)

public static final int DssXmlFunctionDayOfWeek

Day of week

Constant Value: 92 (0x0000005c)

public static final int DssXmlFunctionDayOfYear

Day of year

Constant Value: 93 (0x0000005d)

public static final int DssXmlFunctionDescendants

Constant Value: 187 (0x000000bb)

public static final int DssXmlFunctionDivide

Divide

Constant Value: 4 (0x00000004)

public static final int DssXmlFunctionEndsWith

Ends with

Constant Value: 78 (0x0000004e)

public static final int DssXmlFunctionEqualEnhanced

Enhanced equal

Constant Value: 35 (0x00000023)

public static final int DssXmlFunctionEquals

Function for testing equality.

Constant Value: 6 (0x00000006)

public static final int DssXmlFunctionExpWghMovingAvg

Exp. wgh. moving average

Constant Value: 64 (0x00000040)

public static final int DssXmlFunctionExpWghRunningAvg

Exp. wgh. running average

Constant Value: 70 (0x00000046)

public static final int DssXmlFunctionFirstInRange

In range

Constant Value: 73 (0x00000049)

public static final int DssXmlFunctionGeomean

Geomin

Constant Value: 34 (0x00000022)

public static final int DssXmlFunctionGreater

Greater than.

Constant Value: 8 (0x00000008)

public static final int DssXmlFunctionGreaterEqual

Greater than or equal to.

Constant Value: 10 (0x0000000a)

public static final int DssXmlFunctionGreaterEqualEnhanced

Enhanced greater or equal

Constant Value: 37 (0x00000025)

public static final int DssXmlFunctionGreatest

Constant Value: 115 (0x00000073)

public static final int DssXmlFunctionHour

Hour

Constant Value: 100 (0x00000064)

public static final int DssXmlFunctionIn

The in operator.

Constant Value: 22 (0x00000016)

public static final int DssXmlFunctionInitCap

Init cap

Constant Value: 111 (0x0000006f)

public static final int DssXmlFunctionIntersect

Intersect

Constant Value: 45 (0x0000002d)

public static final int DssXmlFunctionIntersectIn

Intersect in

Constant Value: 46 (0x0000002e)

public static final int DssXmlFunctionIsNotNull

Is not null

Constant Value: 55 (0x00000037)

public static final int DssXmlFunctionIsNull

Is null

Constant Value: 54 (0x00000036)

public static final int DssXmlFunctionLTrim

L-time

Constant Value: 107 (0x0000006b)

public static final int DssXmlFunctionLastInRange

Last in range

Constant Value: 74 (0x0000004a)

public static final int DssXmlFunctionLeast

Constant Value: 116 (0x00000074)

public static final int DssXmlFunctionLeftStr

Left string

Constant Value: 114 (0x00000072)

public static final int DssXmlFunctionLength

Length

Constant Value: 105 (0x00000069)

public static final int DssXmlFunctionLess

Less than.

Constant Value: 9 (0x00000009)

public static final int DssXmlFunctionLessEqual

Less than or equal to.

Constant Value: 11 (0x0000000b)

public static final int DssXmlFunctionLessEqualEnhanced

Enhanced less or equal

Constant Value: 38 (0x00000026)

public static final int DssXmlFunctionLike

Like (Generally used for string comparisons).

Constant Value: 18 (0x00000012)

public static final int DssXmlFunctionLower

Lower

Constant Value: 106 (0x0000006a)

public static final int DssXmlFunctionMax

Maximum

Constant Value: 16 (0x00000010)

public static final int DssXmlFunctionMedian

Median

Constant Value: 30 (0x0000001e)

public static final int DssXmlFunctionMilliSecond

MilliSecond

Constant Value: 103 (0x00000067)

public static final int DssXmlFunctionMin

Minimum

Constant Value: 15 (0x0000000f)

public static final int DssXmlFunctionMinus

Minus

Constant Value: 2 (0x00000002)

public static final int DssXmlFunctionMinute

Minute

Constant Value: 101 (0x00000065)

public static final int DssXmlFunctionMode

Mode

Constant Value: 31 (0x0000001f)

public static final int DssXmlFunctionMonth

Month

Constant Value: 95 (0x0000005f)

public static final int DssXmlFunctionMovingAvg

Moving average

Constant Value: 27 (0x0000001b)

public static final int DssXmlFunctionMovingCount

Moving count

Constant Value: 65 (0x00000041)

public static final int DssXmlFunctionMovingDifference

Moving Difference

Constant Value: 62 (0x0000003e)

public static final int DssXmlFunctionMovingMax

Moving maximum

Constant Value: 60 (0x0000003c)

public static final int DssXmlFunctionMovingMin

Moving minimum

Constant Value: 61 (0x0000003d)

public static final int DssXmlFunctionMovingStdev

Moving standard deviation

Constant Value: 63 (0x0000003f)

public static final int DssXmlFunctionMovingStdevP

Moving P-standard deviation

Constant Value: 86 (0x00000056)

public static final int DssXmlFunctionMovingSum

Moving sum

Constant Value: 28 (0x0000001c)

public static final int DssXmlFunctionNTile

N-tile

Constant Value: 58 (0x0000003a)

public static final int DssXmlFunctionNTileS

N-tile S

Constant Value: 87 (0x00000057)

public static final int DssXmlFunctionNTileVS

N-tile VS

Constant Value: 88 (0x00000058)

public static final int DssXmlFunctionNot

Not

Constant Value: 21 (0x00000015)

public static final int DssXmlFunctionNotBeginsWith

Not begins with

Constant Value: 80 (0x00000050)

public static final int DssXmlFunctionNotBetween

Not between.

Constant Value: 44 (0x0000002c)

public static final int DssXmlFunctionNotBetweenEnhanced

Enhanced not between

Constant Value: 71 (0x00000047)

public static final int DssXmlFunctionNotContains

Not contains

Constant Value: 79 (0x0000004f)

public static final int DssXmlFunctionNotEndsWith

Not ends with

Constant Value: 81 (0x00000051)

public static final int DssXmlFunctionNotEqual

Function for testing nonequality.

Constant Value: 7 (0x00000007)

public static final int DssXmlFunctionNotEqualEnhanced

Enhanced not equal

Constant Value: 36 (0x00000024)

public static final int DssXmlFunctionNotIn

Not in.

Constant Value: 57 (0x00000039)

public static final int DssXmlFunctionNotLike

Not like.

Constant Value: 43 (0x0000002b)

public static final int DssXmlFunctionNullToZero

Null to zero

Constant Value: 47 (0x0000002f)

public static final int DssXmlFunctionOr

Or

Constant Value: 20 (0x00000014)

public static final int DssXmlFunctionPercentile

Percentile

Constant Value: 59 (0x0000003b)

public static final int DssXmlFunctionPlus

Plus

Constant Value: 1 (0x00000001)

public static final int DssXmlFunctionPosition

Position

Constant Value: 108 (0x0000006c)

public static final int DssXmlFunctionProduct

Product

Constant Value: 29 (0x0000001d)

public static final int DssXmlFunctionQuarter

Quarter

Constant Value: 96 (0x00000060)

public static final int DssXmlFunctionRTrim

R-time

Constant Value: 109 (0x0000006d)

public static final int DssXmlFunctionRank

Rank qualification.

Constant Value: 23 (0x00000017)

public static final int DssXmlFunctionReserved

Reserved.

Constant Value: 0 (0x00000000)

public static final int DssXmlFunctionReservedLastOne

Constant Value: 188 (0x000000bc)

public static final int DssXmlFunctionRightStr

Reght string

Constant Value: 113 (0x00000071)

public static final int DssXmlFunctionRunningAvg

Running Average

Constant Value: 26 (0x0000001a)

public static final int DssXmlFunctionRunningCount

Running count

Constant Value: 69 (0x00000045)

public static final int DssXmlFunctionRunningMax

Running maximum

Constant Value: 66 (0x00000042)

public static final int DssXmlFunctionRunningMin

Running Minimum

Constant Value: 67 (0x00000043)

public static final int DssXmlFunctionRunningStdev

Running standard deviation

Constant Value: 68 (0x00000044)

public static final int DssXmlFunctionRunningStdevP

Running P-standard deviation

Constant Value: 85 (0x00000055)

public static final int DssXmlFunctionRunningSum

Running sum

Constant Value: 25 (0x00000019)

public static final int DssXmlFunctionSearch

Constant Value: 158 (0x0000009e)

public static final int DssXmlFunctionSecond

Second

Constant Value: 102 (0x00000066)

public static final int DssXmlFunctionStdev

Standard deviation

Constant Value: 32 (0x00000020)

public static final int DssXmlFunctionStdevP

P-case

Constant Value: 84 (0x00000054)

public static final int DssXmlFunctionSubStr

Substirng

Constant Value: 110 (0x0000006e)

public static final int DssXmlFunctionSum

Sum

Constant Value: 12 (0x0000000c)

public static final int DssXmlFunctionTimes

Times

Constant Value: 3 (0x00000003)

public static final int DssXmlFunctionTrim

Trim

Constant Value: 112 (0x00000070)

public static final int DssXmlFunctionTuple

Tuple

Constant Value: 1000 (0x000003e8)

public static final int DssXmlFunctionUcase

Upper case

Constant Value: 56 (0x00000038)

public static final int DssXmlFunctionUnaryMinus

Unary minus

Constant Value: 5 (0x00000005)

public static final int DssXmlFunctionValueSegment

Value segment

Constant Value: 75 (0x0000004b)

public static final int DssXmlFunctionVar

Variance

Constant Value: 33 (0x00000021)

public static final int DssXmlFunctionVarP

P-varience

Constant Value: 89 (0x00000059)

public static final int DssXmlFunctionWeek

Week

Constant Value: 94 (0x0000005e)

public static final int DssXmlFunctionYear

Year

Constant Value: 97 (0x00000061)

public static final int DssXmlFunctionZeroToNull

Zero to null

Constant Value: 48 (0x00000030)