skip to content
 

Q. How do I get a Cognos/UFS Login?

Access request forms will need to be completed for the following systems;

Q. I had a Raven password but forgot it

The Reporting team are not responsible for maintaining user passwords. If you need to have your password reset please read the instructions on the Computing Service website.

Q. I can’t login, Cognos says I do not have the right credentials

If you have had your Raven password for a while (before 1st Jan 2015) you may need to change it. You should only need to do this once.

Q. Why isn’t my report returning any data?

Have you got access to the right data? It is possible in some cases to run a report that appears to run normally but your security prevents you from seeing any data. Please remember that Cognos refreshes overnight, so if the data was not in CUFS or other database yesterday it will not be visible in Cognos today.

Q. How do I get access to the Cognos report building tools?

Most users can only view reports. If you believe your job role requires you to build reports in Cognos, you should in the first instance discuss this with your Admin Reporting Contact (see below).

Q. How do I request a change to an existing report?

If you want a change to be made to an existing report you should contact the FSG.System.Support@admin.cam.ac.uk with details of which report you would like changed and what changes you require. It may be that another report can provide the information you need, or some of this, if this is the case please also include details.

Q. How do I get a new report built?

You should contact the FSG.System.Support@admin.cam.ac.uk with details of which report you would like, if you already have something in Excel or Word please include this as an example . It may be that another report can provide some of the data you require, if this is the case please also include details.

Q. Why can some Cognos users view more reports and folders than others?

Some users can see more reports than others because they have a different user profile. The user profile is defined by the Admin Reporting Key Contact based on the job content and school/depatment of the access requester. If you feel you should have access to other reports, you should in the first instance speak to your Key Contact.

Q. What reports are available?

An Excel list of reports is available from the reports page.

Q. Why does the report sent to me not open correctly in Excel?

The Admin Reporting team may email you with reports attached in Microsoft Excel format. Most University users will find they encounter no problems when opening these reports, however if you find they open but have formatting errors and you're working on a Windows PC, the attached document might help. Fix: Opening .mht files in Excel

Q. My report isn’t showing all the data

Check that you have all rows selected or if there is a scroll down/next page button.

Q. Why can I not print my report in PDF format?

Some older versions of Adobe Reader need to be set to print as image before Cognos reports print. If you find you cannot print your Cognos PDF report, try following the notes attached below. Fix: Printing reports in PDF format

Q. Cognos 11 : What are the supported software environments ?

This link will take you to the latest available list of supported software : Computer settings for Cognos users.  

Q. Cognos Query Studio: How do I add a chart to my query?

Adding charts to a query can make it easier for the reader to understand trends and differences in the information they are viewing. Adding charts to your query

Q. Cognos Query Studio 11: How can I apply a conditional style to highlight exceptional data in my query?

To make it easier for the reader to spot exceptional results, conditional styles can be applied to data in your query, Defining Conditional styles

Q. Cognos Query Studio 11: How do I amend the summaries in my query?

Query Studio automatically summarises the quantifiable data in your query. Use these notes to help you amend or remove these summaries. Grouping and ungrouping data items

Q. When I run a Cognos report I get an error message (QE-DEF-0157) telling me "The model or package does not exist or you are not allowed to used it because of security settings." What does this mean?

The most common reason a user will see this message is because their security settings will not allow the report they are running to retrieve the data from the data source. If you get this message, in the first instance, contact the report "Owner" to find out if there is a reason you are not able to run the report. To find out who the "Owner" of the report is, go to the "Properties" of the report (icon under "Actions" in Cognos Connection).

Q. I cannot open the report I get sent via an email link. When I click on the link and passed the Raven login screen, a message box is displayed telling me "This window is trying to close" with options of either yes or no. Whichever option I choose results in the window closing without seeing the report?

This is most probably due to setting in your browser. If using IE open your internet options and ensure http://www.internal.admin.cam.ac.uk/ is listed as a trusted site. Then check you have downloads set as enabled.

Q. Cognos 11: Will the content of My Pages be automatically transferred over ?

Yes, in Cognos 11 they will be called 'My Content' .

Although, if you have any saved reports that you no longer use then please could you take the opportunity to delete them

Q. Cognos 11: Are the reports themselves changing ?

No : the reports, their location and their parameters are all remaining the same. The only difference is that the Public Folder is now called Team Content.

Q. Cognos 11: What will happen to reports scheduled to run during the upgrade period?

Any reports scheduled to be run during the downtime will be suspended automatically by UIS, who will then restart them once the system is restored.

Q. Cognos 11 : Are the reports still saved in the same place?

Yes : but the Public folder has now been renamed Team Content, whilst My folders has been renamed My Content.

Q. Cognos 11: Will my existing report views still work?

Yes, these will be copied across and you should be able to update any default parameters before you run a report.

If you experience any problems please contact FSG.System.Support@admin.cam.ac.uk with details of the report.

Q. Cognos 11: Will my existing schedules be copied across?

Yes, if linked to a copied/saved report under My Folders will be copied over alongside everything else

Q. Cognos 11 : Emailing reports error message saying an internal error occurred when submitting the request to run Team content

The emails are still being sent and we arre currently investigating the cause of the message

Q. Cognos 11: Will the address to log into Cognos change?

Yes, The new address will be updated automatically on the main Cognos log in pages. However, users will need to update any locally saved shortcuts. 

Q. Cognos 11 : I can't view the training videos

These are all hosted on Stream and should be viewable to anyone in the University. Make sure that you are logged into Stream (ie. have logged into your University Office 365 account) and for those in the UAS, you are not trying to log in via the ACN

Q. Cognos 11: Which browser should I use?

Internet Explorer and Firefox both currently work with Cognos 11. Internet Explorer is due to be retired and so it is advisable to use Firefox where possible. 

Q. Cognos query studio 11 : Firefox is not available on Citrix

We are investigating whether Firefox can be added to Citrix

Q. Cognos 11 : Can I still use the Grants Expenditure portal tab?

This is now available again from My Portal Pages. Drill down to detailed project and line item report not working, and is under investigation.

(updated  29 July 21)

Q. Cognos 11: Can I still add a bookmark to a favourite report?

We are investigating this at the moment, in the meantime we suggest that you save a copy of the report to your My Content to enable you to access it quicker

Q. Cognos 11: I am unable to upload a file or a link to My Content

This is a known issue that we are currently investigating

Q. Cognos 11: Logging in error message - DPR-ERR-2107 The User Capabilities Cache cookie cannot be decoded

This is linked to incompatibilities between versions for cookies - please delete your cookies. Guidance for clearing cookies

Q. How do I quickly re-run a report with slightly different parameters?

To change/re-select parameters once in a report, use the Run triangle at the top left of the report tool bar.
NB: This only works if you have run the report in PDF format. You can export to Excel (using the Run down arrow next to the Run triangle) once you have decided on your parameters.

 

Q. How can I create a login shortcut to the departmental shared folder?

  1. Navigate to the Department (Shared) Reports folder, select the elipses …(to right of folder), choose Create shortcut
  2. A pop up screen appears, select My content
  3. Select Create shortcut
  4. The selected folder is displayed as a shortcut in My content

CORONAVIRUS/COVID-19
FOR STAFF

Please see our CORONAVIRUS/COVID-19 Assistance pages for help with areas of Finance during the current situation.

UFS issued communications and the University website also contain information on this topic

Raven Login

Some items on this website are restricted. University members are encouraged to log in using Raven to make the best use of the site:
Login with Raven