Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) E10544-01 |
|
![]() Previous |
![]() Next |
This chapter describes conditions and explains how you work with them. It contains the following topics:
"Using Conditions to Determine Whether Agents Deliver Their Content or Execute Their Actions"
"Using Conditions to Determine Whether Action Links Are Displayed in Dashboard Pages"
"Using Conditions to Determine Whether Sections Are Displayed in Dashboard Pages"
"Editing, Customizing, Testing, Saving, and Disabling Conditions Used in Agents"
"Editing, Testing, Saving, and Removing Conditions Used in Action Links in Dashboard Pages"
"Editing, Testing, Saving, and Removing Conditions Used in Sections in Dashboard Pages"
Conditions are objects that return a single Boolean value based on the evaluation of an analysis or of a Key Performance Indicator (KPI).
What a condition evaluates depends on whether it is based on an analysis or on a KPI, as follows:
For an analysis, it evaluates the row count of the analysis.
For a KPI, it evaluates the status of the KPI.
For example, a condition might evaluate whether the results of an analysis return a number of rows greater than 0:
If the analysis returns at least one row, then the condition evaluates to true.
If the analysis does not return any rows, then the condition evaluates to false.
You use conditions to determine whether:
Agents deliver their content and execute their actions
Actions links (which when clicked run actions) are displayed in dashboard pages
Sections and their content are displayed in dashboard pages
For example, a sales manager wants to deliver a Monthly Sales Report to his direct reports only when sales drop below $2 million. You might create a condition that is based on an analysis that shows sales that are below $2 million and add it to an agent whose delivery content is the Monthly Sales Report. When the condition evaluates to true (that is, the analysis contains rows where sales are below $2 million), the agent will be triggered to deliver the Monthly Sales Report.
You can also use a different kind of condition to determine whether action links are enabled in analyses. For information, see "About Conditionally Enabling Actions Added to Analyses".
A condition consists of the following elements:
An analysis or KPI.
The criteria to use when evaluating the condition:
For an analysis, the criteria is a row count and an operator to apply to the row count; for example, the row count is equal to 100.
For a KPI, the criteria is a KPI status, for example, the KPI status is OK.
Values for any prompted filters that are associated with the analysis or values for KPI dimensions that were set to Set in watchlist in the KPI.
A named condition is a condition that you define and then save by name in the Oracle BI Presentation Catalog so that you can reuse it in agents and dashboard pages.
You create a named condition when you create a new condition from the:
New menu in the global header by selecting Condition under Analysis and Interactive Reporting
Home page by clicking the More link under Analysis and Interactive Reporting in the Create area and selecting Condition
You also create a named condition from the "Agent editor: Condition tab" when you save an inline condition to the catalog. For information on inline conditions, see "What Are Inline Conditions?"
An inline condition is a condition that you define at the point of use and do not save by name in the catalog. Instead it is saved as part of the dashboard page or agent.
An inline condition is automatically deleted when the dashboard page or agent that contains it is deleted. This simplifies catalog management for conditions that make sense only within particular Oracle BI content.
You can create an inline condition when you:
Create or edit an agent and specify (in the "Agent editor: Condition tab") that the agent is to deliver its content and run associated actions conditionally. See "Using Conditions to Determine Whether Agents Deliver Their Content or Execute Their Actions".
For information on creating agents, see "Creating Agents".
Add an action link to a dashboard page and specify that the action link is to be displayed conditionally. See "Using Conditions to Determine Whether Action Links Are Displayed in Dashboard Pages".
For information about adding action links to dashboard pages, see "About Adding Actions to Dashboard Pages".
Add a section to a dashboard page and specify that the section is to be displayed conditionally. See "Using Conditions to Determine Whether Sections Are Displayed in Dashboard Pages".
For information about adding sections to dashboard pages, see "Adding Content to Dashboards".
Generally:
Administrators create the named conditions for an organization, which are then used by content designers (providing they have the appropriate permissions to the conditions or the folders in which the conditions are saved) as they create dashboards and agents.
The ability to create or edit named conditions is controlled by the Create Conditions privilege, which is managed by the administrator.
Content designers create inline conditions.
For information about privileges, see the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
For information about permissions, see Chapter 13, "Managing Objects in the Oracle BI Presentation Catalog."
You can create named conditions that you can reuse in agents and dashboard pages. See "What Are Named Conditions?"
To create a named condition:
In the global header, click New and then select Condition.
The "New Condition dialog" is displayed.
Complete the New Condition dialog. For more information, see "Specifying the Settings for Conditions".
You can use conditions to determine whether agents deliver their content or execute their actions. For information on agents, see Chapter 8, "Delivering Content."
To use a condition to determine whether an agent delivers its content or executes its actions:
Edit the agent.
Click the "Agent editor: Condition tab".
Select the Use a condition box.
If you want to:
Create a new condition, click Create to display the "Create Condition dialog" and then complete the dialog.
For information on completing the dialog, see "Specifying the Settings for Conditions".
Select an existing condition, click Browse to display the "Select Condition dialog" and then complete the dialog.
Save the agent.
You can use conditions to determine whether action links are displayed in dashboard pages. For information on adding actions links to dashboard pages, see "About Adding Actions to Dashboard Pages".
To use a condition to determine whether an action link is displayed in a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Click the tab of the page that contains the action link that you want to display conditionally.
Hover over the action link object in the Page Layout area to display the action link object's toolbar and click the Properties button, or, if the action link is in an action link menu:
Hover over the action link menu object in the Page Layout area to display the action link menu object's toolbar and click the Properties button.
The "Action Link Menu Properties dialog" is displayed.
Select the action link that you want to conditionalize and click the Edit button.
The "Action Link Properties dialog" is displayed.
In the Show component, click the Conditionally box.
The Condition component is displayed.
If you want to:
Create a new condition, click the New Condition button to display the "New Condition dialog" and then complete the dialog.
For information on completing the dialog, see "Specifying the Settings for Conditions".
Select an existing condition, click the Select Condition button to display the "Select Condition dialog" and then complete the dialog.
Click OK in the Action Link Properties dialog.
If the action link is in an action link menu, then click OK in the Action Link Menu Properties dialog.
Save the dashboard.
You can use conditions to determine whether sections are displayed in dashboard pages. For information on adding sections to dashboards, see "Adding Content to Dashboards".
To use a condition to determine whether a section is displayed in a dashboard page:
Edit the dashboard. For information, see "Editing Dashboards".
Click the tab of the page that contains the section that you want to display conditionally.
Hover over the section in the Page Layout area to display the section's toolbar, click the Properties button for the section, and select Condition. The "Section Condition dialog" is displayed.
If you want to:
Create a new condition, click the New Condition button to display the "Create Condition dialog" and then complete the dialog.
For information on completing the dialog, see "Specifying the Settings for Conditions".
Select an existing condition, click the Select Condition button to display the "Select Condition dialog" and then complete the dialog.
Click OK in the Section Condition dialog.
Save the dashboard.
You need to specify the settings for a condition in either the New Condition, Create Condition, or Edit Condition dialog, when you create or edit a condition as described in the following sections:
"Using Conditions to Determine Whether Sections Are Displayed in Dashboard Pages"
"Using Conditions to Determine Whether Agents Deliver Their Content or Execute Their Actions"
"Using Conditions to Determine Whether Action Links Are Displayed in Dashboard Pages"
"Editing, Customizing, Testing, Saving, and Disabling Conditions Used in Agents"
"Editing, Testing, Saving, and Removing Conditions Used in Action Links in Dashboard Pages"
"Editing, Testing, Saving, and Removing Conditions Used in Sections in Dashboard Pages"
To specify the settings for a condition in the New Condition dialog, Create Condition dialog, or Edit Condition dialog:
In the Create condition based on box, select whether the condition is to be based on an Analysis or KPI.
For:
(optional) An analysis, edit any prompted filters, as desired.
A KPI, specify the values for any KPI dimensions.
Note: If you specify values for any prompted filters, then these values cannot be overridden at the point of use. |
Specify the evaluation criteria as follows:
For an analysis, in the Condition true if number or rows area:
In the Operator box, select the operator to apply to the row count.
In the Row Count box or boxes, specify the row count to be evaluated.
For a KPI, in the Condition true if KPI box, select the KPI status.
(optional) Click Test Condition to test the condition.
If you want to save the condition as:
An inline condition, click OK.
A named condition, click Save As to display the "Save As dialog", where you can save the condition by name to the catalog.
To edit a named condition:
Navigate to the condition in the catalog.
Click the Edit link to display the "Edit Condition dialog".
Make the desired changes.
For more information on completing the Edit Condition dialog, see "Specifying the Settings for Conditions".
You can:
Edit inline conditions
Customize named conditions by editing prompted filters
Test conditions to see whether the conditions evaluate to true or false
Save inline conditions to the catalog as named conditions
Remove conditions
To edit, customize, test, save, or remove a condition used in an agent:
Edit the agent.
Click the "Agent editor: Condition tab".
To:
Edit an inline condition, click Edit Condition to display the "Edit Condition dialog", and make the desired changes. For more information on completing the Edit Condition dialog, see "Specifying the Settings for Conditions".
To customize the prompted filters of a named condition, click Customize to display the "Customize Condition dialog", and make the desired customizations.
To test a condition, click Test. The evaluation results are displayed.
To save an inline condition to the catalog as a named condition, click Save To Catalog to display the "Save As dialog".
To disable a condition, click Do not use a condition (always deliver content and run actions).
Save the agent.
You can perform the following tasks on conditions that are used in action links in dashboard pages:
Edit conditions
Test conditions to see whether the conditions evaluate to true or false
Save inline conditions to the catalog as named conditions and save named conditions to the catalog by other names
Remove conditions
To edit, test, save, or remove a condition used in an action link in a dashboard page:
Edit the dashboard page that contains the action link.
Hover over the action link object in the Page Layout area to display the action link object's toolbar and click the Properties button, or, if the action link is in an action link menu:
Hover over the action link menu object in the Page Layout area to display the action link menu object's toolbar and click the Properties button.
The "Action Link Menu Properties dialog" is displayed.
Select the action link that contains the condition and click the Edit button.
The "Action Link Properties dialog" is displayed.
Click the More button to the right of the Condition field and then:
To edit a condition, select Edit Condition to display the "Edit Condition dialog" and make the desired changes. For more information on completing the Edit Condition dialog, see "Specifying the Settings for Conditions".
To test a condition, select Test Condition. The evaluation results are displayed.
To save an inline condition to the catalog as a named condition, select Save Condition As to display the "Save As dialog".
To remove a condition, select Remove Condition.
Click OK in the Action Link Properties dialog.
If the action link is in an action link menu, then click OK in the Action Link Menu Properties dialog.
Save the dashboard.
You can perform the following tasks on conditions that are used in sections in dashboard pages:
Edit conditions
Test conditions to see whether the conditions evaluate to true or false
Save inline conditions to the catalog as named conditions and save named conditions to the catalog by other names
Remove conditions
To edit, test, save, or remove a condition used in a section in a dashboard page:
Edit the dashboard page that contains the section.
Hover over the section in the Page Layout area to display the section's toolbar, click the Properties button for the section, and select Condition. The "Section Condition dialog" is displayed.
Click the More button to the right of the Condition field and then:
To edit a condition, select Edit Condition to display the "Edit Condition dialog" and make the desired changes. For more information on completing the Edit Condition dialog, see "Specifying the Settings for Conditions".
To test a condition, select Test Condition. The evaluation results are displayed.
To save an inline condition to the catalog as a named condition, select Save Condition As to display the "Save As dialog".
To remove a condition, select Remove Condition.
Save the dashboard.