Hello,
When I am in TI and do a Preview of the ascii file that I want to upload, I noticed that numbers are truncated to 2 decimal places,making the consolidated data a little off from my source spreadsheet. How do I fix the decimal point problem? Any ideas?
Decimal places in ascii file changes
-
- Regular Participant
- Posts: 152
- Joined: Fri May 23, 2008 12:08 am
- OLAP Product: TM1 CX
- Version: 9.5 9.4.1 9.1.4 9.0 8.4
- Excel Version: 2003 2007
- Location: Melbourne, Australia
- Contact:
Re: Decimal places in ascii file changes
Hi,
TM1 will take the values in the source file as given, not truncate them. If your TI input values are rounded off to 2 dp then this will be due to a setting in the saving of the source data. To fix this you need to fix the problem at the source.
TM1 will take the values in the source file as given, not truncate them. If your TI input values are rounded off to 2 dp then this will be due to a setting in the saving of the source data. To fix this you need to fix the problem at the source.