Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Dashboard Prompt - Second Parameter Filters Based on the First Parameter Selection

Received Response
41
Views
3
Comments
Franklin Kennedy James
Franklin Kennedy James Rank 1 - Community Starter
edited Aug 13, 2024 5:31PM in Oracle Analytics Forum

We have created a new Dashboard Prompt with two individual prompts.

1.   Review Period

2.   Goal Plan Name

If we select the Review Period, the Goal Plan Names should be filter for the selected review period. But it’s not changing. 

Kindly support with some idea.

Attached the completed configuration steps.

dashboard prompt.docx


Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    (Assuming you are using OBIEE based on the category you posted in, and not having opened your attached file because I don't randomly download "Word" files from a public forum...)

    Did you try with using the "Limit values by" option in your prompt?

    image.png


  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi,

    You can refer below MOS doc -

    An Example of How To Create A Cascading Contrained Dependent Dashboard Prompt (Doc ID 1573682.1)


    Regards,

    Arjun

  • Selvam Muthiah-Oracle
    Selvam Muthiah-Oracle Rank 3 - Community Apprentice

    Hi ,

    Kindly check the tables/columns used in the prompt has the join or relationship in the RPD.

    Then do the  "Limit values by" suggested above should work.