TM1 Forum

Hi,

I have an Element of String type. This element will hold the alphabet values from A to Z (single character)

The problem is that when I try to enter alphabet C into this cell, I get the Clear Operation Message box - which is not really what I want in this case.

Any suggestion how the end users will be able to enter the Alpahabets here?

Enter apostrophe followed by the letter e.g. 'C
The apostrophe is used by Excel to denote a comment or force a string value, it will be stripped out by Excel and not stored in the cube. This will only work in Excel though. For a solution that should work in the cube viewer and TM1 Web my (untested) suggestion would be to add a leading space character before the letters.

ExApplix wrote: I have an Element of String type. This element will hold the alphabet values from A to Z (single character)

The problem is that when I try to enter alphabet C into this cell, I get the Clear Operation Message box - which is not really what I want in this case.

Any suggestion how the end users will be able to enter the Alpahabets here?

You know that bit in the Request For Assistance Guidelines that reads:

2) Ensure that you specify the component of the software that you're having a problem with. If someone states that they have a problem with number formatting, people need to know whether that's in Cube Viewer, Web, EV, or wherever.

Yeah, that bit.

I'm assuming that this is in Cube Viewer rather than Web or Excel.

Supposedly Iboglix was going to modify the command so that it required a multi-key press. Unfortunately some GUI genius, presumably taking lessons from Vista's designers, decided that a confirmation dialog was a better option. In doing so they overlooked this situation. As I see it your options are:
(a) Slice it to Excel where this doesn't seem to be a problem (in 9.5.1) and do the input from there.
(b) Copy the letter C from another source and paste it into Cube Viewer, which doesn't seem to trigger the dialog; or
(c) Enter multi characters (like "cc") then go back and edit the excess one out.

lotsaram wrote:Enter apostrophe followed by the letter e.g. 'C
The apostrophe is used by Excel to denote a comment or force a string value, it will be stripped out by Excel and not stored in the cube. This will only work in Excel though.

Actually you don't need it in Excel; C works as clear on a numeric cell (without a dialog prompt), but simply goes in "as is" to a string cell. (In 9.5.1, anyway.)

Alan Kirk wrote: I'm assuming that this is in Cube Viewer rather than Web or Excel.

Thanks Alan!

I should have mentioned it before. I am having this problem in the Cube Viewer.

Now I am wondering aside from letter C are there any other letters which I should be worried about?

ExApplix wrote:

Alan Kirk wrote: I'm assuming that this is in Cube Viewer rather than Web or Excel.

Thanks Alan!

I should have mentioned it before. I am having this problem in the Cube Viewer.

Now I am wondering aside from letter C are there any other letters which I should be worried about?

Not as far as I can recall. All of the other spreading commands are multi-character ones. It's unlikely that you'd want to enter something else that could be interpreted as one of those.