Oracle Business Intelligence

Products Banner

Common prompt for union report in OBIEE 11g

Received Response


I have an union report using 3 different subject areas. For this report I have a common prompt coming from single subject area.

For prompt we have given the user to select the operator . In Report Filter  which is coming from same subject area as prompt is able to change the operator but other union reports which are coming from different subject area ,the operator is not changing in the filter when user select the different operator in prompt.

Is there any way we can solve this issue. All filters of the union report should change the operator as selected in the prompt.




  • Joel Acha
    Joel Acha ✭✭✭✭✭

    you need to change your prompt from a column prompt to a variable prompt and  use the variable prompt to populate a presentation variable which you'll then use to file the parts of your union analysis

  • 2660624
    2660624 ✭✭✭

    In variable prompt there is no option for Operator selection. Its only available for column prompt. Due to that I haven't used variable prompt.

  • Joel Acha
    Joel Acha ✭✭✭✭✭

    You create your dashboard prompt as a variable prompt and reference the presentation variable initialised bu the variable prompt in your filter where you can modify the operator as you require like this:


  • 2660624
    2660624 ✭✭✭

    Hi Joel,

    User wants to change the operator dynamically in the prompt and in variable prompt there is no option for operator change as its available in column prompt.




  • Teresa Modesta
    Teresa Modesta ✭✭✭✭

    I do not think you can achieve what you want with out of the box functionality without building a separate prompt to act as the prompt for what operator you want to apply and then making the filters in each of the parts of your query massively more complex by having the equivalent of this

    ({PromptOperator} = "Equal To / In" and  YourTable.YourColumn = {YourOriginalFilter}) or

    ({PromptOperator} = "Not Equal To" and  YourTable.YourColumn <> {YourOriginalFilter}) or .... you get the idea!

  • Think about your model. Is it really necessary to use union to put the Subject Areas together?

    Or can you identify Conformed Dimensions on which you can join the facts together?

    Unions are usually last resort, your model should be able to handle multiple fact querying.

  • Jerry Casey
    Jerry Casey ✭✭✭✭✭

    You can use a column prompt to set a presentation variable here:


    Then reference the presentation variable in the other subject area-filters of the union.