GIW-Based Utilization for CoC-Funded Projects by Project Report

This guide has been written to assist users with a BusinessObjects license in properly running the GIW-Based Utilization for CoC-Funded Projects by Project Report. A guide on understanding this report is available here: Understanding GIW-Based Utilization Reports.

At this time, this report will only work for the St. Louis City Continuum of Care. ICA has not been asked to set up this report to work for other Continua of Care at this time but can do so at the request of CoC leadership. CoC leadership may contact the helpdesk or the HMIS Manager for their region to request additional information.

Scheduling the Report

Report Path

Folders
> Public Folder
> missouri_live_folder
> Outcome Reports
> GIW-Based Utilization for CoC-Funded Projects by Project

Recommended Export Format

Schedule to Microsoft Excel - Reports

Setting the Prompts

Prompt	Instructions
Select Project(s):	Select the project(s) for which you wish to run the report. Note: If this prompt is completed, the "Select Reporting Group" prompt must be left to "none selected" or left incomplete (blank).
Select Reporting Group:	Select the reporting group for which you wish to run the report. Note: If this prompt is completed, the "Select Project(s):" prompt must be left incomplete (blank).
Select CoC Code:	This prompt is for use by ICA System Administrators only. Leave set to "none selected."
Enter Start Date:	Enter the start date for the reporting period in M/d/yyyy format. For example, if you're running a report for 7/1/2020-6/30/2021, the date entered in this box would be 7/1/2020.
Enter End Date PLUS 1 Day:	Enter the date after the last date of the reporting period in M/d/yyyy format. For example, if you're running a report for 7/1/2020-6/30/2021, the date entered in this box would be 7/1/2021.
EDA Provider	If only one project is selected in "Select Project(s):" above, select the same project here. If more than one project is selected in "Select Project(s):" or a reporting group has been selected in "Select Reporting Group:", then select one of the projects within the selected projects or reporting group.

Reading the Report

This report has four tabs, each serving a specific purpose.

Important! Because the report contains identifying information (names), the report cannot be emailed (even within agencies) unless encrypted, nor can it be shared outside of the agency.

Summary

This tab shows the names of all of the projects included in the report, along with the average number of households served per night, the average capacity per night during the report period, and the overall utilization rate for the report period.

Household Detail

This tab shows household-level detail so projects can identify potential data entry mistakes. This tab contains personally identifying information (PII) and therefore cannot be sent via email or other unsecure transmission methods.

Capacity Detail

This tab shows project-level capacity information to assist users in identifying potential incorrect capacity information within the HMIS. If any potentially incorrect information is identified, users must notify the ICA Missouri Helpdesk which will assist you in determining whether there is an issue and fixing it, if an issue is confirmed.

Additional Information

This tab contains information about the report that can be utilized by ICA staff to determine whether the report was run properly by the user. If you seek assistance with this report from the ICA Missouri Helpdesk, please be prepared to read/send information off of this tab to the individual who assists you.

Need Assistance?

If you need assistance running the report, understanding the information in the report, or troubleshooting potential errors, please reach out to the ICA Missouri Helpdesk. Include the name and date of the BusinessObjects report as it appears in your BI Inbox in your request for assistance. Do not attach the report to any emails going to the helpdesk as the report contains personally identifying information and cannot be transmitted unless encrypted.