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 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632486

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632534

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1071382529

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632566

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632470

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632662

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632726  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632853

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632884

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632914  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632944  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632929  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632959  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632989

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632974

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633004

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633019

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633049

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633079

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633154

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633229

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633244

• Identify_Member(Customized) 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633259

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633319

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633682

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633817  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633832  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633877

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068597249  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068892173

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826698

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1071054849  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826710

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826734

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070956557  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632454  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1071251457  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632598  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826746  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1071251469

Scalar functions

 

• XIRRPreview

• Aggregate functions: SUMPreview , AVGPreview , MINPreview , MAXPreview

• CASEPreview

• COUNTPreview

• CURRENTORDINALPreview  

• DECILEPreview

• DATEPreview

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633667

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633757

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1067548689

• Responsesubset

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633455

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633471

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633139

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826625 ,https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826686 ,https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069121573 ,https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069121585 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826662 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632502

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633847

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1071251481

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633757

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633214

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633184

• Member Properties: https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632614 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633787 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070727193 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633592

• member_value,member_key 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068990477

• Level Properties: https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633787 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632614 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633592 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070727193

• String Utility Operations: https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633562 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069121549 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633289 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069416488 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633637 , https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826674

• AllValue(customized) 

• Case Logical 

• ISUDA 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069121561

Member functions 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632774  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633424

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1067253794  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070727181  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633094  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633502  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633124  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633547  

• Ancestor 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632837  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633487

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633802  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1068826637  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633109  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633517  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633394  

• Level.name 

• Level.uniquename 

• Member.level 

• Member.dimension 

• Level.dimension 

Logical functions/operators 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633259

• IS 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633349

• Logical Operations: AND, OR, XOR 

• NOT 

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

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633334  

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633364  

Level based (PERIODTODATE) functions 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070956593

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633772

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1069121537

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070956569

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

• AS 

Date functions 

• DateAdd 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1070235661

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632646

Numeric functions 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/1067941893

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633304

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633034

Additional MDX statements supported 

• Create Session Member 

• Create Session SET 

• Create Session STATIC SET 

Essbase MDX functions 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633169

• Nonempty Count 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966632694

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633532  

• RelMemberRange 

• Existing 

• https://docs.support.kyvos.io/wiki/spaces/KD20263/pages/966633199

• Visual totals 

Kyvos Custom Function 

• BITSETINTERSECTION