TM1 Forum

Hi TM1 masters,
Need your advice in below issue.

Issue is quite a general one and I have read other posts in this forum, but I am still thinking it will not cause a problem afterwards.
I am loading a csv into a cube. Cube has 4dimensions:dim1,dim2,dim3,Measure.
Measure dimension contains around 150 elements f which all elements store numeric values ,only 2 elements store string values.

In variables tab, If I consider measure as "Numeric", so while loading csv it will generate below error-"Cannot convert field number '', value " " to a real number.

I can understand that cellputN,cellputS giving error for this case.

If I use below code, then I need to take measure as "String" using NUMBR function, it does not generate any error
ctype= dtype('Measure',Value);

If( ctype @= 'N');
cellputN(numbr(Value),cCube,dim1,dim2,dim3,Measure);
else;
CellPutS(Value,cCube,dim1,dim2,dim3,Measure);
endif;

is this the right approach or there is any other workaround?
I will use this cube as a staging cube and using Rules, I will load the values into other cubes.

Please guide. thanks.

Yes this is fine.

Other conversion functions that you can consider:
http://www.wimgielis.com/tm1_numbersandstrings_EN.htm

Thanks Wim. Cheers!

This might also help:
http://www.tm1forum.com/viewtopic.php?f=3&t=1109&p=6155 Thanks