Author Topic: filter - missing values  (Read 926 times)

Offline DuDo

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
filter - missing values
« on: 04 Mar 2011 06:34:05 am »
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?

Offline NimrodA

  • Full Member
  • ***
  • Posts: 24
  • Forum Citizenship: +5/-0
Re: filter - missing values
« Reply #1 on: 05 Mar 2011 03:32:56 pm »
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.