What is a function of prompts in Oracle Analytics?

Prompts in Oracle Analytics are specifically designed to allow users to filter and refine their queries dynamically. By using prompts, users can customize the data that is displayed based on their input, which enables them to create more tailored reports and visualizations. This function enhances the user experience by offering flexibility—ensuring that users can extract relevant information based on specific criteria without needing to modify the underlying data model or SQL expressions directly.

When users select different options from the prompts, the queries are refined in real-time, which means that users do not have to re-run the query multiple times to find the data they are looking for. This capability highlights the role of prompts in enabling a more interactive and user-driven approach to data analysis, as users can drill down into specific subsets of data that are particularly relevant to their needs.