Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Refreshing one prompt based on other prompts selected

Received Response
41
Views
9
Comments
Deepak_R-Oracle
Deepak_R-Oracle Rank 3 - Community Apprentice
edited August 2024 in Oracle Analytics Cloud and Server

Hi Guys,

I have a report which has variable prompts and i need to have one more prompt which is also a variable prompt but this should be filtered based on what user selects for prompt1, I have used sql query something like this SELECT BLA_BLA s_2 FROM subject_area WHERE ("Time Dimension"."Month Name" IN ('@{P_Q1}'))

P_Q1 is the presentation variable which will get set from the first prompt, even after user selects the first prompt second prompts isn't populating any data, Any help would be greatly appreciated.

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    You can use a single dashboard prompt that is separated into two pages.  Set the value of P_Q1 on the first page, and use that value in the SQL of the second page prompt.

    When the user hits "Apply", then "Next" on the first page, the value of P_Q1 will be passed to the second page.

  • Deepak_R-Oracle
    Deepak_R-Oracle Rank 3 - Community Apprentice

    Thanks Jerry for the response, However how can we split single dashboard prompt between two pages?? Seems something new for me.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    He means two distinct prompt objects.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    This icon will insert a page break in your prompt"

    pastedImage_0.png

    The prompt will then look like this:

    pastedImage_1.png

    When the user makes a selection, they must click on "Apply", then "Next".  They'll see your second page:

    pastedImage_2.png

    A variable set on the first page will pass to the second page.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Right, that works too

  • Deepak_R-Oracle
    Deepak_R-Oracle Rank 3 - Community Apprentice

    Thank you, Worked like a charm.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Glad it works for you.

    One thing I should have mentioned is, that I haven't tested whether the user actually has to hit "Apply" on the first page, or whether they can just hit "Next".
    It seems like the buttons appear in the wrong order if they have to hit both.

  • Deepak_R-Oracle
    Deepak_R-Oracle Rank 3 - Community Apprentice

    If the user clicks next it is enough the variables get set and one more thing if we keep some prompt as mandatory in the second page it makes apply button to grey out in the first page by which we can have only one apply button at the second page.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Sorry, "404...", but I don't have the option of marking your reply "helpful", because my last question wasn't on my own thread.

    (you might consider changing your user name)