Monday, November 30, 2020

I Learned Something New - Dashboard Prompts on Embedded DV Project

It is fun when I learn something from one of my clients.

Prompts within a DV Project is currently limited to the Listbox.  But what if you would like to use the other Prompt types that are available within Analysis and Dashboards?  The simple answer...embed the DV Project on a Dashboard and use Dashboard Prompts.

Below is a simple project that forecasts sales and is filtered to Customer Segment.  

This post will show how to use Dashboard Prompts with a DV Project.


Create a Dashboard and embed the DV Project

 
Note that the Filters do not show up in the dashboard view.

 
 
Create a Dashboard Prompt from the same Data Set that the DV Project uses. 

 
Pick a column you wish to prompt for.


Select the User Input type and the rest of the prompt properties.

 
For the Check Box values I selected the the Customer Segments over using All Values.  For some reason even though there is a Customer Segment on every row a NULL is available to select.
 

The Preview of the Prompt shows my check boxes for Customer Segment.


Now time to add prompt to Dashboard
 


Here is the Prompt in action.


It should be noted that the prompt does not require a column be in the project filter.

1 comment:

  1. Wow, never explored this option. Thanks! Can you advise on whether we can select a default option in the prompt on DV same like in OBIEE? All our reports are built on DV and I can’t seem to find any solution

    ReplyDelete