I am trying to assist a colleague in limiting a very large data set with via the on-demand settings and need to know if there is a way to limit it when a value is not equal to something.
In the table in question there is a constant string value ("noflag") that is used to identify data that is not necessary for use in capacity determinations. Being able to set an on-demand criteria that only loads data when that field is not equal to "noflag" would provide a considerable boost in performance (eliminates millions of rows of data from being loaded).
I cannot figure out how to limit using a negative criteria (not equal to). Is there any way to accomplish this?