Decision Support Data Loading Dashboard

Sent to UCI-DWH mailing list on Nov. 15, 2022

In light of the recent database issues that we’ve been experiencing for the KFS DWH jobs, we are launching a Tableau dashboard that will display the Last Loaded Date/Time for both our UCPath and KFS jobs. The link for the dashboard is:

https://tableau.oit.uci.edu/views/ReportETLLoading/DSSDataLoading?%3Aembed=y&%3Aiid=3&%3Aorigin=card_share_link&%3Atoolbar=top#4

Please note that the loading schedule for UCPath and KFS are different. UCPath data is loaded daily, while KFS is loaded Tuesday – Saturday, except for Holidays. You will also see additional tabs on the top that show the history data of when UCPath and KFS started tracking our job completion times.

screenshot of new report

The links and dashboard are now visible in our Decision Support portlets:

KFS Decision Support Portlet with Decision Support Data Loading link highlighted.

Screenshot of UCPath Decision Support portlet with Decision Support Data Loading link highlighted.

Screenshot of Decision Support tab in ZotPortal showing new dashboard in the About Decision Support portlet.

KFS will be adding this to their homepage in the next few weeks. Please check this dashboard before running any of your UCPath or KFS reports, to ensure that you will not experience any problems. We are working to resolve the database issues, and the slowness of our jobs over the last few days are impacted if reports are being run before the jobs are completed.

Please feel free to forward this email to any colleagues who may be interested, and a link to subscribe to the UCI-DWH mailing list for all future notifications is: https://maillists.uci.edu/mailman/listinfo/uci-dwh

Thank you for your patience and understanding while we work to resolve the database issues. We are hoping that this dashboard will help address our recent job delays, and provide a way for you to ensure that your Decision Support reports are updated.

OIT Data Warehouse Team

Sign Up to Get A&FS News in Your Email

Receive this news in your emaill by going to maillists.uci.edu/ and subscribing to these mailing lists:

  • AFS-Update for updates and news from the Accounting & Fiscal Services Department
  • UCI-DWH for Decision Support and Data Warehouse updates

You can unsubscribe using the same link. If you have questions or need help, please contact kfs@uci.edu or 949-824-7001.