Sigma Online User Manual

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Overdue data is defined as interval meter reading data that is now deemed as missing as it has not been received from the date it was last expected. It also highlights where no data at all has been received.

For example:

  • a periodic channel which is recording data for every interval on a daily basis. If the data is not received for the day before last, then this would be deemed overdue.
  • a periodic channel which is recording data for every interval on a monthly basis. If the data is not received for the previous month at the start of the next month, then this would be deemed overdue.

Creating an Overdue Data Strategy

Adding Notes to Notifications

This basic workflow allows you to capture information and update the status of the Notifications, as per your own business processes.

This is expected to be used to help you keep track of any investigative and follow-up actions which are been taken as a result of the Data Monitoring Notifications.

For example:

  • where there is ongoing investigation to determine the cause of the problem, the status may be changed to "Under Investigation" and there maybe a series of notes capturing what has been happening
  • where the issue has been referred to a metering agent to resolve, the status may be changed to "Assigned to Third Party" and there maybe a note to capture details of any conversations with the agent

Highlight the Notification(s) you would like to update. Notifications can be selected in bulk, even across different strategy types.

  • Click  which will display the Work Notification pop up:

The Status will default to In Progress and is not editable - the Resolve and Ignore features will update the status.

If you want to update the Sub-status, select the required option from the drop down list. The default options are:

  • Under Investigation
  • Assigned to Third Party
  • Pending Resolution

You can customise the options available for selection to suite your needs here by using the Database Object Setup activity.

You can also create  reports in Energy Intelligence to keep track of the Notifications and their status, filtered as required to show the information as per your needs.

If you want to update the Note for the Notification(s), then Tick Update Note and enter the note in the text box.

Click OK to Save.

Ignoring Notifications

This will update the status of the Notification to "Ignored" and will also prevent the same notification (for the same period and Impact) from being raised by the system again.

  • Highlight the Notification(s) you would like to update. Notification(s) can be selected in bulk, even across different strategy types
  • Click   to open the Ignore Notifications pop up appears:

If you want to update the Note for the Notification(s), then Tick Update Note and enter the note in the text box.

  • Click OK to Save

Editing Items

  • Highlight the Notification
  • Click  to open the Periodic HFD Channel Editor 

You can view the Channel / amend the interval reading Data associated to the notification, if required.

Please note, this option is only available if a single Notification is selected.

  • Click OK if you have made changes
  • Click Cancel to return to the Data Monitoring Activity

Editing Monitoring Strategies

Highlight the Notification for which you would like to edit the underlying monitoring strategy configuration.

  • Click  to open the Monitoring Strategy Editor. Note, this is only an available option if Notification(s) relating to a single strategy are selected.
  • Amend the Monitoring Strategy as required. Please see Data Gaps, Overdue Data or Unexpected Data for additional help.
  • Click OK to Exit and Save

Exporting to Excel

  • Click  to download an Excel Spreadsheet of everything you see in the table

Overdue Data Configuration

The Monitoring Strategy Editor also contains an Overdue Data Configuration section that allows you to set the specific configuration to use when finding and managing the overdue data.

FieldDefaultDescription
Data Load FrequencyDaily

Specification of the frequency at which data is loaded to the channel. Choose from:

  • Daily
  • Monthly
Offset (Days)1

Choose the offset between the end date of the missing data period being checked based on the current date.

Examples

  • Data should be received daily and I want to know if I have not received data after 2 days:
    • Data Load Frequency should be set to "Daily"
    • Offset should be set to "2"

Here, if data had been received up to and including 21/07/2019, the data would be deemed overdue from the 24/07/2019

  • Data should be received monthly, and I want to know if I have not received data 5 days after the end of the previous month:
    • Data Load Frequency should be set to "Monthly"
    • Offset should be set to "4"

Here, if data had been received up to and including 30/06/2019, the data would be deemed overdue from the 05/08/2019.

Also includeAll unchecked

Define the combination of data values that should be considered missing data.

Options include:

  • Zero - No Error
    • Checks for recorded values of '0' AND a status of 'No Error'. This represents data that the source metering system has sent as an actual meter reading value of zero. This should be used with caution as could represent valid data - it is intended to check meters which never expect to receive readings with a value of zero based on their operation.
Auto Fill DataOff

An on/off toggle to determine whether the system should automatically estimate the data that is deemed to be overdue, based on an average from a historical period (specified below).

Auto Fill - Weeks to Average4

Specify the number of weeks that should be used as a basis when calculating the data to use for automatically extrapolating historical data.

More information about how this feeds into the system processing that it supports when filling the data can be seen here.


  • Click OK to save the Monitoring Strategy


Once the Strategy has been set up, Sigma will review the data each night and create any relevant notifications in the Notifications tab

  • No labels