Cognos offers reports to view AggieExpense, Procurement and Travel Card transactions, as well as those made through the Preferred Booking Program (PBP).
Report Advisories on Missing Data
Missing Transaction Data in GLIDE
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. UC Davis login credentials are required to access the spreadsheet.
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
- 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.
- After logging in, click on the name of the folder to access the relevant reports (e.g. Aggie Enterprise or AggieExpense).
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
- The GLIDE report is in the Aggie Enterprise folder.
- Click on GLIDE to access the GLIDE reporting tool.
- 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
- 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.
Results Include Custom Data Fields
| Field Name | Data |
|---|---|
| udfDate1 | Transaction Date |
| udfDate2 | Posted Date |
| udfString1 | Employee Name |
| udfString2 | TCARD or PCARD |
| udfString3 | Last Segment of Card #, or Report Key |
| udfString4 | Supplier/Merchant Name |
AggieExpense Reports
AggieExpense reports that were previously in FIS Decision Support (DS) are now available in Cognos. These include the following 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.