Decision Support Services

Decision Support Services is a department within Shared Health that makes available data for analysis and reporting purposes. They provide the Cognos EPR Report.

Cognos EPR Report troulbeshooting

If there is a problem with the Cognos EPR Report, email

data@wrha.mb.ca; PIMA@gov.mb.ca

and tell them the problem (no report, old data, ...). Reference the following:

This is a triggered report under trigger "EPR Daily Reports (Exclude ALC) 2".

If we don't get any results from this email, the problem can be escalated to Amber Scott-Diakow. Before we got her contact info, Reid McMurchy was mentioned as the person covering the position that our previous contact Brenda Comte was in. The person who was working on our report as of 2023-03-15 is Barb Osorio (Barb.Osorio@gov.mb.ca)

Our contact used to be Chastity Cleofas, but she no longer works there. She still works elsewhere in Shared Health and has been helpful with questions at times, but shouldn't be the primary contact any longer. However, when it comes to actually updating and troubleshooting the report, including her in conversations early can speed things up.

Background

Our email is sent through report schedule automation. This is set for a specific time of day, and it also triggers an email to DSS so they know if it stops running.

One source of failure: "the behind-the-scenes trigger for this report schedule fired about ten minutes after the report schedule stopped checking for the trigger. The report waits for this trigger because the trigger only fires after all of the EPR data updating is completed"; if the ETL that provides our data is delayed past the end of the schedule window, our email won't get sent. PIMA increased this window to make the scheduled report more resilient.