Hi,
Does anyone know what is the maximum number of characters for a text cell in TM1?
I really appreciate quick responses.
Regards,
Maximum Number of Characters for a Text Cell?
- 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?
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)?
- 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
- 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?
Many thanks. I found the info about the limitations around 8k for TI, but could not find the ones about 64K per cell.
-
- 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?
From the TM1-API:
64.000 for ANSI and 32.000 (64K / 2 Bytes) for Unicode (UTF16).
Since you can pass a TM1_String into the write function TM1CubeCellValueSet, I suppose that the maximum number of characters isTM1_STRING A character string whose length does not exceed 64K bytes.
64.000 for ANSI and 32.000 (64K / 2 Bytes) for Unicode (UTF16).
-
- 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?
In 9.5.2 if you are using TI the limit is a bit higher.
I have the following code :-
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.
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' );
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.