TM1 Forum

Posted: **Thu Jun 20, 2013 12:42 pm**

Team,

We have a requirement to publish the numeric values from TM1 cube to oracle database tables.
in the cube, sample data is 0.000000000000170530257 this data to be published in the exponential format in database: 1.70530257E-13.
But to display in TM1, we have to round off the value and display 0, but for publishing we have to publish in expon format.

Looking out for help on this
regards
Nare

Posted: **Thu Jun 20, 2013 1:18 pm**

Presuming that you are using a TI process and SQLOutput then you need to use the function NumberToStringEx with a scientific format argument.

e.g.

Code: Select all

numstring = NumberToStringEx( number, '#.##########E+', '.', ',' );

Posted: **Thu Jun 20, 2013 2:21 pm**

Hi Duncan,

Many thanks for your help, It's working..

Cheers
Nare

TM1 Forum

Exponential values to be published from TM1 to DB table

Exponential values to be published from TM1 to DB table

Re: Exponential values to be published from TM1 to DB table

Re: Exponential values to be published from TM1 to DB table