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

filter - missing values

Started by DuDo, 04 Mar 2011 07:34:05 AM

Previous topic - Next topic

DuDo

I'm creating a report in query studio.  When I pull a data field into the report and apply a filter, it truncates the list of values.  For example, I have a list of a couple hundred codes, which are alphabetized, and when I filter it only shows A through part of P.  When I run the report I can see the full list of values from A-Z.  How can I see the missing values in the filter list?

It also seems like I'm missing some data values that should be in the list.  When I search for certain valuesthey don't show up.  How can I tell where the data package is being pulled from, how often it's updated, etc. etc?

NimrodA

1. On the left hand side, under "Manage File", click "My Preferences" make sure your default data display is "Run with all data". Note that this is a bad practice - while forming a report, it's better to pull some data or no data at all so as to not burden the system.
2. Your system manager - whoever created the models - will probably know what exactly is in the model and when do ETL processes happen.