Other types of data sets may support all, none, or a subset of these features. SQL Query data sets support the full set of available parameter features. Support for parameters varies based on the data set type. For more information about the report-level settings, see the section 'Configuring Parameter Settings for the Report' in Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher. Once you have defined the parameters in the data model, you can further configure how the parameters are displayed in the report as a report-level setting. Note that the data type must also be 'Date' and the format must be Java date format. See Adding Lists of Values.ĭate - the user selects a date as a parameter. To create a menu type parameter, define the list of values first then define the parameter and associate it to the list of values. This option supports multiple selections, a 'Select All' option, and partial page refresh for cascading parameters.

A list of values can contain fixed data that you specify or the list can be created using a SQL query that is executed against any of the defined data sources. Menu - the user makes selections from a list of values. Text - the user enters a text string to pass as the parameter. For more information about Oracle (NYSE:ORCL), visit parameters to a data model enables users to interact with data when they view reports.īI Publisher supports the following parameter types: Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! it does not request for dynamically take the value from the SQL specified in LOV.In the 'General' tab, parameters are displayed and we need to enter a value.How To Schedule BI Publisher Report With Dynamic Parameter (Based On SQL)? Information in this document applies to any platform. Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and later

Fusion Applications - How To Schedule BI Publisher Report With Dynamic Parameter (Based On SQL)

Bi publisher add parameters