Capability assignments
Certain capabilities for each user group can be set with the Capability Assignment menu.
Each capability can be set to either grant or deny for each user
group. The capabilities are:
- RunServerExplorer, enables the user group to use the Server Explorer. The choice to grant this capability enables access to the Server Explorer.
- UsePersonalWorkspaceWritebackMode, defines
how data changes are handled in the user group.
When granted, users can hold data changes in a private workspace before manually deciding when to commit the changes to the base data. Users can also create and manage multiple private scenarios called sandboxes (see the Sandbox Capability).
- Users can privately adjust data values before making them available to the rest of the community. The sandbox makes it easy to try out different data changes without the complexity of named sandboxes.
- New data displays in a different color to data that is part of the base data. After the data change in a Personal Workspace is committed, the cell coloring reverts to black to identify it as part of the base data.
- Users must manually commit their data changes to make them available to other users.
- Personal Workspace mode can improve performance over working in direct writeback. Changes to the base data occur less frequently than when every data change must be merged to the base.
When denied, users have to work directly in the base data. This is the default behavior for this capability. The advantage to this capability setting is that data changes happen immediately.
- UseSandbox, the user group can create named sandboxes that can be used to build what-if scenarios.
- ManageDataReservation, a server-related feature that allows you configure an exclusive write access to regions of a cube for individual users. Once reserved, the data in that region can only be modified by that specific user until the reservation is released.
- DataReservationOverride, a server-related feature that allows members of a user group to override data reservation for themselves and other users.
- Consolidation TypeIn Spreading enables users in clients to perform spreading actions from a consolidated cell that is the target of a rule. If this capability is set to Deny, users are prevented from typing in a consolidated cell that is the target of a rule. You might want to set this capability to Deny if there is a risk that typing in a consolidated cell might cause a large spreading action, which could potentially cause performance issues. However the user can still manually select a data spreading action from the context menu (right-click in a consolidated cell and select Data Spread). The admin user cannot be set to Deny.
- Allow Spreading, gives users access to spreading functions. This can be set to Deny or Grant for the admin user.
The capabilities for UsePersonalWorkspaceWritebackMode and UseSandbox work together as follows:
| To let the user group | Use Personal Workspace Writeback Mode | Use Sandbox Mode |
|---|---|---|
| Work directly in the base data with the ability to create more than one sandbox. | Deny | Grant |
| Work in a single, private work area without named sandboxes. | Grant | Deny |
| Work with a private work area and a named sandbox. | Grant | Grant |
| Work in Direct writeback with no sandbox. This prevents the use of sandboxes and puts all users into direct writeback mode. | Deny | Deny |