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

Question

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

Selvam Muthiah-Oracle · Answer

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.

Mallikarjuna Kuppauru-Oracle · Answer

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

Gianni Ceresa · Answer

(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?