How to overcome IN clause limitation in Analytics?

In analytics, whever we use In caluse in filetr condition, the default
value is 8192.

If we expect thevalue be more than 8192 then we can increase it by
setting the parameter
MAX_EXPANDED_SUBQUERY_PREDICATES = 16384; in NQSConfig.ini file.

But this definetely impacts performance.

In obiee, you can use write back as work around for this issue.