Hi
I'm struggling to input text comments into a string cell in the measure dimension. I've checked the dimension properties and it is definitely set to string, however when we try to input it says "cell is not a number". It is also the last element in the dimension.
I think it is to do with the fact that the measure is across the top i.e. "reserves", "other", "forecast", then "comments" and where it intersects with the elements down the left hand side, i.e. "formula grant change %" and and "formula grant change £". The elements down the left have specific format attributes - so % etc. Looking at it the % format is applying to the whole row, which I don't want it to apply to the comments intersection.
I can't have the comments in the elements on the left hand side as a comment needs to be able to be entered for each change £ etc so needs to be next to the amounts.
Is there a way around this? I've tried to see if there is a "text" format I can apply to the comments element but there isn't.
Hope someone understands this! I've just tried to attach a screen shot but it hasn't worked!
String cell in dimension
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: String cell in dimension
Hi,
The dimension with the string measure should be the last dimension in the cube - the the last dimension in the cube determines the cell type (not the last element in a dimension).
Michel
The dimension with the string measure should be the last dimension in the cube - the the last dimension in the cube determines the cell type (not the last element in a dimension).
Michel
-
ParisHilton
- Posts: 73
- Joined: Fri Apr 23, 2010 11:35 am
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2007 2010
Re: String cell in dimension
Hi Miss speedy,
are you trying to enter data via a contributor interface, or through a TI process?
P
xxx
are you trying to enter data via a contributor interface, or through a TI process?
P
xxx
“The way I see it, you should live everyday like its your birthday”
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
-
jo_hen
- Posts: 9
- Joined: Tue Mar 01, 2011 9:04 am
- OLAP Product: TM1
- Version: 9.5.0
- Excel Version: 2003
Re: String cell in dimension
I did wonder that but the string cell was added after the cube was created so it's not the last dimension in the cube. I've tried to reorder the dimensions in the cube but it keeps saying dimension reorder failed. I also tried recreating the cube with this dimension last but I still get the same message so I'm at a loss!
P - no it's just entry straight into the cube via Web/Perspectives so won't ever be done as part of a process.
P - no it's just entry straight into the cube via Web/Perspectives so won't ever be done as part of a process.
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: String cell in dimension
Hi,
You can't reorder the dimension if this changes the celltype for some area's - and that's in fact what you're trying to do now.
The only option I'm aware of is a full recreate of the cube with the dimension with the string element as the last dimension in the cube.
Michel
You can't reorder the dimension if this changes the celltype for some area's - and that's in fact what you're trying to do now.
The only option I'm aware of is a full recreate of the cube with the dimension with the string element as the last dimension in the cube.
Michel