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/KD20268/pages/1414671591

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671693

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671897

• Responsesubset

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671540

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672254

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670979

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671948 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672220 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672135 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672169 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672152 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670197

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671795

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672475

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671693

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671098

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671030

• Member Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670384 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671727 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672424 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671489

• member_value,member_key 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672067

• Level Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671727 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670384 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671489 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672424

• String Utility Operations: https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671438 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672084 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671183 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671455 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671557 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672186

• AllValue(customized) 

• Case Logical 

• ISUDA 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672101

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670554  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671336

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671863  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672288  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670928  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671370  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670962  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671421  

• Ancestor 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670639  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671353

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671744  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671965  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670945  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671387  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671302  

• Level.name 

• Level.uniquename 

• Member.level 

• Member.dimension 

• Level.dimension 

• IIF

• IS 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671251

• Logical Operations: AND, OR, XOR 

• NOT 

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

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671234  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671268  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672492

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671710

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672033

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414672441

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

• AS 

• DateAdd 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670605

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670418

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671846

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671200

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670860

• Create Session Member 

• Create Session SET 

• Create Session STATIC SET 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671013

• Nonempty Count 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414670469

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671404  

• RelMemberRange 

• Existing 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20268/pages/1414671064

• Visual totals 

• BITSETINTERSECTION