Insight (OBIEE) Tips | How to create a prompt and add a default date range

For more Eloqua Insight Resources, please visit: https://community.oracle.com/topliners/discussion/4470627/eloqua-insight-resource-page

Prompts are a great way to provide your users the flexibility of pulling reports that are unique to them. They also help with performance for large robust reports.

In this post we’re going to focus on how to create a prompt and add a default date range with SQL.

What is a column prompt?

A column prompt enables users to select specific values to populate a column in a dashboard or analysis; it is the selection of data you make prior to running a report.