Skip to Content

University Registrar


Data Warehouse Catalog and Schedule Reports

Discover answers to frequently asked questions related to Catalog and Schedule reports.

Frequently Asked Questions

How do I get access to the Data Warehouse Catalog and Schedule reports?

View the New Schedule Coordinator web page for full details on obtaining access to Data Warehouse.

Which web browser is recommended for running Data Warehouse reports?

Google Chrome

How do I make the "USC Banner Reporting" tab show as the default view?

Complete these steps once and you won’t have to do it it again.  

  • Log in to Data Warehouse.

  • Click the USC Banner Reporting Tab.  

  • Click the small down arrow to the right of the house icon (home) located in the upper right corner of the page.    

  • Choose Set View as Home.  

  • Now every time you log in you will see the USC Banner Reporting menu automatically. 

How do I choose to have all of the reports I use always run in Excel? 

If you prefer for all reports to run in Excel, follow these steps:

  • Log in to Data Warehouse.

  • Click the small down arrow to the right of the person icon.

  • Choose My Preferences.  

  • Set Report Format to Excel 2007.  

  • Click OK.  

  • Now all reports will run in Excel.

How do I choose to have reports in another format? 

If you prefer for your reports to default to Excel, but want to occasionally choose another format, go to the report you are running (ex. Schedule Details) and click the small blue right arrow. This will provide you with format options.

My report is missing data. What did I do wrong?

Remember that the fewer options you choose, the more data you will get.  For example, choose term = 201701, campus = COL, and subject code.  This will guarantee you will get all of your sections for that subject code. 

The report takes a long time to run. Is there a faster way?

If you don’t want to wait and watch the report spin (like waiting for water to boil), click Select Delivery Method, then choose Email Report and have it emailed to yourself.  You can edit the subject line so that later you will remember why you ran the report. 

The report is too wide.  How do I make it more manageable?

  • When the report opens in Excel, click Enable Editing, then select the entire sheet by clicking the box to the left of column A and above row 1.

  • With the entire sheet selected, click the dropdown arrow to the right of Merge & Center.   Choose Unmerge Cells.

  • If row 1 is blank remove it so that sorting will be easier.  Click  row 1 to select the entire row. Right click in the row and choose Delete.

  • Again, select the entire sheet and sort by anything – perhaps SUBJ, CRSE, SECTION.  This will remove any blank rows you may have from the unmerge step.

  • Deleting Columns vs. Hiding Columns – if you are absolutely certain you won’t need the column, delete it.  If there is a chance you might need it, hide it by selecting the entire column by clicking the alpha character at the top of the column, right click in the column, choose Hide. For example, if you hide column ‘D’ and then find that you need to add it back, click columns C and E, right click in either and choose Unhide.

  • Naming Your File - Use the date in the filename.  For example, filename 2016‐10‐26_Sch_Det_ANTH allows you to see exactly what day the report was run and which subject code was included.

How do I format my spreadsheet before sending it to the Scheduling office?

  • Additions: If a new section is to be added, give us the info we need in the appropriate columns and type ADD in the CRN field and highlight only the CRN cell in green

  • Changes:  If the section is perfect as it is, remove the row.  We do not need to see sections that we are perfect. If the section needs some tweaking, highlight in yellow the CRN cell and only the cells in which the data is changing. You will also put the correct information in the highlighted cells. This will help us look just where we need to rather than looking for the proverbial needle in a haystack.

  • Cancellations:  If the section is to be canceled, highlight the CRN red.