Excel Conversion Functions (MDX)

A set of Excel like functions supported by icCube

Return

void

Description


A list of Excel Text functions to follow MDX standard. We would advise using Java function if available instead.


  • CDate(string s), converts a string into a date using formats as ('M/d/y h:m:s','M/d/y', 'M-d-y h:m:s'... )
  • CDbl(string s), converts the string parameter to a numerical value (double).
  • CLng(string s), converts the string parameter to an integer value (integer)
  • CLngLng(string s), converts the string parameter to an integer value (long).
  • CSng(string s), converts the string parameter to a numerical value (float).
  • CStr(object s), returns the string representation of the parameter (True/False for boolean values).
  • Str(object s), returns the string representation of the parameter (true/false for boolean values).
  • Val(object s), converts the string parameter into a numerical value.

See Also

Java Functions

Examples

XMLA Properties

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