Page 1 of 1
Decimal setting IN PERSPECTIVE
Posted: Fri Apr 15, 2016 6:48 am
by late.vaibhav
Hi i am extracting the values from the TM1 cube to the excel through DBRW/DBR function. values are flowing correctly to the excel sheet but when the number is more than 12 decimal it automatically round off and display in the excel, this is creating the data mismatch in the excel. So kindly provide the solution to take values as it is from the TM1 without setting decimal limit.
Thanks & Regards
Vaibhav Late
Re: Decimal setting IN PERSPECTIVE
Posted: Fri Apr 15, 2016 7:24 am
by David Usherwood
er.....
Format? (in Excel)
Re: Decimal setting IN PERSPECTIVE
Posted: Mon Jul 18, 2016 9:51 am
by late.vaibhav
hi David,
actully the excel formating doesn't worked in this case as i have tried this before.
my data is upto 15 decimal.
Re: Decimal setting IN PERSPECTIVE
Posted: Mon Jul 18, 2016 10:01 am
by Edward Stuart
Numeric Precision in Excel -
https://en.wikipedia.org/wiki/Numeric_p ... soft_Excel
TM1 Precision -
https://www-304.ibm.com/support/docview ... wg21515228
Depending on your requirements multiplication of values can sidestep the rounding complications. Excel is notorious for 'helping' users with their data and causing further complications