Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
Kyvos supports a significant subset of Multidimensional Expressions (MDX) functions.
Here's a list of all the MDX functions supported by the latest version of Kyvos.
Set functions
AddCalculatedMembers
AllMembers
Ancestors
Ascendants
BottomCount
Children
Crossjoin
Descendants
Distinct
DrilldownLevel
DrilldownLevelTop
DrilldownLevelBottom
DrilldownMember
DrilldownMemberTop
DrilldownMemberBottom
Except
Exist
Extract
Filter
Generate
Head
Hierarchize
Identify_Member(Customized)
IIF
Intersect
Members
NonEmpty
NonEmptyCrossjoin
Order
PeriodsToDate
Range
Siblings
StripCalculatedMembers
Subset
Tail
TopPercent
BottomPercent
TopSum
BottomSum
TopCount
Union
Scalar functions
Aggregate – SUM, AVG, MIN, MAX
CASE
Count
CurrentOrdinal
Date
Month
Format
Mathematical Operators-
POWER,SQRT,ROUND,ROUNDUP,ROUNDDOWN,ABS
Now()
YEAR
MONTH
GETTIMESTAMP(customized)
GETDATE(customized)
Member Properties - Caption, Name, Uniquename, Level_number
member_value,member_key
Rank
Level Properties - Name, Caption , level_number, UniqueName
String Utility Operations - Left, Right, Instr, Len, Ltrim, Rtrim
AllValue(customized)
Case Logical
ISUDA
Member functions
CurrentMember
Item
ParallelPeriod
StrToMember
FirstChild
LastChild
FirstSibling
LastSibling
Ancestor
DefaultMember
Lag
NextMember
PreviousMember
FirstMember
LastMember
IsLevel
Level.name
Level.uniquename
Member.level
Member.dimension
Level.dimension
Logical functions/operators
IFF
IS
ISEMPTY
Logical Operations - AND, OR, XOR
NOT
Relational Operators - = , <>,> , >=
IsAncestor
IsGeneration
Level based (PERIODTODATE) functions
YTD
MTD
QTD
WTD
6.Miscellaneous functions/Operators
{ }
AS
( )
+,-,/,*
Date functions
DateAdd
DateDiff
CDATE
Numeric functions
ORDINAL
Int
Exp
Additional MDX statements supported
Create Session Member
Create Session SET
Create Session STATIC SET
Essbase MDX functions
Generation
Nonempty Count
Closing Period
Last Periods
RelMemberRange
Existing
GetFilterInfo
Visual totals
Kyvos Custom Function
BITSETINTERSECTION