Page 1 of 1
cognos Tm1
Posted: Tue Aug 30, 2016 11:20 am
by hyp
Hi Experts,
Am new to cognos Tm1,I have a doudt in TM1 we have some data where the data is showing as numbers and we are keeping the data type as string in what circumstances can we make this data type as string can someone help me on this.
thanks in advance.
Re: cognos Tm1
Posted: Tue Aug 30, 2016 11:39 am
by jim wood
The string elements have to be in the last dimension of the cube. There is no such thing as string data types.
Re: cognos Tm1
Posted: Tue Aug 30, 2016 12:34 pm
by hyp
It is the first dimension where the sample data shows as numbers and we are keeping the data type as String
Re: cognos Tm1
Posted: Tue Aug 30, 2016 12:57 pm
by tomok
hyp wrote:It is the first dimension where the sample data shows as numbers and we are keeping the data type as String
Then that's why it isn't working. You define cells as being able to hold string values by setting the element type as String IN THE LAST DIMENSION IN THE CUBE. Defining that in any other dimension will not work.
Re: cognos Tm1
Posted: Tue Aug 30, 2016 1:02 pm
by Nidhi
In Tm1 Elements are numeric or string type
If you want to store string data make the element as string and make sure it should be the last dimension of your cube other wise it wont work.
eg. If you want to store comment
Make an element comment in last dimension and then you can input any string on that intersection.