Kyvos supported MDX functions

Kyvos supports a comprehensive subset of Multidimensional Expressions (MDX) functions. Below is a list all MDX functions supported in the latest version of Kyvos.

• ADDCALCULATEDMEMBERS

• ALLMEMBERS

• ANCESTORS

• ASCENDANTS

• BOTTOMCOUNT

• CHILDREN

• CROSSJOIN  

• DESCENDANTS

• DISTINCT

• DRILLDOWNLEVEL  

• DRILLDOWNLEVELTOP  

• DRILLDOWNLEVELBOTTOM  

• DRILLDOWNMEMBER  

• DRILLDOWNMEMBERTOP

• DRILLDOWNMEMBERBOTTOM

• EXCEPT

• EXISTS

• 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

• XIRR

• Aggregate functions: SUM , AVG , MIN , MAX

• CASE

• COUNT

• CURRENTORDINAL  

• DECILE

• DATE

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752517

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752619

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752823

• Responsesubset

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752466

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753180

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751905

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752874 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753146 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753061 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753095 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753078 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751123

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752721

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753401

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752619

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752024

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751956

• Member Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751310 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752653 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753350 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752415

• member_value,member_key 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752993

• Level Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752653 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751310 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752415 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753350

• String Utility Operations: https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752364 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753010 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752109 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752381 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752483 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753112

• AllValue(customized) 

• Case Logical 

• ISUDA 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753027

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751480  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752262

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752789  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753214  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751854  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752296  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751888  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752347  

• Ancestor 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751565  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752279

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752670  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752891  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751871  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752313  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752228  

• Level.name 

• Level.uniquename 

• Member.level 

• Member.dimension 

• Level.dimension 

• IIF

• IS 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752177

• Logical Operations: AND, OR, XOR 

• NOT 

• Relational Operators: = , <>,> , >= 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752160  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752194  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753418

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752636

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752959

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228753367

• Miscellaneous functions: { }, ( ) , +,-,/,* 

• AS 

• DateAdd 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751531

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751344

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752772

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752126

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751786

• Create Session Member 

• Create Session SET 

• Create Session STATIC SET 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751939

• Nonempty Count 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751395

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228752330  

• RelMemberRange 

• Existing 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20266/pages/1228751990

• Visual totals 

• BITSETINTERSECTION