Reminder

Cognos CoP Meetings are Recorded, see OneDrive link at top of page

Cognos to 12.0.4 FP2

All done

Full Upgrade

Cognos in October

Chrome Issue

Resolved by updating to the latest Chrome version.

Works in DEV/QA but No Data in PROD

Using a data module.

If you are using a data module or uploaded data, make sure the data module is migrated too.

If your data module is in a different folder than your report, but sure to ask for both or ask for a root folder that contains both sub folders.

How will Student PID change in SAH?

SAH from TSS

How will Student PID change in EAH/FACAH?

202606 EAH Release Notes

How will Student PID change in FINAH?

Whatever happens in Oracle will be reflected in FINAH.

Shortcuts / URL Link / Favorites / Bookmarks

Demo of how to jump around in Cognos.

How does employee data know if an employee is a student?

That would be a question for BAH > HR/Payroll > Ask Questions.

Is there an Employee ID / Student PID cross walk?

Union as a Join

See recording for demo

Reminder

Cognos CoP Meetings are Recorded, see OneDrive link at top of page

FP vs Upgrade

Qualys Vulnerability Report - security monitoring tool to identify server risk

Fix Pack (FP) Update - mini upgrade, targeted to the risk, low impact, little notice, BIA does testing

Full Upgrade - more likely to impact reports, introduces new features, lots of notice, requires report testing

Cognos to 12.0.4 FP2

Cognos DEV - done

Cognos QA - done

Cognos PROD - next week Wednesday or Friday

Full Upgrade

Tableau in September

Cognos in October

Cognos Access

Active Directory (AD) group

Access and Security

AH Security FAQs

Cognos Core/Restricted vs P4

Access and Security

New table at the bottom

Reminder

Cognos CoP Meetings are Recorded, see OneDrive link at top of page

Audit Report demo

See recording for demo of report

How Cheryl Kettnich monitors the testing and usage of her Cognos reports.

Tips:

• Filter [Report search path] for your folder(s) right away

• Bring in Employee data separately and do a join to speed up report

“Audit” package

Available to all report developers

Cognos DEV > Team content > Cognos Audit Reports & Packages

"Run Reports" has most of the audit information you want.  "Employee” has the employee information.

You can select Audit_D, Audit_Q or Audit_P to see activity in Cognos DEV, Cognos QA or Cognos PROD.

Employee data is coming from EAH, so you will see a Hana prod. This is the employee’s Primary position only.

Tips:

• The Audit package shows each time a report or draft or view is run

• Only the last ~15 months is included

• Employee data is for their current, primary position.

• ‘Unsaved report’ is a draft

• ‘UCMID’ report is saved to My Content area

• Can use the error message for alternate troubleshooting

Not Included:

• Fields names

• Prompt information

• Output type

• History of Employee

• Original report for a report view, location of original report

Cognos upgrade

ETA September

Reminder

Cognos CoP Meetings are Recorded, see OneDrive link at top of page

Open Q&A - Multiple rows at a different grain are inflating my numbers, how do I focus my aggregation?

See Demo.

When working with subqueries and joins and multiple grains it is important to note that some aggregations will work before a join, after a join or both. If the aggregation in the summary view is not working, try creating the same aggregation in a subquery and then just displaying that value in the summary query.

Other tips:

-look at only one or two records at a time to make sure you math is working

-you can create separate fields, one for each step of math or you can use one field with all the math steps in one, it’s up to you

Reminder

Cognos CoP Meetings are Recorded

BAH Question

How can we add a report?

Go to the BAH page you want the report added to and click ‘Make a Request’ > ‘Contribute a Report’.

Cognos AI Functionality

BIA is exploring

-Security risks, AI needs to use Cognos security

-Support model. How does BIA provide documentation, training, etc for AI in Cognos

Number is in triple, why?

If you see a number being multiplied is it almost always b/c there are more detail rows included with the level in which you are trying to summarize.

Investigate the data until you determine what the additional rows are created by, you will see unique data in those rows. Then tell Cognos to summarize without those rows by (1) adjusting your join, (2) making a less detailed join key, (3) adjusting your field aggregation or (4) hard-coding the summation. Use the option that works best for you and your report.

1. Adjusting your join may impact other totals in your query.

2. You can make your own join key by concatenating unique or important fields in your query. This will help Cognos match rows directly.

3. Adjusting your field aggregation may impact your display, double check.

4. Hard-coding the summation tells Cognos the specific field you want to include in your total / maximum. Test the hard-code out in different queries to tell Cognos when to apply it in order to reach the number you need.

   1. Example: Maximum([Amount] for [Year], [Quarter], [Department])

   2. Example: Total([Count] for [Department], [Project])

   3. Example for an entire report total so you can do % total: Total([Dollars] for report)

Reminder

Cognos CoP Meetings are Recorded

Access and Security

New table listing the various levels of security

If you know your AD group for your team, please email busintel@ucsd.edu and I’ll add it to this table = AH Security FAQs .

Can a prompt page tell the users if they have forgotten to fill out a required prompt?

At this time, not automatically.

You could, maybe, add a ‘check prompts’ button to check if the required prompts are populated and if they are then the ‘submit’ button could appear.

VC Name and UC Code changes

Will be coming in UC Path (EAH) and Hire Online. Check your filters if you are focused on VC Name/Code.

Reminder

Cognos CoP Meetings are Recorded

Have SIS ID / Bar Code, how do I get to Student PID?

Start with AH Field List Report

Find the View with those two fields

If the View Type = “Column Groups Only” then you’ll need to ask a data integration person to pull that data from the column groups associated with that View.

How does Cognos Bursting work

1. Set up the report w/ a field for email addresses

2. Enable report to ‘burst’ on email address

3. Schedule the report to ‘burst’

Report will check to see if there is data for that email address.

The Schedule will determine how often the report checks for data.

Why does Excel Data and CSV only download the first tab?

This has been a limitation since Excel Data / CSV download was introduced.

IBM’s answer is to use the regular Excel option.

EAH Row-Level Security Report has moved

https://bianalytics.ucsd.edu/ibmcognos/bi/?pathRef=.public_folders%2FActivity%2BHub%2FActivity%2BHub%2BMetadata%2BReports%2FEAH%2BRow-Level%2BSecurity%2BReport

Not finding Hire Date in EAH from UCPath

Best person to ask is BAH > HR/Payroll > Ask a Question

Email will open a ticket for the UC Path Reporting team.

SAH-TSS Data

SAH from TSS

Will there be data conversion? No, just raw data from TSS.

Adding lots of IDs to a filter

Pre-format your list of IDs in Excel then paste into filter

="'"&C2&"', "