TM1 Forum

So I'm trying to import data into a Currency Exchange Cube, and everything seems to be running smoothly. BUT there is one slight error during the input (I believe) that is causing a discrepancy. So my data for the exchange rates is up to 5 decimal places, and my measure dimension has its format set to General.

However, after input, the data in the cube appears to be rounded off to 3 decimal places. I don't think it has anything to do with the formatting of my measure dimension, and even in the TI process in the preview window, the data appears to be fine (not rounded off) but after running it, in the cube the data is rounded to 3 decimal places. Any ideas of what can be done to rectify this issue?

iRule wrote:So I'm trying to import data into a Currency Exchange Cube, and everything seems to be running smoothly. BUT there is one slight error during the input (I believe) that is causing a discrepancy. So my data for the exchange rates is up to 5 decimal places, and my measure dimension has its format set to General.

However, after input, the data in the cube appears to be rounded off to 3 decimal places. I don't think it has anything to do with the formatting of my measure dimension, and even in the TI process in the preview window, the data appears to be fine (not rounded off) but after running it, in the cube the data is rounded to 3 decimal places. Any ideas of what can be done to rectify this issue?

It could also be in the formatting of the view. You could test the contents of the cube by exporting the data to a flat file and see what comes out or by just slicing the view to Excel, format the regarding column(s) to general format and see whether the numbers are still rounded.

Michel

This link explains the cell formatting :
http://public.dhe.ibm.com/software/data ... tm1_ug.pdf ,Sorry if you have already gone through this.Thanks

Michel Zijlema wrote:It could also be in the formatting of the view. You could test the contents of the cube by exporting the data to a flat file and see what comes out or by just slicing the view to Excel, format the regarding column(s) to general format and see whether the numbers are still rounded.

Michel

I tried that Michel, but it only confirmed my suspicion that the data is actually being rounded off somewhere, probably during the TI import process. I use the PM so not sure where I should be looking in the script to figure out where the data could be rounded off. Any suggestions guys on how to fix this?

So an interesting development, When I look at the process in the PM in the preview the whole entire data with the correct decimal places is being show. Whereas when I see it in Architect, the preview shows data rounded off to 3 decimal places. And it turns out that the local temp csv file (as shown in the data source name) actually has data being rounded off like that.