Tips and Tricks

Problem: You are in Cognos browsing the folders. You click on a report name intending to run it. You get a mostly blank screen. You are running Microsoft Internet Explorer (MSIE). Solution: Use MSIE's Compatibility view...
Here are some tips and tricks for the Cognos search prompt.
Want to keep the column headers on screen when scrolling down a long list?  Right-click anywhere in the list and choose Freeze Column Headings.
A pop-up menu appears when you right click in a list. A pop-up menu appears when you right click in a list.

Keep in mind:
  • This works only in HTML output.
Getting frustrated trying to drill from m-Fin FINANCIAL DETAIL?
Drills offered in m-Fin FINANCIAL DETAIL

    SUMMARY reports summarize to speedtype/FOPPS. TOTAL reports summarize to fund. Example: Run m-Fin REVENUE AND EXPENDITURE SUMMARY for a set of speedtypes. You get one page for each speedtype. Run m-Fin REVENUE AND EXPENDITURE TOTAL for the same set of speedtypes. You get a page for each fund and then a final page summing all funds. SUMMARY reports keep speedtypes separate. TOTAL reports do not.
    Do you see accounts like 422415 -- ALLSTD FAC NRSTTNDPTP NHRMS in your reports and wonder what they mean? Here is something that can help: Account Legend.
    Looking for an m-Fin report that seems to have gone missing? Perhaps it is simply on the next page. The Cognos environment that lists the available reports is called Cognos Connection. Its default is to show up to 15 items at a time. When there are more than 15, paging controls in the upper right become active. Use these controls to advance though the list or temporarily change the size of the list.
    Revised 13-Mar-2012 With Cognos 10, MSExcel output format choices are
    1. Excel 2007 Format
    Most m-Fin reports render PDF in landscape orientation. A few do not, however, such as m-Fin OUTSTANDING ENCUMBRANCES. You can override this. Rather than clicking on the report name itself, use its Run with options button. Ignore everything here and proceed directly into the advanced options.