Edit at a Roll Up Level

[Danno]

We have been plagued by an issue since Cognos was implemented here by IBM. When we are at a rollup level in Contributor, using Review rights, we are able to edit values at that roll up level and it would break back to the children.

My question is two-fold: should you be able to edit at the roll up (parent and grandparent) levels as a reviewer thus making this a perception issue? How can you prevent editing at this level? 

I have Reviewer Edit turned off and all rights are set to Review at a Rollup level and submit at the child levels.

We are using Cognos 10.1 on Windows 2008 SP2 32 bit using an IHS (Websphere) gateway. The DB is Oracle 11.2. This is a planning only Budget type application.

Any help would be appreciated.

Dan

[ericlfg]

Hey Danno,

To confirm you're referring solely to the e-list roll-up hierarchy rather than d-list member roll-up hierarchies?

From an e-list perspective you should not be able to physically modify the parent, grandparent, great grandparent, etc. items.  Since these items are derived from the detail level items all cells in this node should be greyed out and cannot be modified.

From a d-list perspective, the Edit, Review, and Submit rights (with Allow Reviewer Edit for Review and Submit) will allow someone to take ownership of a node and make any modification they want to open cells.  Access tables, d-links, etc. will grey out certain cells.  Specifically with breakback, it needs to be disabled in the CAC to prevent it and it is cube specific but applies to the entire application.

As a reviewer or submitter, the only instance where you can take ownership of a node (child) and manipulate it's contents is if you have the Allow Reviewer Edit option enabled.

Hopefully that makes sense?

[Danno]

That makes perfect sense and yes, I was talking about elists rather than the dlists   :)

I just disabled the Breakback on one of the affected cubes and that solved the issue. Now I just have to make sure that the business can live with that and I think they will.

Thank you very much.
Dan