Before You Begin

This tutorial shows you how to apply a visibility parameter to a visualization that shows or hides the visualization based on meeting the visibility condition in Oracle Analytics.

Background

You use the show_hide_exact.dva workbook file to learn how to set the visibility parameter. You also use two different measures in a dashboard filter control to enable selecting a single measure and showing the related visualizations. You must set the visibility parameter's condition in each visualization to control whether the visualization is shown or hidden.

What Do You Need?

Import a Workbook

In this section, you import a workbook with sales and profit visualizations.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Page Menu Page menu icon, select Import Workbook/Flow.
  3. In Import Workbook/Flow, click Select File. In File Upload, select show_hide_exact_wbk.dva and click Open.
  4. In Import Workbook/Flow, click Import. When the message, Import successful displays, click OK.
  5. Hover over show_hide_exact_wbk, click Actions Actions menu icon, and then select Open.
  6. Click Edit Edit icon.


    Description of show_hide_exact_wbk.png follows
    Description of the illustration show_hide_exact_wbk.png

Create a Parameter

In this section, you a create parameter and a dashboard filter control so users can select a measure.

  1. Click Parameters Parameters icon.
  2. In Parameters, click Menu Menu icon and select Add Parameter.
  3. In Create Parameter, enter Measures in Name.
  4. Select Value from the Available Values list. Enter Sales in the Value field.
  5. Click Add Add icon, enter Profit in the Value field, and then click OK.


    Description of measures_param.png follows
    Description of the illustration measures_param.png
  6. Click Visualizations visualizations icon. Under Dashboard Controls, select Dashboard Filters dashboard filters icon, drag it to the canvas, and then release it above the profit visualizations.
  7. Click Parameters Parameters icon. Select and drag the Measures parameter to the dashboard filter control.
  8. Click Properties Properties icon. In the Label Font row, click Auto. Use the font size list to select 18 and click Bold.
  9. In Properties, click Filter Controls Filter Controls icon. In the Label row, click Auto and select Custom. In the Label field, enter Select a Measure.


    Description of meas_param_in_dshbd.png follows
    Description of the illustration meas_param_in_dshbd.png

Specify the Visibility for the Profit Visualizations

In this section, you set the visibility of each visualization using the visibility parameter.

  1. Select the Profit by Product Sub Category visualization and click Properties Properties icon.
  2. In the Visibility Parameter row, click None and select Measures.
  3. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Profit and click outside of the dialog.
  4. Select the Profit by Ship Date (Year) visualization, click Change Visualization Type Change Visualization Type icon and select Horizontal Bar Horizontal bar icon.
  5. In the Visibility Parameter row, click None and select Measures. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Profit and click outside of the dialog.
  6. Select the Profit by Customer Segment visualization. In the Visibility Parameter row, click None and select Measures.
  7. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Profit and click outside of the dialog.

Specify the Visibility for the Sales Visualizations

In this section, you set the visibility parameter for each of the sales visualizations.

  1. Select the Sales by Product Sub Category visualization. In Properties, click None in the Visibility Parameter row and select Measures.
  2. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Sales and click outside of the dialog.
  3. Select the Sales by Ship Date (Year) visualization. In Properties, click None in the Visibility Parameter row and select Measures.
  4. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Sales and click outside of the dialog.
  5. Select the Sales by Customer Segment visualization. In Properties, click None in the Visibility Parameter row and select Measures.
  6. Click Visibility Settings Visibility settings icon. In Measures, click the Condition list and select Exact Match. Click Sales and click outside of the dialog.
  7. Click Save Save icon.

Preview the Workbook

In this section, you review the visibility parameter's impact on the visualizations.

  1. Click Preview Preview icon.


    When the Measures parameter is set to All, the sales and profit visualizations aren't visible.

    Description of no_measure_selected.png follows
    Description of the illustration no_measure_selected.png
  2. In the Preview, click All under Select a Measure and select Profit.


    Oracle Analytics displays the profit visualizations.

    Description of preview_profit_vizs.png follows
    Description of the illustration preview_profit_vizs.png
  3. In the Preview, click Profit under Select a Measure and select Sales.


    Oracle Analytics hides the profit visualizations and displays the sales visualization. The canvas shows an empty area where the profit visualizations remain hidden on the canvas.

    Description of preview_sales_vizs.png follows
    Description of the illustration preview_sales_vizs.png

Eliminate the Empty Space

In this section, you duplicate the canvas to demonstrate how you can eliminate the empty space left by the hidden visualizations.

  1. Click Edit Edit icon. Click Save Save icon.
  2. Click Canvas 1 menu canvas menu icon and select Duplicate Canvas.
  3. Click Canvas 1 Copy menu canvas menu icon and select Rename. Enter Canvas 2 as the new name and click the check Rename canvas check icon.
  4. Click Canvas 2 menu canvas menu icon and select Canvas Properties. In the Layout row, click Auto Fit list icon, select Freeform, and then click OK.
  5. Use the handle Handle icon to move the Sales visualizations on top of the profit visualizations.


    Description of sales_on_profit_vizs.png follows
    Description of the illustration sales_on_profit_vizs.png
  6. Click Preview Preview icon. In Select a Measure, choose Sales.


    Description of sales_no_empty_canvas.png follows
    Description of the illustration sales_no_empty_canvas.png

Learn More