You can use
parameters in calculations, display rules, filters, and
ranks. You can create, modify, and manage parameters using the
Data tab
in the left pane.
The following controls in the designer support parameters:
-
-
The button bar control or
drop-down list control accepts a character parameter.
-
The
slider (single-point only) accepts a numeric parameter.
Parameters can be used
with the following features in the designer:
calculations
calculated items and
aggregated measures allow parameters. Parameters are supported wherever it makes sense to have a numeric
or
character value.
a character or numeric parameter is supported wherever it makes sense to have a numeric
or character value. The
data source filter is a special case. Ordinarily, a
data source filter applies to all of the report objects on the canvas. However, if the data source
filter contains a
parameter, then the filter is not applied to the control that has that parameter assigned to
it.
ranks
for a
rank, the parameter can be included for the
n value
of the rank. It is supported for
Top Count or
Bottom
Count and
Top Percent or
Bottom
Percent.
URLs
parameters in a report URL can be modified. For example, suppose that you have the
following
URL for a report: http://host/SASVisualAnalyticsDesigner/?reportPath=%2FUser%20Folders%2Fsasdemo%2
FMy%20Folder&reportName=Parameterized%20Calculations%20DR&type=Report.BI&Origin%20Parameter=Europe&Cost%20of%20gas=3.35
The first parameter is called Origin Parameter
, which enables
you to specify a different country name. The second parameter is called Cost
of gas
, which enables you to specify different costs
to see how different gas prices change the report.
Note: A parameter cannot be used
to pass credentials. However, credentials can be used as the value
of a parameter.