nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How to use a textbox field in a dashboard filter

User_SYYDG

So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens????

I am in OAC

Find more posts tagged with

OAC

Accepted answers

All comments

Bhaskar Konar

Hi @User_SYYDG,

In OAC, you can use a 'Dashboard Prompt' with a Text Field as the user input.

The basic setup is:

Create a Dashboard Prompt and select the column you want to filter.
Set the user input type to Text Field.
Add the prompt to your dashboard.
In the analysis/table, create a filter on the same column and set the filter operator to is prompted.
When the user enters a value in the text box and clicks Apply, OAC uses that value to filter the analysis.

For example, if the prompt is based on 'Customer Name' the analysis should have a filter on 'Customer Name' with the operator 'is prompted'.

One thing to keep in mind is that the value entered in the text box needs to match the underlying data value, depending on how the prompt/filter is configured. If you need partial matching (for example, entering part of a customer name), the prompt/filter may need to be configured differently.

Hope this help.

Thank you.

Bhaskar Konar

Hi @User_SYYDG,

To prevent the table from automatically running/populating when the dashboard opens, you can use the 'Prompt Before Opening' option.

In OAC:

Open the dashboard in Edit mode.
Go to Tools —> Dashboard Properties.
Select the dashboard page.
Enable Prompt Before Opening.
Save the dashboard.

With this option enabled, OAC will prompt the user for the required filter/prompt values before running the analyses on the dashboard page.

If you also want the user to enter a value in the text box and then explicitly click 'Apply', please make sure the prompt is configured to 'show the Apply button'.

This prevents the table from immediately executing with no filter value when the dashboard is first opened.

Hope this help.

Thank you.

Bhaskar Konar

Hi @User_SYYDG,

For additional details, Oracle has a helpful article explaining the Prompt before Opening feature, including how it can prevent unnecessary report executions and improve dashboard performance:

https://blogs.oracle.com/analytics/oracle-analytics-best-practices-use-prompt-before-opening-for-landing-on-a-dashboard

The article also explains how to configure the Apply buttons if you want users to enter prompt values and then explicitly apply them.

Hope this help.

Thank you.

User_SYYDG

I do not see,,,,,,,,

Go to Tools —> Dashboard Properties

Gianni Ceresa

Tools → Dashboard Properties is a "classic" setting.

OAC (just like OAS) has both DV workbooks and "classic" dashboards, and historically the word dashboard reference the "classic" object.

A DV workbook combines dashboard, pages and analyses into a single object, and for this reason some call it dashboard or report.

If in your question you mention "DV workbook", you avoid the confusion of answers covering "classic" dashboards. Or at least "DV", to make it obvious you aren't working with "classic" objects.

User_SYYDG

I am using DV workbook. Is there a way to do this?

User_SYYDG

Yes DV Workbook

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80