This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
I would like to know whether it is possible to restrict the dimensions available in a cube sheet according to the user. For example, for a “Region” dimension, I have two values: North and South. I would like the North Region sales manager to be able to modify only the North region value in the cube sheet, so that he cannot change the sales budget for the South Region (which is not his responsibility).
Is this possible?
Current functionality does not include the ability to restrict dimensions based on user. A potential workaround would be to create your Sales Managers as Levels in the Organization Structure. Then assign the Level access to the Sales Managers and restrict Region by Level.