To complete the Equipment Depreciation and Depreciation Detail tabs in the Service Activity Rate Calculation Template, you need to run the Equipment Depreciation Webi Report first.

Note: In order to run Webi reports, users must have the latest version of Web Intelligence Rich Client installed on their computer. Updates and installation guides can be found through the aits.uillnois.edu.  Alternatively, users can access this report via the web browser based EDDIE system that is available through the OBFS website.

1. Go to the Service Activities Resource Page.
2. Click the Business Objects Webi Report Templates section to expand the drop-down menu..
3. Click Equipment Depreciation Report Template (Webi). This will save the report as a .wid file.
4. Locate and Open the downloaded report file in your file explorer.
5. When prompted, Login with your user name and password (Net ID and University Password). You must be on VPN if logging from a device not on the University Network.
6. You should be redirected to a blank tab in the report. If not, select the SA_Equipment Depreciation_July 2022 report from Open Documents, or Recent Documents in the SAP Business Objects (Webi) main menu.
7. Once the blank report is open, click the Refresh icon (circular arrow) under Query.
8. Click Enter 3-Digit Org Code with % wildcard on the left side of the Prompts window. (Keep in mind that Equipment Data is stored at the Org/Department level, so further analysis of the report will be required to identify equipment with a particular fund).
9. Type the 3 digit Org Code for the department with a % sign immediately following (ex: 123%).  In the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.  (This will capture all potential Org codes that begin with the 3 digit dept Org code).
10. Click Enter COA on the left side of the Prompts window.
11. Type the single digit COA in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
12. Click Enter College Code on the left side of the Prompts window.
13. Type the 2 letter College Code in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
14. Click Enter Fiscal Year on the left side of the Prompts window.
15. Type the 4 digit Fiscal Year in the "Search or enter values(s) manually" box. Confirm you input by clicking the (+) button. Your entry will populate in the Selected Values section of the window.
16. Click the Run button.
    NOTE: The report may not refresh immediately based on the amount of information and connection speed.
17. To export the data to Excel, click the down arrow icon (Export) in the File section of the top ribbon.
18. Use the check boxes to select which pages of the report you want to export as tabs in an Excel workbook (or click "All Reports" to select all).
19. Click Export.
20. Select a destination to save on your computer or network and click Save.
21. Refer to the Equipment Depreciation Populating the Service Activity Rate Template job aid to populate the template with the equipment depreciation information.