COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: John 27182 on 27 Jun 2011 11:29:15 AM

Title: Cannot see items in reviewer model.
Post by: John 27182 on 27 Jun 2011 11:29:15 AM
Hi all,

In our  contributor application we have Contribution e.List items and Reviewer e.List items (i.e. the "Reviewer" e.List items are the parent of the "Contribution" e.List items).

When I look at a contribution model my cubes have all the items I expect to see. However when I look at the reviewer model only a few of these items exist.

I don't think this is an access table thing, as the D-Lists in question doesn't have an access table conditional on e.List.

Can anyone help?
John
Cognos planning 8.3
Title: Re: Cannot see items in reviewer model.
Post by: ericlfg on 27 Jun 2011 08:41:27 PM
Hey John,

I think I understand what you're talking about, but I want to make sure I have it right.

Given this hierarchy:

+ Americas
- Brazil
- Canada
- United States
- Mexico

When you select Brazil, you see all the d-list members that make it up.  All the text and numeric fields.  When you select Americas, you don't see everything that you saw in Brazil?  Please see my screen shots to see what I'm talking about.  Top screen shot is the Reviewer node, bottom screen shot is the Contributor node.
Title: Re: Cannot see items in reviewer model.
Post by: John 27182 on 28 Jun 2011 08:33:45 AM
Hi Eric,

Yes, your interpretation of the problem is correct.

Thanks to your post I solved the problem now. I didn't realise that when an item had the "Force to zero" calc option selected, then it means that the item becomes "No data" in the reviewer e.List nodes. See the link below:

http://publib.boulder.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=/com.ibm.swg.im.cognos.contrib_admin.10.1.0.doc/contrib_admin_id7367ForcetoZero.html

Thanks for the quick response.
John.