CatConnect BI Inventory

BI Cognos-Reports CatConnect

The following are resources for CatConnect BI.

Access Cognos BI through the NUPortal or at https://reporting.northwestern.edu.

About ARD Reporting

ARD Data Dictionary and Model Changes

Resource	Description
ARD Self Service Data Dictionary.xlsx	This Excel workbook provides a way to see the all the descriptions (known as tool tips in BI) of the BI fields available in ARD self-service.
ARD Self Service - BI data model change - Donor Information.pdf	This document outlines the data model changes for Donor Information.
ARD Self Service - BI data model change - Giving Society Prior FY Fields.pdf	This document outlines the data model changes for Giving Society Prior FY.
ARD Self Service - BI data model change - Involvements.pdf	This document outlines the data model changes for Donor Information.
ARD Self Service - BI data model change - Prospect Attributes in Bio Demo.pdf	This document outlines the data model changes for Donor Information.

Upcoming BI Implementations

Resource	Description
ARD Self Service - Known Issues and Content not yet added.pdf	For the 5/5/25 go-live of CatConnect and the ARD Self Service, some fields from the existing CATracks BI are not yet present, but will be added in the near future. This document outlines what we have remaining.

Cognos BI Resources

ARD Core BI GIFS

Resource
Advanced filtering
Basic Dashboard
Basic Filtering & Sorting
Creating a report with template
Design & Preview modes
Involvements and their filters
Saving report to My Content in new folder
Scheduling report as email
Search for report or dashboard
Sharing report results via email
Where to find self service folder

ARD Core BI Recordings

Resource	Description
ARD CORE BI Advanced Reporting Tips & Tricks	Video Chapters: Applying Templates to Report Properties: A Demonstration Creating Multi- Tab and Multi-Page Reports: A Demonstration Advanced Report Building Demo: Creating Reports with Section and Page Breaks
ARD CORE BI Cognos Analytics ‘How-To’ Videos	Video Chapters: How to move default location of Filter Display Creating Filters that handles ‘Nulls’ and additional Values Creating Reports with Sections and Subtotals Grouping Filters to do ‘OR’ Condition How to setup Advanced Filters Creating Custom Dynamic Date Filters How to setup Prompting How to setup a ‘Contains’ Filter How to setup Optional Date Prompt
ARD CORE BI Navigation	Video on how to navigate Cognos BI
ARD CORE BI Report Creation	Video on how to create a report in Cognos BI
Connecting to ARD Self-Service and Reports from Tableau	Video Chapters: Prerequisite New UI Walk thru Using universal Search Bar Building a Cognos Report Using Interactive Reports Bring your own data into Cognos Modelling your data using Data Module Creating Dashboards

Canned BI Reports

Report Number	Report Name	Description
ARD001	ARD001 - Major Gift Commitments Dashboard.pdf	Counts and totals for major gift commitments ($100K+) by Reporting Area with multiple options for filtering and display format.
ARD002	ARD002 - YTD Cash and NGC.pdf	Cash and New Gift & Commitment totals by Academic Organization for prior and current FYTD for the selected fiscal year and month.
ARD003	ARD003 - Campaign Proposal Pyramid Report.pdf	The campaign prospect pyramid report shows a standardized view of campaign activity at Northwestern University

Was this helpful?

100% helpful - 1 review

Print Article