TM1 TI Error Data is not Real

[MingWei]

Hello fellow forum-er,

I have encountered a "Cell Type is real" error whenever I execute my TM1 TI.
I had checked on the net and its seems to be due to writing a invalid data type into a cell.

However, it seems strange to me as my datatype is the same as that I had declared in TM1.

My variable "sign" datatype in SQL Server Stored Procedure is varchar(3)
Thus, in theory, <CellPutS(signs,'ebf.IICoyElimReportCube', fiscal_year, report_plan, product_code, sap_gl_account, fiscal_period);> should be able to execute without error during execution.

I had done a checking and found out the following:
My data in sign consist of the data varies from symbols , alphabet as well as integer. (Refer the data below)

sign
E
*
G
-
90
=
00
GE
W
NULL
+
120
GBH
60

0
O
OH
B
?
GB
30
EH
45


May I know if it is due to these information mentioned above that causes the TI to encountered such error?
If so, what can I do to allow the TI to accept such data?

Kindly advise and thanks in advanced ^^.
best regards
Brandon

[Andy]

Dear Brandon,

Can you look in the TI process on the tab 'Variables'?

What variable type is chosen?

[MingWei]

Hi Andy,

The Variable Type is "String"

[lotsaram]

Hi Andy,

The Variable Type is "String"

Thus you have your error.
With the "Cell Type is real" error TM1 is telling you that you are attempting to write string data with CellPutS into a numeric leaf cell.

[MingWei]

Thus you have your error.
With the "Cell Type is real" error TM1 is telling you that you are attempting to write string data with CellPutS into a numeric leaf cell.

Hi lotsaram,

My data output for column "Signs" from SQL stored procedure is in varchar which is equal to string.
As My variable type is also string, in theory there should not have any such error as there is no discrepancies between them.
Am I wrong with my understanding

Pardon me as I am a beginner in TM1,
May I know if there are any others setting relating to such, which i missed out?

Kindly advise and thanks a million
Brandon

[EvgenyT]

Brandon,

You're trying to write a string to a numeric cell hence you are getting an error. Fiscal_period being the last dimension in your cube determines type of cells in your cube and from the error you are getting, elements in fiscal_period dim are type "simple"

ET

[lotsaram]

To spell it out even more clearly. The data type conflict is not between the column type in the RDBMS and the TurboIntegrator variables mapping tab. It is between the string variable in TurboIntegrator and the cube cell you are trying to write to which is expecting a numeric value.

[Darkhorse]

Just put cellputs(''|youcol |'', etc

Should work then

[qml]

Just put cellputs(''|youcol |'', etc

Should work then

I am very interested to see how CellPutS can be used to write data to a numeric cell. Would you be so kind as to describe this trick in more detail? I'm always keen to add new undocumented 'hacks' to my portfolio.

[Darkhorse]

Just put cellputs(''|youcol |'', etc

Should work then

I am very interested to see how CellPutS can be used to write data to a numeric cell. Would you be so kind as to describe this trick in more detail? I'm always keen to add new undocumented 'hacks' to my portfolio.

Hi qml, he's not asking for numbers he's asking for strings to be loaded, I found ages ago when I used a + sign as a string to cellputs value it flagged this error something to do with it being a reserved word or something I'm pretty sure I fixed it with this methodology although if an MVP is questioning it I might go dig out that old TI and double check now

[tomok]

Hi qml, he's not asking for numbers he's asking for strings to be loaded

Exactly. He is attempting to load string data to a numeric cell in a cube. Can't be done. End of story.

[kiss351523]

You can use the function of CellIsUpdateable for your TI process debugs.

[lotsaram]

You can use the function of CellIsUpdateable for your TI process debugs.

I think this has been thoroughly gone over and the source of the OP's error is obvious. CellIsUpdateable wouldn't be of any use here so not sure what value you thought this might add.

[wissew]

NumberToString() inside the cellputs() should work.

[Alan Kirk]

NumberToString() inside the cellputs() should work.

Might be worth a re-read of the question, including the actual error message.