Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-10369

Forecast Import Dashboard & Notification (Query Mailer)

    Details

      Description

      Develop a forecast import notification and dashboard that can be used together to easily resolve issues with the forecast import.

      The basis of the notification will be a mechanism to allow a user to upload a query (of some sort) and schedule the query to be run on a daily basis and email the results of that query to a defined list of email addresses.

      The dashboard will allow Support to easily identify which forecast s went awry and provide a path to easily resolve/re-import these forecasts.

      HLE Notes

      Forecast Import - 20

      • Show me for today, a list of the store that were imported
      • Which days did I try to import
      • Define what an exception is
      • Pull from the log
      • List out the exceptions, provide a link to the AWS forecast page
      • AWS Forecast Page - update to allow removal of Ext Gen Date
      • New repeatable, scheduled qry auto notification

        Attachments

          Issue Links

          is implemented by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10370 Forecast Dashboard - Augment/Create Load Tests

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10371 Forecast Dashboard - Documentation

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10373 UI Automation for new Forecast Dashboard & Delete Ext Date in AWS Forecast Page

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10374 Forecast Import Tools - Documentation

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10499 Scheduled SQL Qry/SP send to email (ScriptRunner)

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10504 Forecast Dashboard - New Page and Permissions

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10510 Forecast Dashboard - Show daily results

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10515 Forecast Dashboard - Link to Request AWS Forecast page

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10520 Request AWS Forecast page - Add support to delete ExtGenDate before making a Request

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10759 Spike - Scheduled SQL Qry/SP send to email (ScriptRunner)

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10854 Save Querey Mailer Details to the database

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10943 Forecast Dashboard - Add Date Picker

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-10948 Forecast Dashboard - Display Audit Details

          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. CFAMX-12750 Query Mailer - Update to put query results in the body of the email

          • Major - Major loss of function.
          • Done

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.