Cognos TM1 contributor

[Venki@1688]

I have an application , whose approval hierarchy has three levels and the approval hierarchy is one of the dimensions in all the three cubes.

Elements of the approval hierarchy

A,B,C,D,E,F & G

'A' is the top node and has 'B' & 'E' reporting to it and similarly 'B' & 'E' have their corresponding children 'C','D','F' and 'G' reporting to them. And we want to categorie them in 3 groups

1. Planners (C,D,F & G)
2. Planners and Reviewers(B & E)
3. Reviewer (A)

I have created 7 clients , one for each node and assigned the clients to groups accordingly and Cube level , dimension level and element level security are assigned to the groups in proper way.When assigning a client to the group 'Planners' , that client is able to able to plan for all other clients who has access to Planners group but my requirement is that
For example
Client name is XYZ and has been given access to Planners group but he should be able to plan only for node 'C' in the approval hierarchy.

Kindly give me suggestions on achieving this.

Thanks in advance

[anoops81]

assign different groups for planners , so that user XYZ has access only to Node C. Now XYZ will not be able to plan for other nodes.

[Venki@1688]

Thanks a lot.

I was wondering what was going wrong .. but then i analyzed the things and came to know about the fact.. so now i have create one group for each node of the approval hierarchy. But in one of the application i am about to design , there are 1400+ users !!!

[anoops81]

you might not need to create 1400 groups. Try to create it based on organization hierarchy or department structure or geography if any of these are available as a dimension in your application.

For example Department structure has element named "HR" so there will be a HR group and all HR people will be mapped to that group. They all will have same level of access.

[Venki@1688]

Thanks a lot ...