Hi All
Needing some clarity here. I have had to take over some projects and on checking the rules I have seen on numerous occasions where there is a rule to set a value to zero (usually to ensure no one can capture a value in the cell). Now my understanding is that if that cell is not fed, then there is not a major issue, but if the cell is fed then there could be a huge overhead in terms of calculated cells having to be consolidated. Am I correct in saying that this is definitely not good practise to assign a zero value in a rule and to rather use different methods to ensure other values can't be in that cell.
I have always completely avoided assigning zero's unless absolutely necessary and only in small cubes. Just checking if my thinking here is right.
Rule set value to zero
-
- Posts: 7
- Joined: Wed Jun 03, 2020 12:04 pm
- OLAP Product: Tm1/Planning Analytics
- Version: 2.09
- Excel Version: 365
-
- MVP
- Posts: 3105
- 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: Rule set value to zero
I’m not sure if TM1 actually stores these feeders. Did you check this in the relevant }Stats cube ?
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: 616
- 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: Rule set value to zero
Feeders are independent of the value (or non-value) stored in the cell. Regardless of whether the cell is blank or zero, if it is fed, TM1 has to deal with the overhead slowing performance of the consolidations.
This is why feeder design is so important. There is nothing inherently wrong with storing the zeros as long as they are not fed. However, like you, I tend to avoid zeroes unless it is for the reason stated: to prevent user input for one reason or another and security management is not the best option. One additional bit of information is STET is supposed to perform slightly faster than storing a zero if the rule construct is a conditional, but you may already know that.
This is why feeder design is so important. There is nothing inherently wrong with storing the zeros as long as they are not fed. However, like you, I tend to avoid zeroes unless it is for the reason stated: to prevent user input for one reason or another and security management is not the best option. One additional bit of information is STET is supposed to perform slightly faster than storing a zero if the rule construct is a conditional, but you may already know that.
Ty
Cleveland, TN
Cleveland, TN
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Rule set value to zero
Fed cells are fed and take up memory, regardless of whether or not there is an actual value in the cube that has been fed. I am hesitant to declare it not to be best practice as there may be situations where it is the right answer. However, in most instances I would use STET instead of assigning a zero value unless the intent was truly to just lock a cell for input and I didn't feel like security was the right answer in the circumstance.
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Rule set value to zero
I tend to use the Global Security Overlays to block things that are not Group specific and cell security to open things that are Group specific and where input is expected.
If for example I do not want people to capture outside of my planning months on my rolling forecast scenario, I use the global overlay to block those areas first then worry about the planning periods and what is open or closed based on the Custodian's control.
If for example I do not want people to capture outside of my planning months on my rolling forecast scenario, I use the global overlay to block those areas first then worry about the planning periods and what is open or closed based on the Custodian's control.
-
- MVP
- Posts: 3105
- 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: Rule set value to zero
You should just put it equal to zero but not feed the cells.
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
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Rule set value to zero
Hi
As Wim says you should continue to use rules to set values to zero to prevent data entry, but you need to tune your feeders to avoid feeding them.
You can rely on security to prevent data entry. However, the issue there is that this will probably only block an end-user. It will not block an Admin user, or a TI process from writing to the cell. A rule setting the value to zero will, and if the business requirements are that no one should be able to enter a value into a particular combination then that is what the rules should do.
Regards
Paul Simon
As Wim says you should continue to use rules to set values to zero to prevent data entry, but you need to tune your feeders to avoid feeding them.
You can rely on security to prevent data entry. However, the issue there is that this will probably only block an end-user. It will not block an Admin user, or a TI process from writing to the cell. A rule setting the value to zero will, and if the business requirements are that no one should be able to enter a value into a particular combination then that is what the rules should do.
Regards
Paul Simon
-
- Posts: 7
- Joined: Wed Jun 03, 2020 12:04 pm
- OLAP Product: Tm1/Planning Analytics
- Version: 2.09
- Excel Version: 365
Re: Rule set value to zero
Awesome. Thanks guys. Definitely confirmed my thinking. Will need to play around with the feeders in these models as the zero cells were fed