Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to create filter with presentation variable and choose operator as Is Prompted

Received Response
71
Views
2
Comments
Hari S
Hari S Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

I am currently working on a requirement where I need to create two parameters, one of which is dependent on the other. To achieve this, I’ve used a Presentation Variable and the functionality is working as expected when it comes to prompting for values.

However, I am facing an issue when trying to add the presentation variable to a filter condition in an analysis. Specifically, I am unable to select the “Is Prompted” operator for the filter. The presentation variable does not appear to be available for this option.

Could you kindly assist in guiding me on how to properly add a presentation variable filter and select the “Is Prompted” operator? I would like the data in the analysis to vary based on the value selected for the presentation variable.

Tagged:

Answers

  • gclampitt
    gclampitt Rank 6 - Analytics Lead

    You don't need to use "is prompted":

    Create a filter on the required column > Add more options > select presentation variable and enter the name of the variable.

    So if your filtering on say a Year column and your pres variable is called "Var_year", then your filter will then look like:

    Year is equal to / is in @{Var_year}

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    To achieve your requirement "have prompt list of values filter by existing selections in another prompt"

    consider 2 options

    1. Do not use presentation variables. In your prompt use the native linked list functionality "Limit Values by". In your analysis filter continue to use "is prompted". This is the very much easier option.
    image.png

    2. If you use presentation variables then I assume that means you have edit the prompt property choice list values from "All Column Values" to some sort of custom SQL to limit a list by the value in the variable? If so then in your analysis you can no longer use "is prompted" because the column in your prompt no longer matches the column in your analysis. In your analysis you need to reference the presentation variable in your where clause.

    image.png 
    "Assignment Absences Details"."Absence Status" IN (@{p_presentation_variable}{'Unspecified'})