Create a Simple (Undimensioned) Metric
This introductory article describes how to define the basic settings for creating an Undimensioned Metric from your SQL statement.
- Prepare a SQL Statement: You need an SQL statement that returns a set of measurement times and values for your metric. See Writing SQL for a simple Metric for more details.
- Data source: Metric Insights must have a working data source connection to your data source. If you have not yet configured a data source connection, see Connecting to Data Sources.
1. Access New > Metric
Define the basic Metric information:
- Measured: select the measurement interval that applies to the level of aggregation that you want in your result set.
- Select Not Dimensioned
- Name: The system automatically generates name based on the values selected in the fields above, however, you can change it to a unique descriptive name of your choice.
- Select the Category of a new Metric. Categories are used to group tiles at the Homepage and quickly find required elements.
- Put in Folder: optional - add to an existing shared Folder
Next: define details
2. Define Data Collection parameters
- Data Source: select the repository which contains your data. For more info on data sources, refer to Understanding Data Sources. We are using a SQL Database for this example.
- Data Collection Trigger: select a trigger that will initiate your metric data collection process. To fully configure how data collection should be triggered, see: Automating the Collection of Data
- SQL Statement: Enter an SQL using the format explained in the Hint next to the text box. For more details, see: Write a SQL Statement for a Simple (Undimensioned) Metric
- Validate: click this button to verify that your SQL statement is valid.
2.1. Optional pop-up for parameter substitution
NOTE: If you have specified :last_measurement_time in your statement, you will be asked to select the date/time validating your statement.
3. When validation is successfully completed, click 'Collect Data'
- If your statement is valid, the statement box is green; if there are any errors, the box is colored in red and errors are explained below the statement box.
- The total number of found records and an example of first one are displayed below the statement box.
- To proceed with fetching data, click Collect data
- Specify advanced options for collection of data
3.1. Select the beginning date for data collection
4. Enable & publish your Metric
- System returns last data collection date
- Optionally you can preview your metric
- Define whether this Metric should be available at the Homepage and click Enable & publish