Taking Advantage of Oracle Analytics Data Visualizations in Classic Dashboards

Many companies are still using Oracle Analytics Classic Dashboards and Answers (Classic) but would like to take advantage of some of the new visualizations that are available in Oracle Analytics Data Visualization (DV).  This can be easily accomplished by creating a visualization in DV an adding it to a dashboard page in OAC.  The visualization can also be filtered based on Classic dashboard prompts.

Below is an example of a Treemap visualization built in DV and is displayed on an OAC Classic Dashboard.

                   

Below are the steps needed to build this simple dashboard page.

1. Create the visualization in DV with no filters. Filters will cause issues if you are using Classic dashboard prompts. Save the visualization.

2. Create a new dashboard in Classic and add a Classic dashboard prompt and the visualization that you created in DV.  Be sure you select the canvas that you want to display.

    Once this is done, the dashboard is ready to go.   

 

3.  To test the filters, I opted to Select COMMERCIAL on Construction Type.  The DV data is now reflecting data for Task Suffix 0100 and Construction Type COMMERCIAL. 

An Important Note:  If you add canvases to the DV workbook, add them to the end.  Reordering the Canvas can impact what is displayed on the dashboard page.  In the screenshot below, I added a canvas to the DV workbook and moved it before the TreemapVis canvas.

 

When I go back to the dashboard that I created earlier, my List of Divisions canvas is displaying.

 

To fix this, edit the dashboard and change the view:

 

The dashboard is now displaying correctly: 

Good Luck and Happy Analytics!