Reminder

Cognos CoP Meetings are Recorded

Cognos 12 Upgrade

Cognos 12.0.4 - Jan 10 to Jan 31, 2025

Feedback can be emailed to busintel@ucsd.edu

Cognos Migrations

Migrations are completed at the folder level

Cognos data connection policy

Interim Solution - Adding Data to Cognos or Tableau

In Cognos DEV - Can be set up between your -DEV, -QA and your -Prod servers

In Cognos QA - Can be set up between your -QA our -Prod server, should be -Prod server most of the time

In Cognos PROD - Always set up only for your -Prod server

Cognos COP Questions

CS2368148

1. Where can I find the data for unsubmitted (draft form) UCPath SCTs and Direct Retros? I was hoping there is someplace I can go to see all the SCTs that have been created but not submitted. So far my report only shows the pending ones. = Routing to David Mandell

2. I need help inserting a column with data from an excel into my cognos crosstab. We discussed how to do this during last Cognos COP, but were unable to successfully demo it on the call.

3. I need help with the logic for a join. I want to join a table with data from EAH and FinAH with the pay run code on EAH and original transaction reference on FinAH as the join. I was unsuccessful and wanted to troubleshoot why. = Subtotal/Total fields created by Cognos for the display fields were interfering with the join results b/c they were brought into the joined query.

Best Practice

• Add your subtotal/totals for display last

• Create a subquery of your query so you have two queries for your two different display options

Query Calculation Null

Why can’t you add a null field to a crosstab

Next Time

Add Excel budget to FIN crosstab.

• Add Excel to Cognos

• Add Excel to Data module

• Join Excel w/ Data

• Add Budget field to crosstab