Maximum Number of Characters for a Text Cell?

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Maximum Number of Characters for a Text Cell?

Post by mce »

Hi,

Does anyone know what is the maximum number of characters for a text cell in TM1?
I really appreciate quick responses.

Regards,
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Maximum Number of Characters for a Text Cell?

Post by qml »

It's 65k characters per cell if I remember correctly, but there are other limitations too:
- TI will only handle 8k,
- Excel will handle less, depending on the version,
- Cube Viewer will not display all characters (there is a limit on column width).

Was that fast enough (faster than searching the forum)?
Kamil Arendt
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Maximum Number of Characters for a Text Cell?

Post by mce »

Many thanks. I found the info about the limitations around 8k for TI, but could not find the ones about 64K per cell.
MartinBrandl
Posts: 11
Joined: Wed Nov 02, 2011 5:15 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: No

Re: Maximum Number of Characters for a Text Cell?

Post by MartinBrandl »

From the TM1-API:
TM1_STRING A character string whose length does not exceed 64K bytes.
Since you can pass a TM1_String into the write function TM1CubeCellValueSet, I suppose that the maximum number of characters is
64.000 for ANSI and 32.000 (64K / 2 Bytes) for Unicode (UTF16).
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Maximum Number of Characters for a Text Cell?

Post by Duncan P »

In 9.5.2 if you are using TI the limit is a bit higher.

I have the following code :-

Code: Select all

write_len = CellGetN('string len test', 'value', 'write length');
write_string = FILL( '*', write_len );
CellPutS( write_string, 'string len test', 'value', 'string' );
read_string = CellGetS( 'string len test', 'value', 'string' );
read_len = LONG( read_string );
CellPutN( read_len, 'string len test', 'value', 'read length' );
which reads a number from a cell, creates a string of that length and puts it in a text cell, reads from the cell and puts the length of the read string in a second numeric cell.

It handles anything up to and including 1500000 ok, but when you try it with 1600000 it fails. I don't know whether this is on the FILL the CellPutS or the CellGetS.
Post Reply