In tm1 architect, consolidated cells are in grey, can not be edited directly, unless it's leaf cells are updated.
But in tm1web, those consolidated cells can be edited, once you input a value on it, it will apply some spreading rule on its leaf cells. It may be good to experienced user, but dangerous to inexperienced users, since they may accidentally input a value on those consolidated cells without knowing its effect.
How can I turn off this function in tm1web?
Regards,
Chris
How to disable change of consolidated cells in tm1web?
-
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
-
- Community Contributor
- Posts: 109
- Joined: Thu Feb 26, 2009 8:44 am
- OLAP Product: TM1
- Version: 9 + 10 + Plan An
- Excel Version: All
- Location: Isle of Wight, UK
Re: How to disable change of consolidated cells in tm1web?
You could set the C elements to Read, in dimension security:
http://www.tm1forum.com/viewtopic.php?f=3&t=9527#p44241
http://www.tm1forum.com/viewtopic.php?f=3&t=9527#p44241
"the earth is but one country, and mankind its citizens" - Baha'u'llah
-
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Re: How to disable change of consolidated cells in tm1web?
There are too many cubes and consolidated cells for me to set them one by one.
Is there a server parameter to set all consolodated cells un-editable?
Is there a server parameter to set all consolodated cells un-editable?