TI process error returning false error
Posted: Wed Apr 29, 2015 7:45 am
Hey guys,
Just thought I would post a discovery we (as in my TM1 team) came across yesterday.
We ran a TI which retuned an error "Cell type is consolidated". Fair enough we thought, but the line it took us to used the function "CellIsUpdateable" and when we placed an ASCIIOUTPUT inside the condition which tested for updateable cells, the ASCIIOUTPUT did not get created. Very strange we thought, we also tested the data that was going into a CellPutN function...and all the arguments were at N level.
After hacking away we found the Number that was going into the CellPutN function was calculated via a division. The operator that was being used was /. We instead changed that to a \. It then worked.....
We checked out CSV file and the / operator was dividing a number by 0 which, will create infinity, which in TM1's eyes is not a real number.
This proves that the error "Cell type is consolidated" was a downright misrepresentation of the actual error, which was the use of \ being used against a 0.
So, our conclusion is that when the / operator uses a zero and initializes the result into a variable, with that variable going into a CEllPutN will return an error message which is not the true representation of the actual error.
Has anyone else bumped into this before? It was very strange and misleading.
Thanks.
Trevor.
Just thought I would post a discovery we (as in my TM1 team) came across yesterday.
We ran a TI which retuned an error "Cell type is consolidated". Fair enough we thought, but the line it took us to used the function "CellIsUpdateable" and when we placed an ASCIIOUTPUT inside the condition which tested for updateable cells, the ASCIIOUTPUT did not get created. Very strange we thought, we also tested the data that was going into a CellPutN function...and all the arguments were at N level.
After hacking away we found the Number that was going into the CellPutN function was calculated via a division. The operator that was being used was /. We instead changed that to a \. It then worked.....
We checked out CSV file and the / operator was dividing a number by 0 which, will create infinity, which in TM1's eyes is not a real number.
This proves that the error "Cell type is consolidated" was a downright misrepresentation of the actual error, which was the use of \ being used against a 0.
So, our conclusion is that when the / operator uses a zero and initializes the result into a variable, with that variable going into a CEllPutN will return an error message which is not the true representation of the actual error.
Has anyone else bumped into this before? It was very strange and misleading.
Thanks.
Trevor.