Max number

EP_explorer · Post by **EP_explorer** » Tue Jul 09, 2013 2:02 pm

That is the max number possible to input in one cell of TM1 Cube
I mean how many digits in number?

for example in 999 999 999 999 999 - 15 digits

tomok · Post by **tomok** » Tue Jul 09, 2013 2:22 pm

EP_explorer wrote:That is the max number possible to input in one cell of TM1 Cube
I mean how many digits in number?

for example in 999 999 999 999 999 - 15 digits

Wouldn't this be really easy to determine on your own?

declanr · Post by **declanr** » Tue Jul 09, 2013 2:41 pm

The IBM technote below should point you in the right direction but since you highlighted a 15 digit number within your question it does suggest that you have already done some investigating anyway.

http://www-01.ibm.com/support/docview.w ... wg21515228

Duncan P · Post by **Duncan P** » Tue Jul 09, 2013 3:06 pm

TM1 holds numbers in IEEE double precision (64 bit) floating point format. The largest possible number in this format is 1.797693134862316E308.

Only the first 16 digits of this are significant. The cube viewer in TM1 Architect will accept anything up to a 304 character number but anything you type after the first 16 will be ignored.

EP_explorer · Post by **EP_explorer** » Wed Jul 10, 2013 6:54 am

Thank you for anwsers.
It seems 15 digit is maximum (after 15 digits it show zeros although I put by rule other values)

101 050 019 018 010 000 000 000,00
101 050 019 018 010 000 000,00
101 050 019 018 010 000,00
101 050 019 018 010,00
101 050 019 018,00
101 050 019,00
101 050,00
101,00

TM1 Forum

Max number

Max number

Re: Max number

Re: Max number

Re: Max number

Re: Max number