Multiple section parameter on OTBI Dashboard

Question

Hi Team,

We have three different sections on one dashboard page and two of section have prompts. We had requirement to add prompt to third section. However after adding the prompt to third section it is not filtering the data of 3rd section but affecting data of second section.

Can someone please help me here.

Regards

Nidhi

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25491/multiple-section-parameter-on-otbi-dashboard

Hi @Nidhi Chhajed,

Quick question:

* Are those prompts are same?
* Have you checked whether reports under section 3 are having 'Is-Prompted' enabled?

If you are using same prompt (or some of the columns are same) for section 2 & 3 then changing one might impact both. You can try using Presentation Variable to force using the dedicated value so that even if it is same column it should not impact both while changing one prompt value.

Hope this help.

Thank you.

Riyaz Ali-Oracle · Answer

Looks like new prompt is affecting the second section instead of correctly filtering the third section.

Try the below:

* Verify Prompt Scope:

Check if the prompt is properly assigned to the third section in the dashboard properties.

Ensure that the prompt targets only the relevant dataset linked to the third section.

2. Check Prompt Column Mapping

Validate that the prompt is mapped to the correct columns of the third section.

If it's using the same column or data source as the second section, it may be unintentionally affecting both sections.

3. Review Filtering Logic

Look at the filter conditions applied by the new prompt.

Ensure that the filtering does not overlap with other sections unless intended.

4. Verify Report Dependencies

If the third section’s report depends on data from the second section, the prompt might be influencing upstream filtering.

Try creating an independent filter exclusively for the third section.

5. Test with a Minimal Dashboard Setup

Temporarily remove the second section prompt and check if the third section filter works correctly.

If the issue disappears, reapply prompts one at a time to identify conflicts.

6.  Check Logical SQL & Data Model

Look at the logical SQL and data model used by each section.

Ensure that the data source joins are correctly structured to allow independent filtering.

7. Verify Dashboard Prompt Settings

In Dashboard Properties, check that the prompt mode is set to affect only the relevant section.

Ensure it isn’t set to filter globally across sections.

Provide the details of prompt configuration to analyze it further.