What Are Parameters?
A parameter functions as a user-defined variable that holds and manages a current value or values that you want to use in multiple places in a workbook. Use parameters to dynamically manipulate the workbook's data.
- In workbooks and visualizations as column selectors
- In workbook titles and visualization labels
- In expression filters
- In workbook, dashboard, and visualization filters
- In calculations
- In Logical SQL expressions
- In a visualization's properties to conditionally show or hide the visualization
- In data actions
When you create a parameter, you can specify a value that Oracle Analytics uses to initialize the parameter's current value. You can specify a list of available and initial values for a parameter by manually entering the values or using a Logical SQL query.
When working with parameters, you can select multiple workbook parameters in the Parameters pane and perform actions on all the selected parameters at once. For example, you can delete, copy, or paste multiple parameters, add them to the selected visualization, or create dashboard filter controls. You can also drag the selected parameters to dashboard filter controls or to a visualization’s Filters drop target.
A parameter's scope is only within the workbook where you define it. You can't share parameters with other workbooks.
Workbook parameters can affect workbook initialization time, see About Workbook Load Performance.