Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Topic

Notes

Reminder

All Sessions are Recorded and saved to the OneDrive location listed above.

Cognos Upgrade in January

Office Hours = Monday 1/13/25

Join Zoom Meeting

https://ucsd.zoom.us/j/99716674289?pwd=6y6OvbaK8bfVYGFLRMWZhHKztlYJzw.1

 Meeting ID: 997 1667 4289

Password: 688490

Cognos 12.0.4 - Jan 10 to Jan 31, 2025

Cognos Upgrade Question

What are the expected changes in the 12.0.4 compared to current Cognos version?

Heard of the Select & search Prompt to be refreshing as a standalone instead of all the prompt page refreshing is that true if so how does that work in the new version?

2024-10-29

Topic

Note

Reminder

All Sessions are Recorded and saved to the OneDrive location listed above.

Cognos FAQ

Add to Cognos FAQ page:

  • How do you know what AD groups have what access to what folders in what Cognos environment.

  • For customer testing, is it better to send them to Cognos DEV > Business User Development or Cognos QA. Add pros & cons.

  • Can I build joins in a data module? Yes. If your team has a specific need that is repeated across multiple reports then go ahead and do the join the the data module.

  • Is there a limit to the number of queries, sub-queries, joins and union you can put into a Cognos report. Technically no but the more you put into your report the longer the report will take to run.

  • What’s the different between run Excel and run Excel Data? Excel includes formatting and all tabs, Excel Data removes the formatting but only shows for first tab.

  • When do I need a data module. When you want to blend multiple data sources. Excel + Excel. Package + Package. Excel + Package.

  • How many data sources can I put in a data module? We don’t know yet but we’ve see data modules with up to 5 data sources.

How do I add a blank column to my report?

Add a new column using Query Calculation set to null.

...