Components installed with the GRC: Metrics application

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 4 minutes de lecture

    • 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.

    Tableau 1. Roles 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.
    Tableau 2. Tables 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 import

    sn_grc_metric_data_import

    		 Staging table that stores the records parsed from input data file.
    Metric import log

    sn_grc_metric_st_import_log

    		 Remote table that has data for showing import logs for import jobs.
    Metric transform history

    sn_grc_metric_st_transform_history

    		 Remote table that has data of transaction history for import jobs.
    Metric import template

    sn_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.
    Tableau 3. Scheduled jobs installed with GRC: Metrics
    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

    Tableau 4. Properties installed with GRC: Metrics
    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