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.

Set functions 

• ADDCALCULATEDMEMBERSPreview

• ALLMEMBERSPreview

• ANCESTORSPreview

• ASCENDANTSPreview

• BOTTOMCOUNTPreview

• CHILDRENPreview

• CROSSJOINPreview  

• DESCENDANTSPreview

• DISTINCTPreview

• DRILLDOWNLEVELPreview  

• DRILLDOWNLEVELTOPPreview  

• DRILLDOWNLEVELBOTTOMPreview  

• DRILLDOWNMEMBERPreview  

• DRILLDOWNMEMBERTOPPreview

• DRILLDOWNMEMBERBOTTOMPreview

• EXCEPTPreview

• EXISTSPreview

• EXTRACTPreview

• FILTERPreview

• GENERATEPreview

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731364

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731381

• Identify_Member(Customized) 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731398

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731466

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731857

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732010  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732027  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732078

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732163  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732299

• SIBLINGSPreview

• STRIPCALCULATEDMEMBERSPreview  

• SUBSETPreview

• TAILPreview

• TOPPERCENTPreview  

• BOTTOMPERCENTPreview  

• TOPSUMPreview  

• BOTTOMSUMPreview  

• TOPCOUNTPreview  

• UNIONPreview

Scalar functions

 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732707

• Aggregate functions: https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732571 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730565 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731925 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731823

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730650

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730735

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730820  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730871

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730837

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731840

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731942

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732146

• Responsesubset

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731789

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732503

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731228

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732197 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732469 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732384 ,https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732418 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732401 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730446

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732044

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732724

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731942

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731347

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731279

• Member Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730633 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731976 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732673 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731738

• member_value,member_key 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732316

• Level Properties: https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731976 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730633 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731738 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732673

• String Utility Operations: https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731687 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732333 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731432 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731704 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731806 , https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732435

• AllValue(customized) 

• Case Logical 

• ISUDA 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732350

Member functions 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730803  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731585

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732112  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732537  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731177  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731619  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731211  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731670  

• Ancestor 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730888  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731602

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731993  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732214  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731194  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731636  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731551  

• Level.name 

• Level.uniquename 

• Member.level 

• Member.dimension 

• Level.dimension 

Logical functions/operators 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731398

• IS 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731500

• Logical Operations: AND, OR, XOR 

• NOT 

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

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731483  

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731517  

Level based (PERIODTODATE) functions 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732741

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731959

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732282

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732690

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

• AS 

Date functions 

• DateAdd 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730854

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730667

Numeric functions 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207732095

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731449

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731109

Additional MDX statements supported 

• Create Session Member 

• Create Session SET 

• Create Session STATIC SET 

Essbase MDX functions 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731262

• Nonempty Count 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207730718

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731653  

• RelMemberRange 

• Existing 

• https://docs.support.kyvosinsights.com/wiki/spaces/KD20265/pages/1207731313

• Visual totals 

Kyvos Custom Function 

• BITSETINTERSECTION