Understanding the GL074 Financial Summary Report in Cognos Analytics

Use the GL074 Financial Summary to see chart strings filtered by Management Level, Project Purpose, and/or Manager/Reviewer. This report resembles the GL070, with the addition of management levels and the ability to group summary-level financial data by Management Level. Although this report was designed for administrators at the major unit level, anyone with access to Cognos BI and the appropriate row-level security can run this report. Data will only be returned for chart strings to which you have access.

Although this report was designed for administrators at the major unit level, anyone with access to see budget information in Cognos can run this report. Data will only be returned for chart strings you have access to view.

Anyone with financial access to Cognos BI and row-level security to financial departments or tree nodes can find and run the report.

Contents

Begin by logging into Cognos Analytics.

  1. Click Team content, from the Navigation Panel.
  2. Click Finance, Facilities, and Research Administration folder.
  3. Click School or Central folder.
  4. Choose and Click any of the following folders. (Note: You may not see all the folders listed as this tied to your security settings)
    • Accounting Services
    • Budget
    • Facilities
    • Sponsored Programs Management
    • Supply Chain
    • Voyager
    • Budget/COA
    • Monthly Financial
  5. Click the report title to see the prompt page.
  1. Respond to the prompts as needed to filter the report.
  2. Click Finish. Result: the report appears in HTML or your default format.

The following prompts are available on the report, in addition to standard prompts for period, fiscal year, ChartFields, and project status.

Prompt Descriptions
Sort Order Prompt

This prompt selects sort order and summary level data. The first two selections offer different primary, secondary and tertiary sort orders. The second two selections offer primary and secondary sort orders at the management level.

gl074sortorderprompt.jpg

Manager/Reviewer

This prompt filters results by NetID (yours or others). It is based on the Manager and Reviewers set up in NUFinancials and limited by row level security. For assistance with assigning a Manager and/or Reviewers to chart strings, refer to documentation in the Finance, Facilities, and Research Administration Training Curriculum.

gl074managerreviewerprompt.jpg

Optional Columns

Include additional columns, as desired.

gl074optionalcolumns.jpg

Optional Summary Rows

Selected data can be totaled or summed using one or more options. Optional rows are selected by default. De-select the rows you would like to not appear on the report. All rows are visible in the report sample below.

  • The "Purpose Summary" refers to Project Purpose.
  • The "Management Summary" refers to Management Level.

gl074optionalrows.jpg

Management Level

This prompt filters results by Management Level. It is based on the Management Level attribute assigned to the chart string (either DeptID or ProjectID) in NUFinancials. For assistance with assigning a Management Level to a chart string, refer to documentation in the Finance, Facilities, and Research Administration Training Curriculum.

gl074managementlevel.jpg

Project Purpose

Select one or more purposes as a filter. Project Purposes are normally assigned via the ChartField Request Form when the Project ID is established, but not all projects are assigned a purpose. To assign a purpose to an existing chart string, or to change the purpose, contact the ChartField Maintenance group in Financial Operations.

gl074projectpurpose.jpg

The report displays all chart strings that match your criteria and to which you have access (row-level security). There is one row per chart string, with grouping applied by fund and department. Separate rows within the report display subtotals per fund and department, and a row at the bottom of the report displays a grand total.

GL074_SS.jpg

See Also:

For additional assistance please contact the IT Support Center at 847-491-4357 (1-HELP) option 2, or consultant@northwestern.edu.




Keywords:BI, business intelligence, era, reporting, Cognos, Analytics, GL074 Report, McFits gl74 glo74 nufin ffra   Doc ID:82153
Owner:Enterprise Reporting & Analytics .Group:Northwestern
Created:2018-05-08 16:00 CDTUpdated:2019-02-04 11:59 CDT
Sites:Northwestern
Feedback:  2   0