PAW - Attribute hierarchies, Element Security
Posted: Wed Aug 15, 2018 5:15 pm
I have a process which rebuilds attribute hierarchies overnight for 3 dimensions in my model.
HierarchyDestroy('DimName', 'AttributeName');
CreateHierarchyByAttribute('DimName', 'AttributeName');
What I am finding is, when the attribute hierarchy is created the default security against those elements will come through as NONE, therefore only an Admin can see the full 3 level structure (All Attribute Member -> Attribute element ->Child element). End users can only see the child elements they have access to.
Security for the attribute hierarchy element can be set manually via workspace, using the edit hierarchy -> Switch to member security mode option. However when the attribute hierarchy is rebuilt overnight the security gets cleared out.
Therefore, what I am looking to do is either write a security rule or a TI process to populate the element security for the attribute hierarchy. Is it possible to reference and ELLEV function against and attribute hierarchy element or use a cellputs against a attribute hierarchy element baring in mind they are not viable in architect?
Thanks in advance.
HierarchyDestroy('DimName', 'AttributeName');
CreateHierarchyByAttribute('DimName', 'AttributeName');
What I am finding is, when the attribute hierarchy is created the default security against those elements will come through as NONE, therefore only an Admin can see the full 3 level structure (All Attribute Member -> Attribute element ->Child element). End users can only see the child elements they have access to.
Security for the attribute hierarchy element can be set manually via workspace, using the edit hierarchy -> Switch to member security mode option. However when the attribute hierarchy is rebuilt overnight the security gets cleared out.
Therefore, what I am looking to do is either write a security rule or a TI process to populate the element security for the attribute hierarchy. Is it possible to reference and ELLEV function against and attribute hierarchy element or use a cellputs against a attribute hierarchy element baring in mind they are not viable in architect?
Thanks in advance.