Adding parameters to a data model enables users to interact with data when they view reports.
BI PublisherOracle BI Publisher supports the following parameter types:
Text - Enables entering a text string to pass as the parameter.
Menu - Enables making selections from a list of values. A list of values can contain fixed data that you specify or a list created using a SQL query that is executed against any of the defined data sources. This option supports multiple selection, a Select All option, and partial page refresh for cascading parameters.
To create a menu type parameter, define the list of values, and then define the parameter and associate it to the list of values. See Adding Lists of Values.
Date - Enables the user to select a date as a parameter. You must use the data type Date and the Java date format.
After defining the parameters in the data model, you can configure how the parameters are displayed in the report as a report-level setting. For more information about the report-level settings, see Configuring Parameter Settings for the Report in Report Designer's Guide for Oracle Business Intelligence Publisher.
Support for parameters varies based on the data set type. SQL Query data sets support the full set of available parameter features. Other types of data sets might support all, none, or a subset of these features. The table below summarizes the support for each data set type.
| Data Set Type | Parameter Support | Multiple Selection | Can Select All | Refresh Other Parameters on Change |
|---|---|---|---|---|
|
SQL Query |
Yes |
Yes |
Yes |
Yes |
|
MDX Query |
No |
No |
No |
No |
|
Oracle BI Analysis |
Inherited from Oracle BI Analysis |
Yes (using Oracle BI Dashboards) |
Yes (using Oracle BI Dashboards) |
Yes (using Oracle BI Dashboards) |
|
View Object |
Yes, provided that the view object supports and is designed for it |
No |
No |
Yes (view object parameters only) |
|
Web Service |
Yes |
No |
No |
No |
|
LDAP Query |
Yes |
No |
No |
No |
|
XML File |
No |
No |
No |
No |
|
Microsoft Excel File |
Yes |
No |
No |
No |
|
CSV File |
No |
No |
No |
No |
|
HTTP (XML Feed) |
Yes |
No |
No |
No |