Do I need to make changes to my system to run Cognos Reports?
Viewed 2353 times since Fri, May 16, 2008
Question: Do I need to make changes to my system to run Cognos Reports?
Answer: There is a guide published on the AFISM Resources page within the Cognos section that assists you in navigating through any issue you may be having with accessing Cognos or running reports. Many of the issues are not a fault with the Cognos system are caused by system settings and can be resolved by adjusting a fe...Read More
What report should my business managers look at to see their fund balance?
Viewed 948 times since Tue, Sep 30, 2008
Within the TTU Finance Folder of Cognos is a sub folder titled "Fund Balance Reports". These are the reports designed to provide you information regarding your Fund Balance. The most frequently Fund Balance report used is the FI009 - Statement OF Changes in Fund Balance by Fund.Read More
What report in Cognos show the current budget for a FOP?
Viewed 620 times since Thu, Sep 11, 2008
Within the TTU Finance > Budget Reports folder you will find the reports designed to provide budget information. The most frequently used of these reports include:
FI002 - Revenue Expense Budget Pools by FOP - This report displays at the budget pool level the budget details for the FOP(s) selected
FI004 - Revenue Expense Budget by FOP - This report displays by FOP only and provides drill down functionality to the transaction level
How do I find check numbers and dates per specific payment requests?
Viewed 530 times since Thu, Oct 9, 2008
Cognos offers several reports that provide check information for payments against a Purchase Order:
1. FI030 - Encumbrance Ledger Transaction Report - the check details are found in the bottom section of this report.
2. FI278 - Vendor Invoice Payee Research - search by Vendor Invoice Number or Purchase Order number to view payment details
3. FI142 - Total Spend by Vendor - search by FOP or Vendor Invoice Number to find payment details....Read More
Is there a Cognos Report that shows all transactions for the entire month ?
Viewed 440 times since Thu, Oct 9, 2008
There are several reports that provide the transactions that occurred during a Fiscal Period (month). To access these reports, from the Public Folders tab of Cognos, select the folder labeled TTU Finance. Within the TTU Finance Folder is a sub folder labeled Transaction Reports. Within this folder are the reports designed to provide transaction information. The most frequently used reports include:
For Operating Ledger Transactions:
How do I run a report in PDF format?
Viewed 436 times since Wed, Feb 25, 2009
Answer: There are two options for running a report in PDF format:
Prior to executing the report rather than clicking on the report name link, choose the blue arrow icon found in the Actions column to the right of the report link. Select PDF as the format in the box provided, then select run and populate the parameter page as desired.
2. After executing the report choose the format select drop down in the upper right sectio...Read More
Is there a report or reports that provide a listing of FOPs under particular PI’s, Depts, Colleges?
Viewed 343 times since Fri, Oct 3, 2008
There are several reports that provide this information within the TTU Finance folder of Cognos. If a listing of the FOPs without budget details is desired, use the FI106 - Valid FOP Report that is found in the TTU Finance > FOAP Reports folder.
For a listing of FOPs that includes budget information, within the TTU Finance Folder, select the Budget Reports Folder and execute one of the following reports:
FI025 - Revenue/Expen...Read More
When will Cognos not be available due to the nightly table loads?
Viewed 340 times since Mon, May 4, 2009
The ODS refresh process begins when the Finance/AR load to Banner starts at 8:00 p.m. and is guaranteed to be available the following morning no later than 7:00 a.m. Anyone running reports during those hours should expect the data to be changing and any work done in Banner between 8:00 p.m. and 7:00 a.m. should not be expected in the ODS the next day.Read More
Is there a report in Cognos that shows all of the employees in an ORGN and their leave balances?
Viewed 303 times since Tue, Dec 9, 2008
The HR030 - Employee Current Leave Balances Report provides this information. To access this report, within Cognos select the folder labeled Human Resources > Departmental Users > Web Leave Reports.Read More
Which Cognos Report shows tha mount of interest accrued each month on our Fund Balance?
Viewed 303 times since Tue, Feb 17, 2009
Question: Which Cognos report shows the amount of interest accrued each month on our fund balance FOP?
Answer: The report that shows the information about the interest accrued on the Fund Balance FOP is the FI009 - Statement of Changes in Fund Balance by Fund. Read More
What report shows all FOPs assigned to an Organization Manager?
Viewed 291 times since Mon, Dec 8, 2008
The FI106 - Valid FOP report provides a listing of all FOPs assigned to an Organization Manager. This report is located in TTU Finance > FOAP Reports folder of Cognos.Read More
What does the term fiscal year refer to in my reports?
Viewed 290 times since Tue, Jun 10, 2008
The Fiscal year is the 12 month period beginning on September 1st and ending on August 31st. This is directly related to the academic year.Read More