Go to FIG/Data_Coordinator/SUNY_Info_Data/XX year and create a PSI folder (this will contain the data we generated during the SUNY Tran process) ******Transmission of data to SUNY is now complete****** Preparation for the Next Fiscal Cycle Request creation of Datamart for next Fiscal Year Send an email to Anasua Datta requesting that she prepare the datamart for the next fiscal year. Run the final snapshot as this will be the final record of the fiscal year data Inform her that a final snapshot has been run. Remind her to add the next fiscal year to the OBIEE reports Ask that the prior fiscal year be set as the default Roll the system over to the next fiscal year: In the Administration page select the ‘Roll the system over to FYxx- this is VERY SCARY’ button. This action performs multiple functions (hence the “very scary”) Turn the nightly snap shot back on for PRODUCTION ONLY: Test must remain pristine until SUNY accepts the PSI file. Select the ‘Turn On Snapshot’ button to toggle on the nightly snap shots to capture data for the new fiscal year. Verify System Roll Over: The morning after the system roll over the Facilities Inventory Staff should receive e-mail notices from Cornell Data Warehousing that the DataMart Load completed. It’s important to verify that within the system the new fiscal year is visible. Launch OBIEE Reports () Select “Facilities” reports. Verify that the in the Fiscal Year pull down menu the CURRENT fiscal year is available. Verify that the PRIOR fiscal year is set as the default. If this is not the case then the Database Administrator must be contacted to resolve the problem. Notify Org Admins that the system is OPEN! Create Arc Data Export: This is a download of room data by facility code as one row per room. This data is used by Frank Popowitch for floor plans and the University Space Planner (Mary-Lynn Cummings) for planning purposes. **It is important to download the Org Download file the same day the system closes. This will ensure that the same org changes that are reflected in the Inventory System are mirrored in the org report.** Go to Arc Data Export at to create the Arc Data Export Yearly file. Submit a ticket to Facilities Computer and Network Support () to create a container for closing the fiscal year. Once the container has been created select ‘Create Yearly File’ and download the file.
Go to FIG/Data_Coordinator/SUNY_Info_Data/XX year and create a PSI folder (this will contain the data we generated during the SUNY Tran process) ******Transmission of data to SUNY is now complete****** Preparation for the Next Fiscal Cycle Request creation of Datamart for next Fiscal Year Send an email to Anasua Datta requesting that she prepare the datamart for the next fiscal year. Run the final snapshot as this will be the final record of the fiscal year data Inform her that a final snapshot has been run. Remind her to add the next fiscal year to the OBIEE reports Ask that the prior fiscal year be set as the default Roll the system over to the next fiscal year: In the Administration page select the ‘Roll the system over to FYxx- this is VERY SCARY’ button. This action performs multiple functions (hence the “very scary”) Turn the nightly snap shot back on for PRODUCTION ONLY: Test must remain pristine until SUNY accepts the PSI file. Select the ‘Turn On Snapshot’ button to toggle on the nightly snap shots to capture data for the new fiscal year. Verify System Roll Over: The morning after the system roll over the Facilities Inventory Staff should receive e-mail notices from Cornell Data Warehousing that the DataMart Load completed. It’s important to verify that within the system the new fiscal year is visible. Launch OBIEE Reports () Select “Facilities” reports. Verify that the in the Fiscal Year pull down menu the CURRENT fiscal year is available. Verify that the PRIOR fiscal year is set as the default. If this is not the case then the Database Administrator must be contacted to resolve the problem. Notify Org Admins that the system is OPEN! Create Arc Data Export: This is a download of room data by facility code as one row per room. This data is used by Frank Popowitch for floor plans and the University Space Planner (Mary-Lynn Cummings) for planning purposes. **It is important to download the Org Download file the same day the system closes. This will ensure that the same org changes that are reflected in the Inventory System are mirrored in the org report.** Go to Arc Data Export at to create the Arc Data Export Yearly file. Submit a ticket to Facilities Computer and Network Support () to create a container for closing the fiscal year. Once the container has been created select ‘Create Yearly File’ and download the file.