Sets level of security to an element on a hierarchy to non-admin groups.
SetHierarchyElementGroupsSecurity sets level of security to an element on a hierarchy to non-admin groups.
TurboIntegrator
SetHierarchyElementGroupsSecurity(SecurityLevel, DimensionName, HierarchyName, ElementName);
SecurityLevel = Level of security to be granted to all non-admin groups to a given dimension element.
DimensionName = Name of the parent dimension of the hierarchy
Hierarchy Name = Name of the parent hierarchy of the element to have security access set
ElementName = Name of the element to have the security set to all non-admin groups. There are 6 types of security:
– Admin
– Lock
– None
– Read
– Reserve
– Write
On the ‘Department’ dimension, use SetHierarchyElementGroupsSecurity to set READ access to the ‘No Department’ element from the ‘Department Name’ hierarchy.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book