Page 1 of 1
CellGetS errors in log file
Posted: Fri Mar 29, 2019 7:47 pm
by PavoGa
Have used CellValueS in a few cubes and the rules work fine with the correct value returned, etc. However, when a TI reads a cell that is populated by a CellValueS rule, the server log has a WARN line with Too few arguments to CellValueS function a listing of the offending rule.
Have not been able to find anything out about this. Is anyone else used this function in lieu of DB() and, if so, seen the same messages in the server log?
Re: CellGetS errors in log file
Posted: Fri Mar 29, 2019 11:19 pm
by PlanningDev
Your statement is a little confusing.
CellGetS is only for use in TurboIntegrator. It would simply return the value of a cell based on the supplied cube and dimensions.
It shouldn't be able to be used in a rule. For rules you should be using DB().
If a TI is using CellGetS and you it says you have too few arguments it would generally mean you haven't supplied enough element names to return data from the cube. Example, your cube has 3 dimensions but in CellGetS you have only supplied 2 Example. CellGetS('Cube1', 'Element1', 'Element2')
Re: CellGetS errors in log file
Posted: Sat Mar 30, 2019 7:13 am
by Wim Gielis
What is the use of this exercise if I may ask ? The fact that using a function in a different context, for which it was not pretended, yields a warning instead of a clear error ?
Rather than doing this and if you have spare time to play with TM1, you would be better off comparing the RunProcess function to the ExecuteProcess function (in my humble opinion at least
). Or the new CellValueN and CellValueS rules functions.
Re: CellGetS errors in log file
Posted: Mon Apr 01, 2019 3:16 pm
by PavoGa
PlanningDev wrote: ↑Fri Mar 29, 2019 11:19 pm
Your statement is a little confusing.
CellGetS is only for use in TurboIntegrator. It would simply return the value of a cell based on the supplied cube and dimensions.
It shouldn't be able to be used in a rule. For rules you should be using DB().
If a TI is using CellGetS and you it says you have too few arguments it would generally mean you haven't supplied enough element names to return data from the cube. Example, your cube has 3 dimensions but in CellGetS you have only supplied 2 Example. CellGetS('Cube1', 'Element1', 'Element2')
It's not a little confusing, it is a lot confusing. I meant the CellValueS function. Will update the post.
Re: CellGetS errors in log file
Posted: Mon Apr 01, 2019 3:19 pm
by PavoGa
Wim Gielis wrote: ↑Sat Mar 30, 2019 7:13 am
What is the use of this exercise if I may ask ?
To attempt to massively confuse everyone who read the post.
Meant the CellValueS function as the error message I did manage to post correctly, obviously pointed out.
Have updated the original post.
Re: CellGetS errors in log file
Posted: Mon Apr 01, 2019 5:53 pm
by Wim Gielis
Now it all makes sense
