TM1 Forum

Data spreading is useful, but in its current implimentation downright dangerous too. The shortcuts that work in Excel as well as the cube browser are all too easily hit by accident, especially Clear.

I'd like to see more options for controlling if spreading can be used. Server side, option to disable spreading entirely, enable it only via the right-click menu, or enable fully including shortcuts (as now). Maybe even add the same options to the client, where the more restictive option (server or client) will always win.

Too often i have seen data changed where somene has missed the CTRL key when copying data. Yes, you can ask people to be more careful but key errors will always happen. I'd just like to see such minor errors have far less serious consequences.

Thoughts?

I think this would be great. We have already asked IBM for some control on their break back functionality. Our request did not go to the level of controlling menus and the like, but we were wanting some control of the feature (at least a server level toggle).

Bit of necromancy but given both A) I couldn't find reference to this functionality on the forum when I went looking following our upgrade and this is the first thread related to "disable spreading" so it might help someone else searching in the future and B) John H's long standing battle of over 10 years to disable spreading (including the config setting which never worked back in V9) meaning an accidental repost is unlikely to offend.

Disable spreading now finally works by setting "Deny" in the "Allow Spreading" field of Capability Assignments as per this link. Tested it on the web front end reasonably heavily and although you can't turn off for Admin, you can turn off for users.

Was a show stopper for us using the web interface for fear of users with butter fingers and after a decade of waiting on them disabling this functionality, it was nice to see it finally implemented

garry cook wrote:Bit of necromancy but given both A) I couldn't find reference to this functionality on the forum when I went looking following our upgrade and this is the first thread related to "disable spreading" so it might help someone else searching in the future and B) John H's long standing battle of over 10 years to disable spreading (including the config setting which never worked back in V9) meaning an accidental repost is unlikely to offend.

Disable spreading now finally works by setting "Deny" in the "Allow Spreading" field of Capability Assignments as per this link. Tested it on the web front end reasonably heavily and although you can't turn off for Admin, you can turn off for users.

Was a show stopper for us using the web interface for fear of users with butter fingers and after a decade of waiting on them disabling this functionality, it was nice to see it finally implemented

Haven't used that yet but sounds good and well overdue. I think we were all wondering when the Capabilities cube would actually start to DO something.
The new Cell Security concept with reduced dimensionality in 10.2 can also be very useful to control spreading on a cube by cube basis and the parameter ProportionSpreadToZeroCells is also useful.