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
Hi @User_SYYDG,
In OAC, you can use a 'Dashboard Prompt' with a Text Field as the user input.
The basic setup is:
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.
To prevent the table from automatically running/populating when the dashboard opens, you can use the 'Prompt Before Opening' option.
In OAC:
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.
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.
I do not see,,,,,,,,
Go to Tools —> Dashboard Properties
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.
I am using DV workbook. Is there a way to do this?
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
