Cube Functions

Conditional Functions
- AND
  IF
  NOT
  OR
  SWITCH
  XOR
Datasource Functions
- SQLCOLUMN
  SQLCOLUMNNAME
  SQLROW
  SQLVALUE
Date Functions
- Construction & Parsing
  - DATE
    DATEVALUE
    TIME
    TIMEVALUE
    NOW
    TODAY
  Components
  - DAY
    MONTH
    YEAR
    HOUR
    MINUTE
    SECOND
    WEEKDAY
    WEEKDAYEX
    WEEKNUM
  Arithmetic & Differences
  - DATEDIF
    DAYS
    EDATE
    EOMONTH
    MONTHDAYCOUNT
    MONTHDAYS
    MONTHWORKDAYS
    NETWORKDAYS
    SNETWORKDAYS
    WORKDAY
  Formatting
  - FORMATDATE
    FORMATTIME
Dimension Functions
- Element Lookup
  - ALIAS
    ELEMENT
    ELEMENTBYPOSITION
    ELEMENTEXISTS
    ELEMENTTYPE
    MAPPEDELEMENT
    OFFSET
  Hierarchy & Parent-Child
  - CHILD
    CHILDPOSITION
    CHILDREN
    DESCENDANTS
    ELEMENTHASANCESTOR
    HASCOMMONCHILDREN
    HIERARCHYBYPOSITION
    HIERARCHYHASMEMBER
    ISLEAF
    ISLEVELZERO
    LEVELSBETWEEN
    PARENT
  Static Values & Properties
  - CONTAINSSTATICVALUES
    CONTEXTDUMP
    COUNTSTATICVALUES
    HASSTATICVALUE
    SUMSTATICVALUES
  Counts & Indexes
  - CHILDCOUNT
    CUBEDIMENSIONBYPOSITION
    CUBEDIMENSIONCOUNT
    HIERARCHYCOUNT
    NTHCOUNT
    PARENTCOUNT
    POSITION
Financial Functions
- Depreciation
  - DB
    DDB
    SLN
    SYD
    VDB
  Interest & Loans
  - FV
    IPMT
    NPER
    PMT
    PPMT
    PV
    RATE
  Returns (IRR)
  - CUBEIRR
    CUBEXIRR
  Tax
  - ATO_DV
    ATO_PC
Modelling Functions
- Consolidation
  - CONSOLIDATEAVERAGE
    CONSOLIDATEAVERAGENOZEROS
    CONSOLIDATEMAX
    CONSOLIDATEMAXNOZEROS
    CONSOLIDATEMEDIAN
    CONSOLIDATEMEDIANNOZEROS
    CONSOLIDATEMIN
    CONSOLIDATEMINNOZEROS
    CONSOLIDATESTANDARDDEVIATION
    CONSOLIDATESTANDARDDEVIATIONNOZEROS
  Descendant Values
  - FIRSTDESCENDANTVALUE
    FIRSTPOPULATEDDESCENDANTVALUE
    LASTDESCENDANTVALUE
    LASTPOPULATEDDESCENDANTVALUE
  Links & Mapping
  - LINK
    LINKBY
    LINKDIM
    MAPPING
  Data & Variables
  - FIELD
    SEQUENCE
    VARIABLE
Numeric Functions
- Arithmetic & Aggregation
  - ARRAY
    AVERAGE
    AVERAGENOZEROS
    MAX
    MIN
    MOD
  Rounding & Sign
  - ABS
    CEIL
    FLOOR
    INT
    ROUND
  Trigonometric
  - ACOS
    ASIN
    ATAN
    COS
    COSH
    SECH
    SIN
    TAN
  Logarithmic & Power
  - EXP
    LOG
    POW
    POWER
    SQRT
  Statistical & Random
  - MEDIAN
    MODE
    RAND
    RANDBETWEEN
    STDDEV
  Conversion & Formatting
  - NUMBER
    NUMBERFORMAT
    STRING
  Search & Utility
  - CONTAINS
    OCCURRENCES
  Colour
  - COLORDARKEN
    COLORHUESHIFT
    COLORINVERT
    COLORLERP
    COLORLIGHTEN
String Functions
- Manipulation
  - LEFT
    MID
    RIGHT
    REPEAT
    REPT
    SPLIT
  Search & Replace
  - LEN
    REPLACE
    SEARCH
    SUBSTITUTE
  Case & Trim
  - LOWER
    PROPER
    TOGGLESTRING
    TRIM
    TRIMLEFT
    TRIMRIGHT
    UPPER
  Encoding
  - URLDECODE
    URLENCODE
User Functions
- USERCARDACCESS
  USERELEMENTACCESS
  USERHASGROUP

SUBSTITUTE

See REPLACE.

Last updated:

Pager

Previous pageSEARCH

Next pageLOWER

Construction & Parsing

Components

Arithmetic & Differences

Formatting

Element Lookup

Hierarchy & Parent-Child

Static Values & Properties

Counts & Indexes

Depreciation

Interest & Loans

Returns (IRR)

Tax

Consolidation

Descendant Values

Links & Mapping

Data & Variables

Arithmetic & Aggregation

Rounding & Sign

Trigonometric

Logarithmic & Power

Statistical & Random

Conversion & Formatting

Search & Utility

Colour

Manipulation

Search & Replace

Case & Trim

Encoding

SUBSTITUTE ​

SUBSTITUTE