This report compares a daily half hour profile against against a target profile and reports high and low exceptions. As the report day shifts during scheduling, the target may be redefined as it can be based on a moving window of data from the same channel (eg an 8 week range always ending 4 weeks before the report day) or it could be a fixed historic range.
...
Open Sigma and click on Reporting
Running the Report
- Choose the Site, Channel or Monitoring Point that you want to run the Report on
- Choose the Daily Consumption Exception Report
Complete the Report criteria as follows:
...
1st digit: #weeks of data for average
2nd: #weeks back from report date (the gap)
3rd+4th: +/- this as the percentage target (assuming you want the same figure in both, ie 10 and -10)
- Click
to run and view on screen
OR
- Click
to send the Report to the Document Library Activity
OR
- Click
to run the Report at specific times (see below)
Scheduling the Report
Create the Report as above (don't click on Run Report)
The Report can be scheduled to send a Report each day if All channels has been ticked
OR
will only produce a Report when and exception occurs if Channels with Exceptions (for scheduler use only) has been ticked
- Click to set the Report to run at specific times (see below)
- Enter the Name
- Enter a Description
- Click Next to go to the Report Configuration screen
These details are the same as entered on the Report - do not amend
- Click Next to go to the Report Output screen
- Enter the To address (can add more than one, separated by a comma (,)
- Enter the Subject
- Enter the From address
- Enter the Reply address
- Tick how you want to receive the Report
- Click Next to go to the Report Date screen
- Choose Dynamically set the date to 2 Days before execution time so that the Report will always use the day before
This will take you to the last whole day, so running the report at 03:00 on 27th will give you the data for all of 26th
- Click Next to go to the Fixed end date screen
- Choose Dynamically set the date to 1 Day before execution time so that the Report will always use the day before
- Click Next to go to the Activation screen
- Ensure Active is ticked
- Choose the date and time you want the Report to run (choose the time to reflect the time of day you want to run the report, ie best practice is overnight)
Note: If you are running the report overnight, you will need to ensure that data is in Sigma prior to the Report Run Time.
- Click Next to go to the Recurrence screen
- Choose the recurrence, for example Daily
- Click Next to go to the Run time(s) screen
- Choose Every weekday or Every X days
- Enter a figure in the Select number of days, ie 1
- Click Next to go to the Schedule End screen
- Choose never, after or on
- Click OK to save
The Report is now scheduled and will either send a Report each day if All channels has been ticked
OR
will only produce a Report when Channels with Exceptions (for scheduler use only) has been ticked