Running COB Analytics using Web Intelligence (Webi)
This job aid contains instructions on how to run the Consolidated Operating Budget (COB) Analytics Reports using Web Intelligence (Webi).
Last Revision: October 2018
Details
- Log into the ARC Portal and click the GO to FDS button. The FDS screen appears.
- In the Home tab, click the FDS COB Analytics link. Go to the Running a Webi COB Analytics Report section to run the desired report OR Click the Documents tab from the top of the screen.
-
Expand the ARC folder and Click the COB Analytics folder.
- Double click the desired report Title. A Prompts window appears.
- Click Refresh Values.
- Select the appropriate department hierarchy from the Dept. Tree in the center section of the window.
- Click the arrow >. The selection appears in the right section of the window.
- Click OK. The selected report will be generated.
Changing Input Controls
- To change Department hierarchy, Grants or Non-Grants, Internal Transfer Status, click the Input Controls icon from the left side toolbar. The Input Controls panel appears.
- Make the desired changes from the panel.
Exporting to Excel
- Click the Input Controls icon from the left side toolbar. The Input Controls panel appears.
- Select Off (for exporting to Excel) from the Freeze Header and 1st Column setting.
- Click the Export to Excel icon from the top toolbar.
Adding and Removing Columns
Unlike FDS COB detail reports and other COB Analytics reports, the COB Detail – Intra-day report does not contain all fields by default. You can add columns to the report using the following method:
Select the Design view from the upper right corner of the report window.
- Select the Available Objects icon from the left toolbar. The list of Available Objects appears.
- Drag and Drop the desired object to the desired column location in the report. You can drag the object to the right edge or left edge of a column header. Or, replace a column by dragging the object over the center of the column header. To remove the column, drag it back to the list. Or, right-click the header, click Delete and OK.
Adding and Removing Filters
- Select the Design view from the upper right corner of the report window.
- Right-click on the heading of the column that you would like to filter and click Filter and select Add Filter. The Report Filter window appears.
- Click Add Filter. A list of Available Objects appears.
- Select the Object that you would like to filter on and click OK. The selection appears in the Report Filter window.
- Click OK. The report is filtered for the criteria with subtotal lines in amount columns. To remove a filter, right-click the column heading, click Filter and select Remove Filter.