Exponential values to be published from TM1 to DB table

[naree]

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

[Duncan P]

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+', '.', ',' );

[naree]

Hi Duncan,

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

Cheers
Nare