CellGetS errors in log file

Post Reply
User avatar
PavoGa
MVP
Posts: 617
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

CellGetS errors in log file

Post 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?
Last edited by PavoGa on Mon Apr 01, 2019 3:17 pm, edited 1 time in total.
Ty
Cleveland, TN
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: CellGetS errors in log file

Post 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')
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: CellGetS errors in log file

Post 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 :lol: ). Or the new CellValueN and CellValueS rules functions.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
PavoGa
MVP
Posts: 617
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: CellGetS errors in log file

Post 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.
Ty
Cleveland, TN
User avatar
PavoGa
MVP
Posts: 617
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: CellGetS errors in log file

Post 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. :lol:

Meant the CellValueS function as the error message I did manage to post correctly, obviously pointed out.

Have updated the original post.
Ty
Cleveland, TN
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: CellGetS errors in log file

Post by Wim Gielis »

Now it all makes sense :D
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply