Components installed with the GRC: Metrics application
When the Operational Sustainability Management application is activated, the GRC: Metrics application is automatically installed. The GRC: Metrics application adds several tables, properties, and roles that are listed here.
Roles installed
The following roles are installed with the GRC: Metrics application.
| Role | Description | Contains |
|---|---|---|
| sn\_grc\_metric.admin | This role is the admin role for the application. This role can do the following:- Create, read, write, and delete metric definitions, metrics, and metric units. - Override the results in metric data tasks. - Read metric data. - Create schedule. | sn\_grc\_metric.manager, sn\_grc.library\_admin |
| sn\_grc\_metric.manager | Enterprise owner and approver role for the application. This role can do the following:- Create, read, write, and delete material topics, goals, targets, metric definitions, metrics, citations, and metric units. - Override the results in metric data tasks. - Read metric data, metric data tasks, disclosures, and authority documents. If there's an integration with Project Portfolio Management - Create, read, and write, projects and programs - Delete projects and programs If there's an integration with Integrated Risk Management, this role can do the following: - Create, read, write, and delete control objectives, controls, risk statements, and policies. - Read risks and issues. | sn\_grc\_metric.user |
| sn\_grc\_metric.user | This role is a read-only role. Users with this role can't create, edit, or update any metric definitions or metrics | None |
| sn\_grc\_metric.developer | User with this role can edit the script in automated metric definition. | None |
Tables installed
The following tables are installed with the GRC: Metrics application.
| Name | Description |
|---|---|
| Base Metric Definition \(sn\_grc\_metric\_base\_definition\) | Base table for all metric definitions. |
| Calculated Metric Definition \(sn\_grc\_metric\_composite\_definition\) | Calculated metric definitions that are used to aggregate data for two or more metric definitions. |
| Metric Definition \(sn\_grc\_metric\_definition\) | Metric definitions that are used to define automated and manual metrics. |
| Metric \(sn\_grc\_metric\_metric\) | Metric instances that are generated when a metric definition is applied to an entity. |
| Metric Unit \(sn\_grc\_metric\_unit\) | Unit for a metric definition or metric. |
| Parent Data \(sn\_grc\_metric\_parent\_data\) | Parent table for metric data. |
| Metric definition data \(sn\_grc\_metric\_collector\_data\) | Data for automated and manual metric definitions. |
| Metric Data \(sn\_grc\_metric\_metric\_data\) | Data for metric instances. |
| Metric Data Task \(sn\_grc\_metric\_data\_task\) | Task to collect data for manual metrics. |
| Entity type to Metric Definition \(sn\_grc\_metric\_m2m\_definition\_profile\_type\) | Association between Entity type and Metric definition. |
| Entity to Metric Definition \(sn\_grc\_metric\_m2m\_definition\_profile\) | Association between Entity and Metric definition. |
| Metric to Calculated Metric Definition \(sn\_grc\_metric\_m2m\_metric\_composite\_defnition\) | Association between Metric and Calculated Metric definition. |
| Child Metric Definition \(sn\_grc\_metric\_m2m\_metric\_definition\) | Association between Metric and Metric definition. |
| Control objective to Metric Definition\(sn\_grc\_metric\_m2m\_definition\_control\_objective\) | Association between Control objective and Metric definition. |
| Control to Metric Definition \(sn\_grc\_metric\_m2m\_definition\_control\) | Association between a control and a metric definition |
| Unit family \(sn\_grc\_metric\_unit\_family\) | A unit family to group similar units together. |
| Unit conversion \(sn\_grc\_metric\_unit\_conversion\) | Convert any metric data into a preferred reporting unit. |
| Metric to Calculated Metric Definition \(sn\_grc\_metric\_m2m\_metric\_composite\_definition\) | Association between a metric and calculated metric definition. |
| Metric data process queue\(sn\_grc\_metric\_data\_process\_queue\) | Indicates the metric definitions that are in the queue for refreshing the data for calculated metric definitions or updating the entity hierarchical data for all the types of metric definitions. |
| Metric data by entity\(sn\_grc\_metric\_data\_by\_entity\) | Includes data for entities in metric definition and aggregated data for its parent entities defined in the entity hierarchy. |
| Time dimension\(sn\_grc\_metric\_time\_dimension\) | Includes date, week, quarter, month, semi\_annual, year for each day in the year. |
| Metric import job\(sn\_grc\_metric\_import\_job\) | Table that holds the details of import jobs for metrics. |
| Metric data importsn\_grc\_metric\_data\_import | Staging table that stores the records parsed from input data file. |
| Metric import logsn\_grc\_metric\_st\_import\_log | Remote table that has data for showing import logs for import jobs. |
| Metric transform historysn\_grc\_metric\_st\_transform\_history | Remote table that has data of transaction history for import jobs. |
| Metric import templatesn\_grc\_metric\_import\_template | Table that stores the import templates used for preparing input data file for import job. |
Scheduled jobs
The scheduled jobs installed with the GRC: Metrics application run automatically at a specific time or schedule. Scheduled jobs can be set up to perform a wide variety of tasks such as running reports or data exports on a regular schedule.
| Name | Description |
|---|---|
| Aggregate metric definitions | This job is executed every 30 minutes. It pulls all types of metric definitions data which are active and have the state as Pending. It updates the "state" and "value" for each metric definitions data based on the aggregation of its corresponding metric data for that period. |
| CMD validity check | This job is executed once everyday at 12AM. For Each calculated metric definition, it updates the "status" to valid/invalid and the "notes" based on its duplicate child metric definitions and child metrics. |
| Execute calculated metric definitions | This job is executed for each calculated metric definition for both the entity level as well as the metric data definition level and updates with the calculated value. |
| Execute metrics | This job is executed daily once at 4:30PM. This executes for each metric definition and its metrics that create metric data and the metric data task if it does not exists for that period. |
| Generate metric data by entity | This job runs daily to do entity hierarchy rollup for all the metric definitions. |
| Generate time dimensions | This job runs on first day of every year and creates time dimensions for that year. |
Properties installed
| Name | Description | Default value |
|---|---|---|
| sn_grc_metric.metric_data_task_schedule | Specifies schedule to be used for due date calculation | 08fcd0830a0a0b2600079f56b1adb9ae |
| sn_grc_metric.all_words | Is used to replace all comma separated defined string in value to 'All' while importing metric data using Metric Integration. | (blank), blank, na, all, empty, (empty) |
| com.glide.event_manager.grc_metrics_queue.even.load.distribution.enabled | Is used to distribute the events in the 'grc_metric_queue' queue equally between two worker threads. | 500 |
| com.glide.event_manager.grc_metrics_queue.claim_limit | Defines the maximum number of events that one worker thread can claim from the event queue. | true |
Parent Topic:GRC: Metrics reference