Need help on the dimension security implementation in cube based drilldownreport

[chaitu2k12]

Hello All,

Need suggestions on the feasibility and also want to know about the ways through which we can enable security in the drill down report, which is driven by a Cognos power cube and the source for that power cube is a relational package.

The report output page has a summary data , where a particular column has 8 attributes/values, say A, B, C, D, E,F,G,H.
Each of these attributes from A to H can be drill down to 5 levels, like A1,A2, A3, A4, A5 etc. respectively.

so, the clause is , all users should be able to see the summary values of other attributes A,B,C,D,E,F,G,H.
But users belonging to one particular attribute say A ........should be able to drill down his own hierarchy like A1, A2, A3, A4, A5, But they shouldn't be having access to drill down other attributes like B1,B2,B3,B4,B5 etc.

How this can be arrived. Any suggestions are greatly appreciated.