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

Select Value Window Not showing all available values

Started by JHawke, 29 Apr 2019 03:24:31 PM

Previous topic - Next topic

JHawke

When creating a query filter, I use the Select Value window that gets populated with the available values.  My window is not showing all available values (e.g.  Not all sales territories are visible)  One of my co-workers creates reports using the same framework, and can see and use all of the territories, even the ones I cannot see in my view.  The missing territories are new this year.  Has anyone seen a similar situation?

MFGF

Quote from: JHawke on 29 Apr 2019 03:24:31 PM
When creating a query filter, I use the Select Value window that gets populated with the available values.  My window is not showing all available values (e.g.  Not all sales territories are visible)  One of my co-workers creates reports using the same framework, and can see and use all of the territories, even the ones I cannot see in my view.  The missing territories are new this year.  Has anyone seen a similar situation?

Is it possible there are security rules determining which values are returned for different users or groups? I'm wondering if this might be driven by your database login? Are you using the same db connection as your co-worker, or is every db connection logging in to the database as individual people or groups?

MF.
Meep!

JHawke

I don't know.  I have the question out to our IT department.  thanks for the tip.