![bi publisher add parameters bi publisher add parameters](https://miro.medium.com/max/1400/1*M7KX6UUW9Irp8Qu8HwBZtQ.png)
Navigate to the dashboard that contains the parameterized report and click the Edit Dashboard toolbar button. "Sample Sales Lite"."Time"."More Time Objects"."Day of Week"Ĭlick the Save Prompt toolbar button to save the prompt to the catalog in a shared folder.
![bi publisher add parameters bi publisher add parameters](https://4fo2us7kt553v05au2su1867-wpengine.netdna-ssl.com/wp-content/uploads/2018/01/image1.png)
If the column is in a nested folder, list all folders. "Sample Sales Lite"."Time"."Per Name Year"
![bi publisher add parameters bi publisher add parameters](https://image.slidesharecdn.com/datamodeldesignslideshare-140330082833-phpapp02/95/bi-publisher-11g-data-model-design-document-16-638.jpg)
"Subject Area Name"."Folder Name"."Column Name" If the BI Publisher report was created using a direct connection to a subject area, specify the value of the variable using the following format: Make the data type of the parameter match the data type of the column, if they are not based on the same database column. When using variable names in prompts, ensure that you spell them correctly and adhere to case-sensitivity. Set the Operator field to is equal to/is in.ĭefine a presentation variable with the exact same name as the parameter from the report. If the BI Publisher report was created using a direct connection to a subject area, make sure that you select the same column that you selected in the BI Publisher report.įor more information on creating prompts, see Chapter 6, "Prompting in Dashboards and Analyses."Ĭomplete the "New Prompt: Column dialog" and click OK. In the "Definition pane", click the New button, select Column Prompt, then select a column to use for the prompt. Select either the subject area that includes the columns from the report or a subject area whose columns closely match those in the report. In the global header, click New, then Dashboard Prompt. Set a default value for each required parameter so that the report displays correctly without user interaction.Ĭreate a new column prompt for each parameter by following these steps: In BI Publisher, open the report and locate the parameters that it uses. To use prompts with parameterized reports: For more information on creating a report using a direct connection to a subject area, see "Creating Reports Using a Direct Connection to a Subject Area" in Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher.
Bi publisher add parameters full#
This type of report supports the full range of prompt expressions.Ī BI Publisher report that was created using a direct connection to a subject area. For this report, you must have the report columns to filter on set to "Is Prompted" in the analysis. The BI Publisher report can be either of the following:Ī BI Publisher report that receives its data from an Oracle BI EE analysis. You can use prompts to filter the results of embedded parameterized BI Publisher reports to show only results that match the prompt criteria. Optionally, schedule the dashboard with an agent, as described in Chapter 8, "Delivering Content." If required, add a prompt to the dashboard page to filter the results of an embedded parameterized report, as described in "Using Prompts with Parameterized Reports". The "BI Publisher Report Properties dialog" is displayed.Ĭomplete the fields in the properties dialog as appropriate. To do so, hover the mouse pointer over the object in the Page Layout area to display the object's toolbar, and click the Properties button. To add a report from a dashboard page, select the report from the folder that contains its dashboard in the Catalog pane. Select the report from the Catalog pane and drag and drop it into a section on the dashboard page. Select a report in one of the following ways: Navigate to the page to which you want to add a report. For information, see "Editing Dashboards".