Cognos offers reports to view AggieExpense, Procurement and Travel Card transactions, as well as those made through the Preferred Booking Program (PBP).

Access to Reports

Access to the reports listed on this page (GLIDE and AggieExpense) is automatically provisioned to users that have at least one of the following roles in Aggie Enterprise:

• UCD Projects Cost Inquiry JR
• UCD General Ledger Inquiry JR

For users not auto-provisioned: 

• Please reach out to your department’s CAO or fiscal officer to determine the reports for which you should be provisioned.
• Submit access request via email to your department's security liaison (cc: CAO or fiscal officer).
• Note that the Security Team will only process requests submitted by designated liaisons, all other requests will be cancelled.

Logging in to Cognos

1. Log in to Cognos with your campus user ID and Kerberos passphrase.   NOTE: You will need to log in twice, one on the CAS screen and also on the IBM system login screen with your campus user ID and Kerberos passphrase.
2. After logging in, click on the name of the folder to access the relevant reports (e.g. Aggie Enterprise or AggieExpense).

AggieExpense Cognos Reports

• AEE-318 Department Approvers:
  • View the current approver for a given department or employee
  • Use this report when making department approver changes
• AEE-417 Outstanding Cash Advances:
  • Displays outstanding cash advances made via the AggieExpense Request module
  • Reconcile any outstanding cash advances as soon as the trip concludes
• AEE-418 Unreconciled Card Expenses:
  • Displays outstanding Travel Card and Procurement Card transactions
  • Reconcile any outstanding Travel Card transactions as soon as possible. Travel Card transactions can be reconciled before the trip even starts.
• AEE-419 Report Lookup:
  • Look up Travel and Entertainment reports by a variety of parameters, including: Division, Department, Traveler Name, Report Name, or Report Type
• AEE-421 Unreconciled Direct Billing Expenses:
  • Displays outstanding Preferred Booking Program transactions.  Reconcile any outstanding Preferred Booking Program transactions as soon as possible.  Preferred Booking Program transactions can be reconciled before a trip or event begins.
  • If you find a transaction on the report that is not showing in AggieExpense, contact expensehelp@ucdavis.edu.
• AEE-425 AggieExpense Spend Report:
  • This is an expenditure report where the submitter can search for expenses grouped by month and employee for an approver's designated employees.

GLIDE Report

The General Ledger Interface Details Engine, or GLIDE, reporting tool, is designed to capture transactional details and store data to support expense reconciliation processes. GLIDE allows boundary applications, including AggieExpense, to send over debits and credits, along with additional data fields. 

Using the GLIDE Report

1. The GLIDE report is in the Aggie Enterprise folder.
2. Click on GLIDE to access the GLIDE reporting tool.
3. Most of the search fields are not required for GLIDE. There are search fields for the various segments of the UC Chart of Accounts (CoA), allowing a user to narrow down the results to a specific financial entity, if needed.  Include at least the following two search criteria for best results:
   • Date Range
   • Journal Source of UCD Concur
4. Results will display with the CoA (Chart of Account) or PPM (Project Portfolio Management) to which the transaction posted, and the custom fields for default card (Procurement Card and/or Travel Card) transaction data and AggieExpense data. 

NOTE: In the first months after the launch of Aggie Enterprise, some transaction data didn’t transfer to GLIDE (General Ledger Interface Details Engine).  Please review this spreadsheet to review any data that might be missing in GLIDE.

Results Include Custom Data Fields

Using and Combining the GLIDE and Transaction Listing Reports

Learn how to use the Transaction Listing and GLIDE reports in unison to get the General Ledger data you need from AggieExpense.