Forum Stats

  • 3,853,696 Users
  • 2,264,256 Discussions
  • 7,905,434 Comments

Discussions

Common prompt for union report in OBIEE 11g

Hi,

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.

Thanks,

Milan

Tagged:
Christian Berg-0racle

Answers

  • Joel Acha
    Joel Acha Member Posts: 1,373 Gold Trophy
    edited Jun 4, 2018 5:16AM

    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 Member Posts: 13
    edited Jun 4, 2018 6:10AM

    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 Member Posts: 1,373 Gold Trophy
    edited Jun 4, 2018 6:50AM

    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:

    imagepastedImage_0.png

  • 2660624
    2660624 Member Posts: 13
    edited Jun 4, 2018 7:52AM

    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.

    pastedImage_0.pngpastedImage_1.png

    Thanks,

    Milan

  • Teresa Modesta
    Teresa Modesta Member Posts: 313
    edited Jun 4, 2018 9:00AM

    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!

  • Martin van Donselaar
    Martin van Donselaar Member Posts: 307
    edited Jun 4, 2018 9:06AM

    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.

    Christian Berg-0racle
  • Jerry Casey
    Jerry Casey Member Posts: 286 Silver Badge
    edited Jun 4, 2018 12:50PM

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

    pastedImage_0.png

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

This discussion has been closed.