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,
Numeric to string
- gtonkin
- MVP
- Posts: 1202
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Numeric to string
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
- Site Admin
- Posts: 3952
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Numeric to string
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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7