Database Restrictions and Adding New Dimensions


There’s a big pain point I’ve ran into a number of times lately. It has to do with database restrictions and adding new fields in a database. Not sure if there’s an easier way to accomplish this or not.

We have a number of users with database restrictions in place. For instance, warehouse managers restricted to their warehouse, or territory managers restricted to their territory.

If we go in and change the design of a database - add a new dimension or measure for example, this new field is turned off by default for any user that already has a restriction in place. I then have to go to each user and edit their restrictions to turn on this new measure or dimension. This can become quite cumbersome.

Not sure of a solution, just wanted to point this out.


@aaron.roma Have you tried using Bulk Update under Admin->Users? Select multiple users, then go to “More” and “Bulk Update”. This makes it easy to change restrictions across multiple users at once. I came across this recently as we added new measures and properties, too.



I have tried it. The issue with that is that it blows away their existing restrictions. So while I can use the Bulk Update to add the new dimension to the users, they lose their restriction to their location/area/region, etc.