MDX Functions Supported - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
  • ABS
  • ADDCALCULATEDMEMBERS
  • AGGREGATE
  • ANCESTOR
  • ASCENDANTS
  • AVG
  • BOTTOMCOUNT
  • BOTTOMPERCENT
  • BOTTOMSUM
  • CDATE
  • CLOSINGPERIOD
  • CORRELATION
  • COUNT
  • COUSIN
  • CROSSJOIN
  • CSTR
  • DESCENDANTS
  • DIMENSION
  • DIMENSIONS.COUNT
  • DIMENSIONS
  • DISTINCT
  • DISTINCTCOUNT
  • DRILLDOWNLEVEL
  • DRILLDOWNLEVELBOTTOM
  • DRILLDOWNLEVELTOP
  • DRILLDOWNMEMBER
  • DRILLDOWNMEMBERBOTTOM
  • DRILLDOWNMEMBERTOP
  • DRILLUPLEVEL
  • DRILLUPMEMBER
  • EXCEPT
  • EXTRACT
  • FILTER
  • FIRSTCHILD
  • FIRSTSIBLING
  • GENERATE
  • HEAD
  • HIERARCHIZE
  • HIERARCHY
  • IIF
  • INSTR
  • INTERSECT
  • ISEMPTY
  • ISGENERATION
  • ISLEAF
  • ISSIBLING
  • ITEM
  • LAG
  • LASTCHILD
  • LASTNONEMPTY
  • LASTPERIODS
  • LASTSIBLING
  • LCASE
  • LEAD
  • LEAVES
  • LEFT
  • LEN
  • LEVELS
  • LINREGINTERCEPT
  • LINREGPOINT
  • LINREGR2
  • LINREGSLOPE
  • LINREGVARIANCE
  • MAX
  • MEDIAN
  • MEMBER_CAPTION
  • MEMBERSIBLINGS
  • MEMBERTOSTR
  • MEMBERS
  • MEMBERS(STRING)
  • MEMBERSIBLINGS
  • MID/SUBSTRING
  • MIN
  • MTD
  • NAME
  • NEST
  • NEXTMEMBER
  • NONEMPTY
  • NOT
  • NOW
  • OPENINGPERIOD
  • ORDER
  • ORDINAL
  • PARALLELPERIOD
  • PARENT
  • PERIODSTODATE
  • POSITIVE
  • POW
  • PREVMEMBER
  • PROPERTIES
  • QTD
  • RANK
  • RIGHT
  • RND
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SQR
  • STDDEV
  • STDDEVP
  • STDEV
  • STDEVP
  • STRIPCALCULATEDMEMBERS
  • STRTOMEMBER
  • STRTOSET
  • SUBSET
  • SUM
  • TAIL
  • TOGGLEDRILLSTATE
  • TOPCOUNT
  • TOPPERCENT
  • TOPSUM
  • UCASE
  • UNION
  • UNIQUENAME
  • VALUE
  • VAR
  • VARIANCE
  • VARIANCEP
  • VARP
  • WITHMEMBERAS
  • WTD
  • YTD