Page 1 of 1
Pafe/PAW View - Auto Spread at Consolidated Level
Posted: Wed Oct 18, 2023 11:21 am
by chewza
Hi there
In the cube viewer, capturing in data at a consolidated level automatically spreads the data down. Do you know if there is any way to prevent this?
Regards
Chris
Re: Pafe/PAW View - Auto Spread at Consolidated Level
Posted: Wed Oct 18, 2023 11:29 am
by Elessar
Hi,
There are many options:
- Use CellSecurity to make consolidated cells 'READ"
- Use ElementSecurity to make consolidate elements 'READ" (better than point "1", because Elementsecurity is precalculated on SecurityRefresh, and CellSecurity is recalculated each time view is recalculated)
- Use CapabilityAssignments: https://blog.octanesolutions.com.au/wor ... ere-is-how
Re: Pafe/PAW View - Auto Spread at Consolidated Level
Posted: Mon Oct 23, 2023 3:36 pm
by ardi
And if you want to keep Spreading enabled for some of the users, you should consider turning OFF this option
ProportionSpreadToZeroCells=F
By default this is turned on and in my experience this is dangerous