Hi,
I have set up an String element in a Calendar Dimension called Description.
I would like users to type in ant text they need to but for some reason it will only accept Numbers.
There are rules calculating different currencies, but I have made my Description element STET but still no good.
Has anyone got any ideas please ?
Lee
String element will only take Number
-
LeeTaylor1979
- Posts: 63
- Joined: Mon Aug 25, 2008 12:53 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2010
-
Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: String element will only take Number
For an element to be treated as string it needs to be in the last dimension of the cube.
So if your fourth dimension is your measure dim and contains strings and numbers and your fifth contains all numbers then this will override your fourth.
If thats not it then not sure!
So if your fourth dimension is your measure dim and contains strings and numbers and your fifth contains all numbers then this will override your fourth.
If thats not it then not sure!
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
LeeTaylor1979
- Posts: 63
- Joined: Mon Aug 25, 2008 12:53 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2010
Re: String element will only take Number
Steve,
I did not know that.
Problem solved as it always is when posted on this forum.
Many thanks
Lee
I did not know that.
Problem solved as it always is when posted on this forum.
Many thanks
Lee