TM1 Forum

Hello everyone,

I found some similar post here on the forum but not exactly as my issue, here it goes:

I have a dimension with security and i set all consolidated elements with only read access to a group so they could only enter values in the 0 level.

I build my perspectives application and those users can enter values in the consolidated cells... Why is that possible if i set READ access in the dimension security?
This behaviour is strange and i must explain that they can enter values in the consolidated cells only when 0 level cells below that consolidated element have no values (zero value) because if some 0 level cell has value != 0 then users cannot enter value in the consolidated cell.

I think that is happening because when users enter value in the consolidated the spread function is called by tm1 and spreads values to the children, how can i stop that behaviour? In this link http://www-01.ibm.com/support/docview.w ... wg21457862 to disable ProportionSpreadToZeroCells but in my tm1s.cfg i dont have that function, how can i disable ProportionSpreadToZeroCells?

Thank you.
Kind Regards

M4rc05 wrote:In this link http://www-01.ibm.com/support/docview.w ... wg21457862 to disable ProportionSpreadToZeroCells but in my tm1s.cfg i dont have that function, how can i disable ProportionSpreadToZeroCells?

If you don't have that statement in your tm1s.cfg file then why don't you add it?????? The default tm1s.cfg file only has about 10% of the available configuration options in it. If you want any of the additional ones to have an effect on your system you have to add the statements to tm1s.cfg, save the file, and the recycle the service.

Not sure if that is a typo, you talk about "READ" in dimension security, have you enabled element security for that particular dim?

Hi people,

The ProportionSpreadToZeroCells=F made the wanted, now even if the children of a consolidation are blank (zero) it wont let user to set values it needed to be set in the tm1s.cfg.

Thanks tomok, as this is a tm1 on cloud 10.2.2 server (installed and confured by ibm) i was afraid to do so, but it works.

Thanks people.

If it was the cast that be setting element security to READ for the consolidation and
- if there was populated data already under the node then data entry via spreading was not possible
BUT
- if there were no populated cells then data entry was possible via spreading via the default even spread

Then this is certainly a bug and should be raised with IBM. Setting ProportionSpreadToZeroCells=F is what IBM support woudl refer to as a "local fix" and a developer/admin woudl refer to as a "workaround", that is something that you can apply to work around a bug but really you shouldn't have to.