Oracle CRM On Demand Dashboards

Advanced Filter Prompts

Most dashboard filter prompts that you will build are simple, straightforward collections of column filter prompts that display at the top of your dashboards. Creating those is uncomplicated and does not require any knowledge of SQL. In this section, however, I describe some more complex dashboard filter techniques that do require the use of SQL and a little bit of creative thinking to develop advanced dashboard filter prompts. We will start by selecting the values that appear in the dashboard prompt and setting the default value using SQL queries. Next we will look at referencing presentation variables from other columns in these fields.

Showing SQl Results in Filter Prompt Fields

Let me begin by stating that this book ...