IBM Support

Hierarchy Security not being applied

Technote (troubleshooting)


Hierarchy Security was not being applied to a template , for all users, that should have been restricted based on permissions created.


Users, that should be limited, based on permissions created, were still able to see all members of the restricted dimension


Node to implement HS was not added to the template

<Profile Name="name of profile" />

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:

<Profile Name="name of profile" />

"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.

Document information

More support for: Clarity 7
Clarity Server

Software version: 7.0, 7.2, 7.2.1

Operating system(s): Windows

Software edition: All Editions

Reference #: 1622299

Modified date: 14 January 2013