Excel Conversion Functions (MDX)

A set of Excel like functions supported by icCube

void

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.

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

v00	v01	v02	v03	v04	v05	v06	v07	v08	v09	v10	v11	v12	v13	v14	v15	v16	v17	v18	v19	v20	v21	v22	v23	v24	v25	v26	v27	v28	v29	v30	v31	v32	v33	v34
10	0	10	3410	3410	34	75	1	1.2	1.2	1200	1200	0.0012	-1200	0	0	1	1.2	1	0	0	1000	0	-1	0	1000	1000	1000	0.123	123	12300	123	123	12300	1234567890