Common prompt for union report in OBIEE 11g

2660624

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

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

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

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

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.

Thanks,

Milan

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!

Martin van Donselaar

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

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.