How to disable change of consolidated cells in tm1web?

Post Reply
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

How to disable change of consolidated cells in tm1web?

Post by wang_chris »

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
iansdigby
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?

Post by iansdigby »

You could set the C elements to Read, in dimension security:

http://www.tm1forum.com/viewtopic.php?f=3&t=9527#p44241
"the earth is but one country, and mankind its citizens" - Baha'u'llah
wang_chris
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?

Post by wang_chris »

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?
Post Reply