Oracle CRM On Demand Dashboards- P10: There are many people I would like to thank as I sit here after having just penned the final chapter of this book. I am sure I will miss many specific people if I tried to list them all, but I am compelled to mention some specific supporters. | Chapter 7 Dashboard Filter Prompts 157 Server Variable LAST_WEEK_END_DT CURRENT_WEEK_BEGIN_DT CURRENT_WEEK_END_DT NEXT_WEEK_BEGIN_DT NEXT_WEEK_END_DT Sample Result TIMESTAMP 2010-03-27 23 59 59 TIMESTAMP 2010-03-28 00 00 00 TIMESTAMP 2010-04-03 23 59 59 TIMESTAMP 2010-04-04 00 00 00 TIMESTAMP 2010-04-10 23 59 59 https . com TABLE 7-5. Server Variables continued select this option another field opens up for you to enter a SQL query. Unlike the SQL statement you may have written in the Show field this SQL statement should return a single value to provide a default value for the column. Take the following SQL statement which returns the Account Name of the account with the maximum opportunity revenue SELECT Account. Account Name FROM Opportunity Lists WHERE Opportunity Metrics . Opportunity Revenue MAX Opportunity Metrics . Opportunity Revenue A simpler example is a SQL statement that defaults the Opportunity Close Date field with the most recent opportunity close date SELECT MAX Close Date .Date FROM Opportunity Lists Dashboards as Search Tools One of the most often-requested dashboards that I build for my customers is a custom search tool. With a well-designed dashboard filter prompt it is quite easy to provide your users with a sophisticated search tool. One thing that it is possible to do with a dashboard-based search that is not possible with the standard search function in Oracle CRM On Demand is a keyword search that is applied to multiple columns at once. This is achieved using the presentation variables. Compare for example the dashboard filter prompt shown in Figure 7-7 and the report filter shown in Figure 7-8. Notice that the Phone Number and Email fields in the dashboard filter prompt declare presentation variables. Those presentation variables are then called in the filters on three different phone number fields and two different e-mail fields. This allows the user to enter a portion of the phone number and
