Creating Insight conditions
Conditions are objects in Insight that return a single Boolean value based on an evaluation of the row count of an analysis. 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.
Note: With Insight, you can only create conditions against an analysis. Insight does not support Key Performance Indicators (KPIs) that is included with Oracle Business Intelligence Enterprise Edition.
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 marketing manager wants to deliver a monthly budget update to his direct reports only when a campaign's cost exceeds the budgeted cost. You might create a condition that is based on an analysis returning campaigns that exceed the budget and add it to an agent whose delivery content is the monthly budget update. When the condition evaluates to true (that is, the analysis contains rows), the agent is triggered to deliver the monthly budget update.
A condition consists of the following elements:
- An analysis
- A row count
- An operator to apply to the row count (for example, the row count equals 100)
You can create a named condition or an inline condition:
- A named condition is a condition that you define and then save to a catalog folder so that you can reuse it in agents and dashboard pages.
- 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 an agent or dashboard page.
To create a named condition:
- In Insight, click New > Condition.
- Click Browse and select the analysis that the condition will evaluate against.
- In the True If Row Count area, select the operator to apply to the row count and then specify the row count. For example, the row count equals 100.
- Click Test to test the condition.
- Click Save and choose where to save the condition.
Note: If a condition is based on an analysis that is private, you cannot save it in the Shared Folders folder.