Supported MDX Functions
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Â
Copyright Kyvos, Inc. All rights reserved.