TM1 Forum

Does anyone know the setting (if it exists) to turn off the new "breakback" functionality feature in 9.5.2

basically enter a value in a total consol elemet in cube viewer and it spreads over children, nice feature but not ideal for all situations, especially when cube viewer totals are only differentiated by bold, therefore an unaware user can enter without understanding impact on child values

cheers

I haven't tested it, but I should imagine that if users have only read access at a consolidated level then this will prevent spreading. They will need to have write access.

Martin

Yes i think that will work, ...but was looking for a big fat switch to turn it off... or even better a switch per cube... cannot find anything on IBM site, was hoping it was a config file setting that had not made it to the user guide as yet, IBM the big machine it is...

trying to keep security on dim and elements to the minimum...

ProportionSpreadToZeroCells=F

Andy, are you sure that will work? Reading the doco makes me think it just addresses the problem of doing a proportional spread to zeroes. I think the OP actually wants to disable the functionality - I got caught out by it yesterday - you can just do a spread by typing into a consolidated cell and this can be done accidentally.

Is that new as well? I thought it was only the forcing of a repeat to empty cells. My bad.

Andy Key wrote:Is that new as well? I thought it was only the forcing of a repeat to empty cells. My bad.

It's not new in in 9.5.2 it was new in 9.5.0. Came out so that views in Contributor tabs would have familiar breakback functionality without having to prefix a "p".

Hi All,

I'm also looking for a rule/method to turn off breakback functionality in the web. I have tried the Capability Assignments and set "Consolidation TypeIn Spreading" to DENY for Admins but I'm still able to enter data into a consolidator in the web (while I'm an admin).

http://www-01.ibm.com/support/docview.w ... wg21696949

I then tried a simple rule (in }ElementSecurity_CostCTR cube) to prevent any entry into a consolidation in the cost centre dimension (hope I got this right):
[] = S: IF(DTYPE('CostCTR',!CostCTR) @= 'C', 'READ',CONTINUE) ;

This didn't work either, I'm still able to enter into a consolidated cost centre node in the web as an admin.
I then just tried to prevent all write access to see if it would have any effect:
[] =S: 'READ' ;

In all cases I have (unfortunately) been able to enter into a consolidated cost centre node in the web (as I am a TM1 admin).

Has anyone been able to turn this functionality off?

That's strange, "[] = S: IF(DTYPE('CostCTR',!CostCTR) @= 'C', 'READ',CONTINUE) ;" should work (if there is no WRITEs in cellsecurity). Did you refresh security after applying this rule?

Hi Elessar,

Yes I did refresh security. I just went in again now, resaved the rule, refreshed security and managed to enter into a consolidator in the web. I'd love to know how to stop this behaviour, would be great to have a config option to turn the 'feature' off.

thanks.

What version of TM1/TM1Web are you running? According that link from IBM, capabilities were added in 10.2.2 FP1. Are you having problems restricting spreading in TM1Web cubeviews, websheets, or both?

Hi BrianL,

I'm using TM1 10.2.2 with fixpack 3. We don't use web cubeviews much, mostly websheets but I am able to spread in both web cubeviews and websheets and I'd like to stop being able to spread (just into the consolidators) for both of them.

Have you tried applying a lock to the consolidated cells? I personally wouldn't do this but I believe that's going to be your only option to stop an admin.

Have you tried both the "Allow Spreading" as well as the "Consolidation TypeIn Spreading" capabilities?

I believe "Allow Spreading" is the only capability that can be denied to an admin.

Thanks for the suggestions guys.

BrianL, your suggestion worked - thank you very much.

Only the option of Denying "Allow Spreading" had any effect on an admin. With this set I cannot write to a consolidator (the field "Consolidation TypeIn Spreading" had no effect: whether it was set to Deny or left blank I was able to write to consolidators so I simply left it blank) so finally we are able to turn this 'feature' off for admins.
Much appreciated!

JamiseBondi wrote: Only the option of Denying "Allow Spreading" had any effect on an admin. With this set I cannot write to a consolidator (the field "Consolidation TypeIn Spreading" had no effect: whether it was set to Deny or left blank I was able to write to consolidators so I simply left it blank) so finally we are able to turn this 'feature' off for admins.
Much appreciated!

... which isn't that surprising. Changing security isn't going to have any effect on Admin users since security restrictions don't apply to Admin.

It's really great to have a solution to this problem - shame it's taken until 10.2.2 to get it sorted, though

Personally, I would prefer to have a tick box on either an application or (even better) a view to ALLOW breakback functionality (it should be disabled by default). Then I could design proper applications that are able to use the undobtedly powerful breakback functionality in those few situations where it's appropriate.

A bit like we used to be able to do in Cognos Planning?

Not really a shame. Ordinary users shouldn't be given admin rights and thus this is not a problem.