Define Indicator Extraction Criteria in the Insight Designer for an Integration

To define extraction criteria for a model's indicators in the Insight Designer in Integrations:

1. In the Insight Designer Models pane, select the model for which you want to define indicator extraction criteria.

   When a model is selected, you can work with its milestones, identifier, and indicators. To view the list of all models and select a different model, click next to the model name at the top of the pane.

   Note:

   In the Insight Designer, you can also create a new model if it does not yet exist. In the Models pane, click Create Model .
   
   

   Refer to Create a Model for information about defining the model components.

2. From the dropdown list, select Indicators.
   
   
   

   Note:

   Any pending tasks are shown under Messages. Click the link in each message to perform the necessary task.

   The model status changes from Draft to Configured only when all pending tasks are completed. You can activate a model only when it is in Configured status.

3. In the indicators list, review the indicators defined for the model.
   • A icon indicates the milestone associated with the indicator is mapped to the current integration and the indicator extraction criteria is defined.
   • A icon indicates the milestone associated with the indicator is mapped to one or more other integrations.
   • Not Mapped indicates the milestone associated with the indicator is not mapped to any integrations, or the indicator's extraction criteria is not defined.
   • Click and select Add Dimension or Add Measure to add a new indicator to the model.
4. Click an indicator in the list to expand details about its data type, milestone association, and extraction criteria when the associated milestone is passed.
   Under Extraction Criteria, you may see the message Selected milestone is not mapped to any integration actions. To define extraction criteria for the indicator, you must first map associated milestone(s) to an integration, as described in Map Milestones to Integration Actions.
   
   
   
5. If required, change the name and description for the indicator, select the data type, enable filtering, and associate a milestone with the indicator, as described in Define Indicators beginning with step 3.

   Note:

   The selected data type must match the data type of the value that will be extracted at runtime, as defined by the associated indicator extraction criteria in the next steps. Otherwise, the indicator will show an empty value in Insight dashboards.
6. Under Extraction Criteria, click the link to open the Expression Editor.
   
   
   
7. Use the Expression Editor to define the extraction criteria.
   
   
   Description of the illustration expression-editor.jpg
   

   You can click and drag an element from the Source tree to the Expression field, or you can select an element from the mapped activity listed in the Source tree and click Select an element and move to move it to the Expression field.

   You can also insert Functions and Operators from the Components tree into your expression or type an XPath expression directly into the Expression field. See Work with Functions, Operators, and XSLT Statements in Using the Oracle Mapper with Oracle Integration.

8. Click Validate to validate your expression in the Expression Editor. If your expression is not valid, make edits and revalidate.

   Note:

   The validation does not check the data type of the value that will be extracted at runtime. Therefore, you must ensure that the extracted value data type matches the indicator data type. Otherwise, the indicator will show an empty value in Insight dashboards.
9. Click Close.
10. In the Insight Designer, click Save.