Update: Azure Data Studio and Power BI Resources

Date: April 18, 2023
To:
Azure Data Studio and Power BI Users
From:  Reporting and Analytics Technology Team, EASI
Re: Update: Azure Data Studio and Power BI Resources

 

Hi everyone,

The Reporting and Analytics Technology Team at Enterprise Applications & Solutions Integration would like to provide you with an update on the latest resources for Azure Data Studio and Power BI.

Connect+Learn Presentation: Getting Started with Power BI

When: Wednesday, April 26 at 11 a.m.
Where: Join Microsoft Teams Meeting and Add to Calendar

The session will include the following:

  • Use cases for demo
  • Power BI demo
    • Connect to data sources from Power BI
    • Build Power BI report using visualization ​
    • Publish report to a workspace in the cloud and share with users​
    • Schedule dataset refreshes in the cloud
    • Subscribe to reports using user emails
    • Connect to Power BI Shared Dataset
    • Create an App with a package of reports and permission setting​s
  • Resources: Power BI Toolbox and Training Videos Report

Training Videos
We have also published the following Azure Data Studio training videos:

You can view all introductory videos on our Training Resources page, and we will also be developing intermediate and advanced training videos shortly.

Finally, you can find all resources in the Power BI Toolbox.

If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca

Sincerely,

Reporting and Analytics Technology Team
Enterprise Applications & Solutions Integration

Introduction to Power Automate

Join Connect+Learn for a session on Microsoft Power Automate (formerly Microsoft Flow). A service that helps you create automated workflows for repetitive business processes. Power Automate can send reminders on past due tasks, move business data between systems on a schedule, talk to many data sources. We will discuss:  

  • What Power Automate is
  • Its building blocks
  • Types of flows and what it can be used for
  • Create a simple automatic workflow together

Resources

 

Reminder: AMS FI Fiscal Year-End Closure 2023 

Date: April 18, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration 
Re: Reminder: AMS FI Fiscal Year-End Closure 2023

 

Hi everyone,

As a reminder, this year AMS will close for FI year-end processing on Thursday, April 27, 2023 at 7pm and will re-open on Monday, May 1, 2023 at 7am. 

ERDD and the Capital Projects Portal and Invoice Workflow will resume regular functionality on Monday, May 1, 2023 at 7am, and uSOURCE will resume operation at 9am.

The following summarizes the AMS system availability during the week prior to year-end closing:

 

Date Status
Tuesday, April 18 System closes for bi-weekly payroll at 6pm
Wednesday, April 19 System re-opens at 7am
Thursday, April 20 System open regular hours
Friday, April 21 System closes for monthly payroll phase 1 and for “Copy Plan to Budget” at 6pm
Saturday, April 22 System re-opens at 7am
Sunday, April 23 System open regular hours
Monday, April 24 System closes for monthly payroll phase 2 at 5pm
Tuesday April 25 System re-opens at 7am
Wednesday April 26 System open regular hours
Thursday, April 27 System closed to all users at 7pm
Friday, April 28 System closed to all users
Saturday, April 29 and Sunday, April 30 System closed to all users
Monday, May 1 System re-opens at 7am except uSOURCE opens at 9am

 

Please check our System Availability page for information on all systems.

 

For information on the impact of the year-end closing dates on reporting and processing, refer to the Financial Services website.

 

Please note that the Fiori Launchpad Reporting will be available.

 

Sincerely,

Enterprise Applications & Solutions Integration (EASI)

AMS Password Reset Available in the Enterprise Service Centre 

Date: April 17, 2023
To: AMS SAP GUI Users
From: Enterprise Applications & Solutions Integration
Re: AMS Password Reset Available in the Enterprise Service Centre 

 

Dear AMS SAP GUI Users,

As you may be aware, in an effort to streamline processes, increase security and provide an improved user experience, Enterprise Applications & Solutions Integration (EASI) is working to update the current AMS Password Reset process.

Starting today, you can quickly and conveniently reset your AMS SAP GUI password in the Enterprise Service Centre. This new form will provide an automated email that will guide you through the process.

The current form on the EASI website will remain active until June 1, 2023, after which time it will redirect to the Enterprise Service Centre.

If you have questions about the password reset process, please review these FAQs.

Sincerely,
Enterprise Applications & Solutions Integration

Update on Microsoft Teams

Join Connect+Learn for an overview of some recent changes. Updates discussed will include:

  • Delete Chats from your chat list
  • Even more reactions at your fingertips
  • Send your messages later
  • Add people to chat with @mention

 

Resources

Rocket Shuttle Migration Update and Resources

Date:  April 11, 2023
To:  Rocket Shuttle Users
From:  Enterprise Applications & Solutions Integration
Re:   Rocket Shuttle Migration Update and Resources

 

Dear past and present Rocket Shuttle users,

Thank you to those who offboarded from Rocket Shuttle on April 6 in advance of the expiry of the application’s license on May 17, 2023. We will be following up this week with select users who remain to be offboarded.

As mentioned in previous communications, we are offering many resources to support you in the transition to Azure Data Studio and Power BI:

Thank you again for your help with this project and ensuring U of T is prepared for the end of the Rocket Shuttle license.

If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca.

Please do NOT process Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14

Date:  April 10, 2023
To: ROSI Users
From:  Student Information Systems
Re: Please do NOT process Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14

 

*** This e-mail is sent on behalf of Student Receivables & Accounting ***

Please do NOT process any batch or online Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14.

If you process a CHOP for a student during this period, the student’s fees will be calculated incorrectly and in a manner that will be very difficult and time-consuming for Student Accounts to correct.

The student’s ACORN Financial Account may be blocked while the corrections are made.

If you must process a CHOP for a student during this period, then you must trigger fees assessment by viewing the student’s invoice and forward an email message to bonnie.vincze@utoronto.ca.

Student Receivables & Accounting is testing the Summer 2023 session fees assessment process during this period, and if the testing is successful, fees assessment will be turned ‘ON’ at 5pm on Friday, April 14 and fees will be available to view on ROSI on Monday, April 17.

Your co-operation is greatly appreciated.

Sincerely,
Student Information Systems

Update to AMS Password Reset

Date: April 5, 2023
To:
AMS SAP GUI Users
From:
Enterprise Applications & Solutions Integration 
Re: Update to AMS Password Reset

 

Dear AMS SAP GUI Users,

In an effort to streamline processes, increase security and provide an improved user experience, Enterprise Applications & Solutions Integration (EASI) is working to update the current AMS Password Reset process.

Starting April 17, you can quickly and conveniently reset your AMS SAP GUI password in the Enterprise Service Centre. This new form will provide an automated email that will guide you through the process.

The current form on the EASI website will remain active until June 1, 2023, after which time it will redirect to the Enterprise Service Centre.

We will provide future updates when this new form is activated.

Sincerely,
Enterprise Applications & Solutions Integration

AMS FI Fiscal Year-End Closure 2023

Date: April 4, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration 
Re: AMS FI Fiscal Year-End Closure 2023

 

Hi everyone,

This year AMS will close for FI year-end processing on Thursday, April 27, 2023 at 7pm and will re-open on Monday, May 1, 2023 at 7am. 

ERDD and the Capital Projects Portal and Invoice Workflow will resume regular functionality on Monday, May 1, 2023 at 7am, and uSOURCE will resume operation at 9am.

The following summarizes the AMS system availability during the week prior to year-end closing:

Date Status
Tuesday, April 18 System closes for bi-weekly payroll at 6pm
Wednesday, April 19 System re-opens at 7am
Thursday, April 20 System open regular hours
Friday, April 21 System closes for monthly payroll phase 1 and for “Copy Plan to Budget” at 6pm
Saturday, April 22 System re-opens at 7am
Sunday, April 23 System open regular hours
Monday, April 24 System closes for monthly payroll phase 2 at 5pm
Tuesday, April 25 System re-opens at 7am
Wednesday, April 26 System open regular hours
Thursday, April 27 System closed to all users at 7pm
Friday, April 28 System closed to all users
Saturday, April 29 and Sunday, April 30 System closed to all users
Monday, May 1 System re-opens at 7am except uSOURCE opens at 9am

Please check our System Availability page for information on all systems.

For information on the impact of the year-end closing dates on reporting and processing, refer to the Financial Services website.

Please note that the Fiori Launchpad Reporting will remain available.

Sincerely,
Enterprise Applications & Solutions Integration (EASI)

EASI Go Prod AMS and Enterprise Shared Services Updates – Nov. 1, 2022 to Mar. 31, 2023

Date: April 3, 2023
To: U of T Staff
From: Enterprise Applications & Solutions Integration
Re: EASI Go Prod AMS and Enterprise Shared Services Updates – Nov. 1, 2022 to Mar. 31, 2023

 

Hi everyone,

Enterprise Applications & Solutions Integration (EASI) would like to update you on the latest major production releases and updates for U of T’s Administrative Management Systems and Enterprise Shared Services.

The following are major changes from November 1, 2022 to March 31, 2023:

Financial Information System

Retirement of Automatic Print for PO Workflow Users (December 13, 2022)
On December 13, 2022, EASI updated AMS printing to support more convenient, paperless processes for divisions and departments that used the Purchase Order (PO) Workflow. Through comprehensive consultations across all three campuses, EASI identified that users could print to PDF and subsequently retired the automatic printed copy of Purchase Orders in AMS.

Electronic Funds Transfer – Phase 2 (March 2, 2023) 
In August 2022, the University launched the first phase of the Electronic Funds Transfer (EFT) project to transition vendor payments by paper cheque to direct deposit. Phase 2 of the project, which launched on March 2, 2023, involved streamlining processes and notifying administrative staff about changes within AMS. This phase also includes an ongoing strategic onboarding of existing U of T vendors, and the EFT team is accepting additional vendor recommendations from the U of T community for future consideration.

Azure Billing (March 15, 2023)
On March 15, Information Technology Services and Financial Advisory Services and Training launched automated billing for Azure. Users can now view Azure billing details in AMS, providing greater reporting frequency, transparency and convenience.

Research Information System

My Research Suite (March 27, 2023)
My Research Applications Block Grant functionality was expanded to manage the NSERC Undergraduate Student Research Awards (USRA) program. This change will simplify departmental reporting and improve transparency.

Enterprise Shared Services

SharePoint+UTORGrouper (December 2022)
SharePoint can now leverage dynamic groups through UTORGrouper. UTORGrouper grants organizations the ability to manage security groups for access across multiple platforms with groups being made available in Azure. You can create your groups in one place (UTORGrouper) and access them across all O365 platforms, including SharePoint and Teams. In SharePoint, these groups will be accessible across multiple sites and memberships will automatically be updated. Visit the SharePoint Support Centre to get started.

AvePoint (February 2023)
EASI is now offering a third-party backup solution for SharePoint called AvePoint. While deleted items will be stored in SharePoint’s recycle bin for a maximum of 93 days, AvePoint will offer SharePoint admins the ability to backup their selected site data in SharePoint permanently. Charges for this service are based on the amount of storage requested and will be billed annually. Interested parties will have the ability to enroll into this service on a quarterly basis with the next enrollment period occurring in June 2023.

Human Resources Information System


Kronos (November 1, 2022 to March 31, 2023)
Kronos, a convenient, cloud-based time and attendance system, eliminates the use of paper timesheets and the need to forecast employee hours through online approval processes. EASI has implemented Kronos Timekeeper within the following areas: Department of Linguistics, the Faculty of Information, and New College.