Numeric to string

[manu0521]

Hi ,

I am using a sql view in my ti to load data , in my sql view I have SID' stored in numeric columns , so in my ti I am just changing them to string from numeric .

Will tm1 internally convert to string when we say string in the variable tab . I am asking becasue should i do this conversion in the sql view , the sid's supposed be interger . But I have my dimension alias as sid's so that i can load the cube based on sid's rather than the keys.

Thanks,

[gtonkin]

I would personally rather do a cast or convert and configure my TI variables for their purpose. Would not leave anything to chance.

[jim wood]

Agreed. TM1 stores numbers differently than in a DB (especially the number of decimal places etc) so doing the change on the query side is by far the safest option.