Excel Numerical Functions (MDX)

A set of Excel like functions supported by icCube (if a parameter is null they will return null)

Return

void

Description


A list of Excel Numerical functions to follow MDX standard.


  • ABS , returns the absolute value of the numerical parameter
  • ACOS , returns the arc cosine
  • ACOSH , returns the inverse hyperbolic cosine
  • ASIN , returns the arc sine
  • ASINH , returns the inverse hyperbolic sine
  • ATAN , returns the arc tangent
  • ATANH , returns the inverse hyperbolic tangent
  • COS , returns the cosine
  • COSH , returns the hyperbolic cosine
  • DEGREES , returns the measurement of the angle parameter in degrees
  • DOLLAR , returns the parameter
  • EXP , returns the exponential (natural base)
  • FACT , returns the factorial (n * (n-1) * (n-2) * ... * 1 , if n = 0 returns 1)
  • INT , returns rounding defined as Math.round(d - 0.5)
  • LN , returns the natural logarithm
  • LOG10 , returns the logarithm with base 10
  • RADIANS , returns the angle parameter in radians.
  • SIGN , returns the sign of the parameter value (0,1,-1)
  • SIN , returns the sine
  • SINH , returns the hyperbolic sine
  • SQRT , returns the positive square root
  • TAN , returns the tangent
  • TANH , returns the hyperbolic tangent
  • ATAN2 , returns the java equivalent of Math.atan2
  • CEILING(d0,d1) , returns the java equivalent of MathX.ceiling(d0, d1)
  • COMBIN(d0,d1) , returns the java equivalent of MathX.nChooseK(d0,d1)
  • FLOOR(d0,d1) , returns the java equivalent of MathX.floor(d0, d1)
  • MOD(d0,d1) , returns the remainder resulting from operation: d0 / d1
  • POWER(d0,d1) , returns the value of the first argument raised to the power of the second argument.
  • ROUND(d0,d1) , returns the java equivalent of MathX.round(d0, (int) d1)
  • ROUNDDOWN(d0,d1) , returns the java equivalent of MathX.roundDown(d0, (int) d1)
  • ROUNDUP(d0,d1) , returns the java equivalent of MathX.roundUp(d0, (int) d1)
  • LOG , returns the logarithm of base 10

See Also

Java Functions

Examples

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.