Cryptic TM1 Messages Decoded

Ideas and tips for enhancing your TM1 application
iansdigby
Community Contributor
Posts: 107
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10
Excel Version: 2007 Professional
Location: Isle of Wight, UK

Re: Cryptic TM1 Messages Decoded

Post by iansdigby » Tue Dec 04, 2012 10:37 am

On running any TI process that, inter alia, populates a cube:

TM1speak (in message log) : "Cell type is real"

Human speak: "You specified that a data variable was of type Numeric but the cube cell you are sending it to is a string cell".

(or vice versa?)
"the earth is but one country, and mankind its citizens" - Baha'u'llah

User avatar
Alan Kirk
Site Admin
Posts: 5828
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Alan Kirk » Tue Dec 04, 2012 8:15 pm

iansdigby wrote:On running any TI process that, inter alia, populates a cube:

TM1speak (in message log) : "Cell type is real"

Human speak: "You specified that a data variable was of type Numeric but the cube cell you are sending it to is a string cell".

(or vice versa?)
Real = Numeric. You'll sometimes come across an error like "cannot convert {whatever} to real" (can't recall the exact syntax of it); it means that whatever is trying to be input to a cell or otherwise manipulated cannot be converted to and/or is not numeric.

Edit: I expected that this would be referred to somewhere in the documentation, but the only place I can find it is in the API manual which is a place that most of those who don't wish to look programming death in the face and laugh at it will avoid. Page 10 of the 10.1 manual:

Code: Select all

Value                  Description
TM1_REAL          A double precision IEEE floating point number.
TM1_STRING       A character string whose length does not exceed 64K bytes.
TM1_INDEX          A 32 bit unsigned integer.
TM1_BOOL          A logical value stored as 1 to indicate TRUE, 0 to indicate false.
TM1_OBJECT       A structure used to refer to objects managed by the API. Typically an object contains information about the server in which the object resides, and an index to locate the object within the server.
TM1_ERROR        A structure containing typically an error code and an error message string.
TM1_ARRAY        An array of values.
Items 1 and 2 are the only ones that apply to values stored in a cube, though.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Wim Gielis
MVP
Posts: 1806
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Wim Gielis » Fri Aug 09, 2013 9:11 pm

Another one:
Data spread failed.
You are a read-only user - as set in the }ClientProperties control cube - and you try to edit a numeric cell.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

GWT
Posts: 2
Joined: Thu Jul 24, 2014 9:36 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Cryptic TM1 Messages Decoded

Post by GWT » Thu Jul 24, 2014 9:48 am

"failed to create empty document" when double-clicking on a SUBNM in Excel.

Try deleting the .tbd files in %appdata%\Applix\TM1

Post Reply