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

Filtering in Query Studio

Started by brosvall, 24 Apr 2007 12:03:18 PM

Previous topic - Next topic

brosvall

I am trying to filter out a bad record when running Query Studio. Is there anyway to setup a "not equal  to" filter?  (ie bundle NE 38002740)

Also I tried to filter out the bad data (2004 record) by selecting only 2007 data however the query still gives an error "A freeform number is invalid".  Does this make sense or is it just a coincidence?

yerapat

yes, first set up the filter you want as a not (not a must but easier to explain if you do this first) go to edit data (in your menu) then click Combine Filter. then select the filter you created and click "apply NOT"