If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cannot see items in reviewer model.

Started by John 27182, 27 Jun 2011 11:29:15 AM

Previous topic - Next topic

John 27182

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

ericlfg

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.

John 27182

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.