Numeric to string
Posted: Fri May 28, 2021 1:21 am
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,
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,