DARTS : Discoverer Migration Replacement Queries

DescriptionDue dateAssigneeTask appears on
  • @Rebecca and @Steve to discuss project ownership and advise the team who exactly is the project lead by .
10 Jun 2019Finance Data Marts Implementation
  • @David to schedule an Elevator Pitch play for the team, so we move our shared understanding to green - Elevator Pitch to be complete by .
11 Jun 2019Finance Data Marts Implementation
  • @Mary to organise a 5 Whys play session so we can go deep on our problem space and really understand what we're going after. Problem definition to be agreed by .
13 Jun 2019Finance Data Marts Implementation
  • (#16) This is a temporary step, but freeze the data for ps_scc_pers_biog table in CSRPT. The name for summer23 was ps_scc_pers_biog_2330.
Student Census Documentation
  • (#17) Once the reports have all been run and added to the drive folder, send an email using the Enrollment Reports Folder Users list in the drive which has been updated using the Enrollment Reports Folder Checklist & Process. Please make sure that DBA team (usit-dba@maine.edu) is included on the email list.
    Sample email wording is below. If there were issues with the census, changes to the Drive organization, or other issues or changes, please indicate them as well. If you get an error message when you hit "send" bottom, you can click "Share with x people: view" option on the message box or go back to the access list on Enrollment Reports folder. 
Student Census Documentation
UMS Accounting Office PBI Report Creation Workflow
UMS Accounting Office PBI Report Creation Workflow
UMS Accounting Office PBI Report Creation Workflow
  • VPN is on
UMS Accounting Office PBI Report Creation Workflow
  • 2) The refresh icon will show up when you hover over the mouse to the name of dataset  (The "Type" says dataset.). Refresh the dataset by clicking the icon. It may take up to 5 minutes.
Student Census Documentation
  • Share the feedback with the author or workspace admin
When PBI Requests Come...
  • Check if the permission for the data connection is still valid
When PBI Requests Come...
  • Find the gateway. If not, create one
When PBI Requests Come...
  • Monitor the data refresh load
When PBI Requests Come...
When PBI Requests Come...
  • PS Query - HRPRD
Enrollment Reports Folder Checklist & Process
Enrollment Reports Folder Checklist & Process
Enrollment Reports Folder Checklist & Process
  • For Spring Census: Refresh the dataset for IPEDS Fall Enrollment Report (census) by clicking the "refresh now" icon. After finish refreshing the data, click the report (the one with blue icon) and check if new data is loaded. IPEDS fall enrollment is not going to be available in fall census as cohort table has to be updated. 
Student Census Documentation
  • For Summer Census: Make sure that CS_Multi_Term_Tbl in the SQL Server is successfully updated on the step #8.  Refresh the dataset for IPEDS 12 month enrollment (census) by clicking the "refresh now" icon.  After finish refreshing the data, click the report (the one with blue icon) and check if new data is loaded. 
Student Census Documentation