Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
User_2J6P2
User_2J6P2 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

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?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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).