Technote (troubleshooting)
Problem(Abstract)
Hierarchy Security was not being applied to a template , for all users, that should have been restricted based on permissions created.
Symptom
Users, that should be limited, based on permissions created, were still able to see all members of the restricted dimension
Cause
Node to implement HS was not added to the template
<Security>
<Profile Name="name of profile" />
</Security>
Diagnosing the problem
Confirmed that the template they were accessing, through the Menu, was actually the template they had modified, with the instructions to implement HS.
There are a couple of options in terms of confirm this:
1) Administration>Security Services>Menu Administration: check the location of the template/report in question
2) Right -click either the My Templates or My Reports menu option in Clarity, choose View Source, Ctrl-F (Find), find the template or report , and then find the corresponding href path
Resolving the problem
Added the following Node to the template in question:
<Security>
<Profile Name="name of profile" />
</Security>
"name of profile" was replaced with the actually name of the profile that was created for HS
This code was added within the OlapMemberQuery node for the dimension to which HS was required to be applied to. It was added between the </Members> and <Condition> tags.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.