1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Visualize Data
  3. Create and Use Parameters
  4. Use Parameters in Workbooks
  5. Use an Analytics Link Data Action to Pass Parameter Values

Use an Analytics Link Data Action to Pass Parameter Values

You can create a data action to pass the selected parameter values to a canvas in another workbook.

This tutorial provides a use case explaining how to use a parameter in an analytics link:

Tutorial icon Tutorial

  1. On the Home page, hover over a workbook, click Actions (Actions menu ellipsis icon), then select Open.
  2. Click Menu on the workbook toolbar and click Data Actions.
  3. Click Add Action and enter a name for the new navigation link.
  4. Click the Type field and select Analytics Link.
  5. Click the Anchor To field and select the columns from the current visualization to associate with this data action. Don't select measure columns or hidden columns. If you don't specify a value for the Anchor To field, then the data action applies to all data elements in the visualizations.
  6. In the Target field, click the This Workbook field and select Select from Catalog and browse for and select the workbook that you want to use for the anchor.
  7. Click the Canvas Link field and select the canvas that you want to use.
  8. If you want to pass a filter value, then click the Pass Values field and select which values you want the data action to pass.
    • All - Dynamically determines the intersection of the cell that you click and passes all filter values for the selected data.
    • Anchor Data - Ensures that the data action is displayed at runtime, but only if the required columns specified in the Anchor To field are available in the view context.
    • None - Opens the page (URL or canvas) but no filter values are passed for the selected data.
    • Custom - Passes only user selected custom filter values for the selected data.
  9. Click the Pass Parameter Values field and select which parameter values you want the data action to pass.
    • All - Dynamically determines the intersection of the cell that you click and passes all parameter values for the selected data.
    • None - Opens the page (URL or canvas) but no parameter values are passed for the selected data.
    • Custom - Passes only user selected custom parameter values for the selected data.
  10. Click Supports Multiple Selection to set the value.
    • On - The data action can be invoked when one or multiple data points are selected.
    • Off - The data action can only be invoked when a single data point is selected.

      This setting is particularly useful when the selection of multiple data points might result in an error.

  11. Click OK to save.