Page 1 of 1
Max number
Posted: Tue Jul 09, 2013 2:02 pm
by EP_explorer
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
Re: Max number
Posted: Tue Jul 09, 2013 2:22 pm
by tomok
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?
Re: Max number
Posted: Tue Jul 09, 2013 2:41 pm
by declanr
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
Re: Max number
Posted: Tue Jul 09, 2013 3:06 pm
by Duncan P
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.
Re: Max number
Posted: Wed Jul 10, 2013 6:54 am
by EP_explorer
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