cognos Tm1

[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.

[jim wood]

The string elements have to be in the last dimension of the cube. There is no such thing as string data types.

[hyp]

It is the first dimension where the sample data shows as numbers and we are keeping the data type as String

[tomok]

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.

[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.