OACS - Need Logic to exclude a Subject Areas from Analysis based on Prompt Values

Question

My analysis uses multiple unions of Subject Areas (Criteria)

e.g.

Subject_Area_1 Union Subject_Area_2

Each Subject Area is quite data heavy and the query takes a lot a time.

Would be great to know if there is a way to guide OAC engine to exclude a Subject Area  based on a Prompt Value?

Gianni Ceresa · Answer

Hi,

Welcome to the Oracle Analytics community and forum.

You can't directly impact the whole criteria unioned to another as an "object", but you can bet on the "smartness" of the BI Server for doing the job…

If a request contains a filter being something like 1 = 2 you can assume that this simply means that nothing will  ever be returned by that query, because nothing can make that condition true.

In the past (10 years ago) I was using that kind of logic to not let the a dashboard execute any query till a minimum number of prompts were configured with a value, and it did work.

Explore this kind of solution, setting a filter inside the piece of the criteria you want to exclude, that become an always false condition (and ideally not using any column of the subject area, just static values, meaning you would reference your prompt value via a presentation variable: if you use a subject area column, the query will still be sent to the database, even if that one will then see the always false condition and not do any work, but if you can avoid that it's even better).