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?
CellGetS errors in log file
- 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
Last edited by PavoGa on Mon Apr 01, 2019 3:17 pm, edited 1 time in total.
Ty
Cleveland, TN
Cleveland, TN
-
- 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
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')
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')
-
- MVP
- Posts: 3117
- 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
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.
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.
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
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
- 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
It's not a little confusing, it is a lot confusing. I meant the CellValueS function. Will update the post.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')
Ty
Cleveland, TN
Cleveland, TN
- 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
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.
Ty
Cleveland, TN
Cleveland, TN
-
- MVP
- Posts: 3117
- 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
Now it all makes sense
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
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