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
Decimal setting IN PERSPECTIVE
-
late.vaibhav
- Posts: 25
- Joined: Mon Dec 09, 2013 1:00 pm
- OLAP Product: tm1
- Version: 9.5.2, 10.2.2
- Excel Version: 2007 2010
- Location: India
- Contact:
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Decimal setting IN PERSPECTIVE
er.....
Format? (in Excel)
Format? (in Excel)
-
late.vaibhav
- Posts: 25
- Joined: Mon Dec 09, 2013 1:00 pm
- OLAP Product: tm1
- Version: 9.5.2, 10.2.2
- Excel Version: 2007 2010
- Location: India
- Contact:
Re: Decimal setting IN PERSPECTIVE
hi David,
actully the excel formating doesn't worked in this case as i have tried this before.
my data is upto 15 decimal.
actully the excel formating doesn't worked in this case as i have tried this before.
my data is upto 15 decimal.
-
Edward Stuart
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Decimal setting IN PERSPECTIVE
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
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