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: June 2026

 

Details

  1. Log into My.Columbia, select the ARC tab and click the GO to FDS icon.. The FDS screen appears. 
ARC Portal

The FDS screen appears.

FDS Screen
  1. Click the FDS COB Analytics
  1. Double click the desired report Title.
COB Reports

A Prompts window appears.

Prompts window
  1. Select a Prompt from the left side of the window. Options for entering Values appears on the right side of the window.
Prompt with Values options
  1. Enter a value manually or click the Reload the list of values icon to view the list of values to select.
  2. After selecting your Prompts and entering Values, click Run. The selected report will be generated.

Changing Input Controls and Filter Settings

To change Prompts and to filter the report, click the appropriate setting from the Input Controls toolbar. 

Changing Input Controls and Filter Settings

Exporting to Excel 

  1. Click the Export to Excel icon from the top toolbar. 
Export to Excel

The Export to window appears.

Export to window
  1. Select the Content and Options tabs to set preferences.
  2. Click the Export button.

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: 

  1. Select the Design view from the upper right corner of the report window. 
Design mode
  1. Select the Show Main Panel icon and then the Show document objects icon.. 
Show main panel and Show document objects

The list of Available Objects appears.

  1. Drag and drop the desired object to the desired column location in the report.
Drag and drop objects to column

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.

Adding and Removing Filters 

  1. Select the Design view from the upper right corner of the report window.
  2. Select the Show main panel icon and then the Show document objects icon to display available objects.
  3. Select the Show properties panel for current-selection icon and select the Display the filter panel icon.
Show properties panel for current-selection and Display the filter panel
  1. Drag and drop an object from the object list to the designated location in the Filter By section.

Drag and drop objects to filter

The Select values dialog appears.

Select values dialog
  1. Select the values for which you want to filter the report and click OK. The report is filtered for the criteria with subtotal lines in amount columns. 
The report is filtered

To remove a filter, click the Delete Filter icon from the Filter settings.