Cognos Status

Resolved issues are shown below current issue list: resolved issues.

9/9/09

ISSUE: Cognos reports scheduled to run before 8am will run slowly and will interfere with other scheduled reports.
AFFECTED PROCESS/AUDIENCE: Cognos scheduled report users
EXPECTED RESOLUTION TIMEFRAME: N/A
WORKAROUND (IF ANY): Do not schedule Cognos reports to run prior to 8am
COMMENTS: Based on the completion time of automated overnight processes, Cognos reports scheduled to run before 8am will not be able to complete in a timely manner and will significantly slow report delivery for other users.

2/13/09

ISSUE: Viewing Cognos reports with Mozilla Firefox version 3.0+ on a Mac:
- Scrollbar not appearing
- Dropdown not appearing
AFFECTED PROCESS/AUDIENCE: Cognos reports for Mac users
EXPECTED RESOLUTION TIMEFRAME: N/A
WORKAROUND (IF ANY): Use Mozilla Firefox version 2.0 or lower – Safari is also not officially supported; scrolling can still be done with arrow keys or via touchpad; dropdown will work if user clicks anywhere in the prompt box (there is just no downward arrow).

AFFECTED REPORT
ISSUE
EXPECTED RESOLUTION DATE
WORKAROUND/COMMENTS
All Non-approved expense reports will display as expenses, not encumbrances. For Grants related reports, F&A will not be calculated until the expense report is approved. TBD  
GL005
Summary Budget Status		 If you run this report for a large number of departments/projects, the output may be too large for Excel 2002.
N/A If your Excel version is older than 2007, either (1) run the report for a single or small set of departments/projects, OR, (2) if you are running this report for a large number of departments/projects, select CSV or HTML output.
GL061
Agency Project Detail		 Occasionally this report yields an Oracle error message.  This happens rarely and intermittently, and will require a patch from the vendor. Fall 2009 If you get an Oracle error message, try again to run the report; usually the second attempt is successful.
GM021
Projects with Negative Balances		 Report is not returning results based on prompt criteria. Fall 2009 Run the GM044 and look for negative balances.
GM023
Multi-Project Summary		 Report is temporarily unavailable. Fall 2009 Run the GM044 or GL008 for individual projects.
SC016
Open Encumbrance Report		 There have been a number of questions as to why Canceled transactions REQs/POs are appearing on this report for the prior month. There may be some anomalies associated with the data that are displaying in this report. TBD  
FM008 Job Cost Summary Report

 

Report is not currently available.


Fall 2009 WORKAROUND (IF ANY): Contact facilities-management@northwestern.edu to obtain Job Cost information. Please note your WO number.

COMMENTS: This is the report that summarizes job cost information. FM will be able to provide information to users, so please contact them for support.

 

 

RESOLVED ISSUES

11/18/09

ISSUE: On the GM035, when users attempt to select a department using the tree prompt, they receive an error when the report runs.
AFFECTED PROCESS/AUDIENCE: Users of GM035 Cognos report
EXPECTED RESOLUTION TIMEFRAME: Tuesday, Nov. 24
WORKAROUND (IF ANY): Instead of using the tree prompt, enter departments using the select & search option instead.

11/18/09

ISSUE: Incomplete data load
AFFECTED PROCESS/AUDIENCE: Users of Cognos reports listed below and NUFin ad hoc
EXPECTED RESOLUTION TIMEFRAME: Resolved as of 11am

The following reports are affected:
1 - FM003 - Capital Project Financial Position - Summary
2 - FM004 - Capital Project Financial Position - Detail
3 - GL003 - Off-cycle budget changes report (YTD)
4 - GL004 - Off Cycle Budget Changes (month to date)
5 - GL005 - Budget status report - summary
6 - GL009 - Expense/Revenue Budget
7 - GL010 - Budget books by object/rev by category
8 - GL010 - Operating Budget Report
9 - GL011 - Historical budget performance
10 - GL012 - Project By Attribute/Activity Designated Funds
11 - GL013 - Year End Performance Review Report
12 - GL019 - Plant Fund Open Accounts Balance and Cash Summary
13 - GL021 - Gift Setup and Closure Queries
14 - GL023 - Detail of Unexpended Plant Expenses
15 - GL024 - Open and Uncleared Deposits (using staging application record)
16 - GL025 - Faculty Start-up Attribute Summary (Faculty/PI)
17 - GL026 - Faculty Start-up Attribute Summary
18 - GL027 - Non-generated Subsystem Journals
19 - GL056 - Budget Journal Detail (Adjustment)
20 - GL061 - Agency Project Detail
21 - GL062 - Gift/Endowment Project Detail
22 - GL063 - Gift Clearing Report
23 - GL064 - Project By Attribute/Activity Non-Designated Funds
24 - GL065 - Endowment Summary Report
25 - GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
26 - GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
27 - GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
28 - GL071 - Financial Summary - Historical Comparision (Excluding Agency and Multi-Year Funds)
29 - GM017 - Cost sharing status report
30 - GM018 - Sponsored Project Subcontractor Billing Status Report
31 - GM020 - Report of Project Expenditures for Awards with Carryover Restrictions
32 - GM021 - Query Name: Award-Project End Date Reconciliation
33 - GM037 - Unobligated balance report
34 - GM041 - Budget category report
35 - GM042 - Overspent budget categories report
36 - GM044 - Sponsored Project Portfolio
37 - GM045 - Sponsored Project Budget Statement

 

11/12/09

ISSUE: GL008 Revenue & Expense Activity Report reflects data as of 5pm Tuesday, Nov. 10.
AFFECTED PROCESS/AUDIENCE: GL008 only
EXPECTED RESOLUTION TIMEFRAME: Resolved: data reflected is as of 5pm Thursday, Nov. 12.
COMMENTS: All other reports (GL005, GL068, etc.) are up-to-date and real-time reports are unaffected. For a list of real-time reports, see:

http://cafe.northwestern.edu/resources/tips.html#realtimereports

11/6/09

ISSUE: Transaction improperly labeled as Payroll Encumbrances on GL008
AFFECTED PROCESS/AUDIENCE: Users of Cognos report GL008 whose chart strings required a manual correction to encumbrance balances as part of fiscal year end close
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): The transaction amounts associated with these lines are correct; the transaction label is the only component in error. All encumbrance subtotals and totals on the report are correct.
COMMENTS: A series of correcting journal entries were performed between period 12 of FY09 and period 2 of FY10 to remove encumbrance balances from FY09 and, as appropriate, move them forward to FY10. The resulting transaction lines are being labeled as “Payroll Encumbrance” rather than “Journal” on the report. Attempts to use the drill through to detail will not produce results.

10/21/09

ISSUE: Some chart strings have incorrect pre-encumbrances and encumbrances posted in September.
AFFECTED PROCESS/AUDIENCE: Users of affected chart strings (see below for link to list)
EXPECTED RESOLUTION TIMEFRAME: Resolved with October close
COMMENTS: As part of the FY09 close, several chart strings had remaining encumbrance and pre-encumbrance balances because the associated offset was posted in FY10/September instead of FY09. These amounts were brought to $0 in order to close out FY09. The offset amounts in September have been resolved. We have corrected the FY10 amounts.

Please see our full announcement, including a list of affected chart strings:
http://cafe.northwestern.edu/announcements/encumbrances.html

We have also posted an explanation that shows an example of a correction:

Encumbrances Correction Explanation PDF icon

 

9/24/09

ISSUE:

Some users had difficulty running reports in preparation for FY09 close because we began using the organizational structure for FY10 in Cognos on 9/1/09. This structure includes department moves and new departments that only became effective with the new fiscal year.

  • In order to facilitate analysis of data for the FY09 close, all Cognos reports now reflect the FY09 department organizational structure (as of 8/31/2009).
  • Cognos reports run for FY10 periods do not currently include changes to the department organizational structure made on or after 9/1/2009.

AFFECTED PROCESS/AUDIENCE: Cognos report users using department tree node parameters for areas that were impacted by 2010 organizational changes.
EXPECTED RESOLUTION TIMEFRAME: Resolved during October period close.
COMMENTS: As of 11/6/09, the FY10 department structure is in effect. For more information see:

http://cafe.northwestern.edu/announcements/structure.html

11/2/09

ISSUE: GL008 temporarily unavailable
AFFECTED PROCESS/AUDIENCE: GL008
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: GL008 data is now as of 5pm Monday.

ISSUE: GL008 reflects data as of 5pm Thursday.
AFFECTED PROCESS/AUDIENCE: GL008
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: All other reports (GL005, GL068, etc.) are up-to-date and real-time reports are unaffected. For a list of real-time reports, see:

http://cafe.northwestern.edu/resources/tips.html#realtimereports

10/14/09

ISSUE: Cognos Reports and KK inquiry screens in NUFinancials may be out of sync.
AFFECTED PROCESS/AUDIENCE: Users of KK inquiry screens
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Run Cognos reports such as GL008, which will reflect data accurately according to Fiscal Year and Accounting Period. If using KK Overview, you may notice discrepancies for a given
budget period that are not reflected on the Cognos reports for the same fiscal year. These discrepancies are being corrected.
COMMENTS: Cognos and NUFinancials interpret data differently based upon the utilization of Fiscal Year vs. Budget Period. Certain transactions have posted to commitment control with a budget period of 2009 and fiscal year of 2010. Because KK Overview utilizes budget period and the Cognos reports utilize Fiscal Year, these transactions may appear in different periods between Cognos and NUFinancials. Café is working to correct those transactions so that the fiscal year and budget period values are consistent.

10/7/09

UPDATE:

ISSUE: Data for all reports is as of 5pm Tuesday.
AFFECTED PROCESS/AUDIENCE: Cognos Report Users
EXPECTED RESOLUTION TIMEFRAME: Resolved

10/2

ISSUE: Payroll and fringe expenses are understated on Cognos reports
AFFECTED PROCESS/AUDIENCE: Users of Cognos budget statement reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: An Encumbrance journal dated 9/30/09 was posted, but the corresponding HR (expense) journal failed due to an error. This issue has been resolved in NUFinancials. Cognos reports will be updated the morning of 10/5.

10/2

UPDATE ON GL008 ISSUE 8am

The GL008 Revenue & Expense Activity Report now displays data as of Thursday evening (10/1).

10/1

UPDATE ON GL008 ISSUE 8am

All reports (including GL008) now display data as of 6pm on 9/30.

9/30

UPDATE ON GL008 ISSUE 11am

  • Due to ongoing performance issues, GL008 still reflects data from Sunday (for accurate balances, please see workaround below).
  • Tonight we will run an update so that it will reflect data as of 5pm Tuesday.
  • All other reports (including GL005, GL068, and GM045) are up-to-date at this time.

UPDATE ON GL008 ISSUE 8am

The GL008 update is not complete. We are still experiencing performance issues which may be hardware-related. We will update this page as more information becomes available.

9/29/09

ISSUE: The last update for GL008 data was 7am on Sunday, 9/28.
AFFECTED PROCESS/AUDIENCE: GL008 Revenue & Expense Activity Report Users
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: A hardware issue prevented last night's update. We continue to investigate the cause of the slower than normal functioning.

  • In order to provide accurate GL008 information tomorrow (and allow for the possibility that tonight’s load will also take longer than normal), we will begin updating again today at 5pm.
    • This means that tomorrow (9/30) Cognos reports will reflect all year end data-related updates completed by 5pm today in NUFinancials.
    • Reports should then reflect batch processing (e.g., AP payments, inbound interface processing, F&A) through Monday night.
    • Batch processing for this evening would NOT be reflected in Cognos reports.
  • As of 9/30, GL008 data should reflect the complete FY09 PO roll; currently GL008 data only reflect the PO roll for December and January.
  • Today we are completing the cleanup of FY09 expense reports, integrating remaining FY09 EX and GL transactions to the Grants module, and running the final FY09 F&A. We will also continue to clean up PO and requisition transactions as testing is completed. These activities should be reflected in Cognos reports on 9/30.

WORKAROUND: To obtain accurate balances of FY09 activity today, use Budget Overview Inquiry in NUFinancials. Select “Detail Accounting Period” as the “Calendar Type” for the inquiry (see page 4 of the job aid below for more information).

http://cafe.northwestern.edu/documents/training/gl/722/ViewBudgetPerformBudgetOverview.pdf

 

9/28/09

ISSUE: Users will notice inconsistencies between KK Budget Overview and Cognos Budget-related reports (GL005, GL008, SC016, etc.)
AFFECTED PROCESS/AUDIENCE: Cognos budget-type report users who use these reports to track encumbrances
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: POs that were rolled/carried forward from FY09 to FY10 over the weekend are not yet fully reflected in the Cognos reports because this data was not yet available when the Cognos was updated on Sunday.

 

9/21/09

ISSUE: All Cognos InfoEd warehouse reports
AFFECTED PROCESS/AUDIENCE: All users of Cognos InfoEd reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND: Re-run the report after 3:00 pm, September 21, 2009
COMMENTS: The daily procedure that updates InfoEd data did not function properly last night. The issue was initially fixed for all reports except GM085-Pending Proposals-All Roles. All reports are now functioning properly.

9/14/09

UPDATE
ISSUE: Sponsored Project direct costs posted on August 31 had their associated F&A expense created with a September Accounting Date.
AFFECTED PROCESS/AUDIENCE: Users of Grants Management data.
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: On August 31st, a process in the Nightly Batch began processing transactions on August 31st and ended on September 1st. August expense transactions handled by the process after midnight received an F&A transaction with an Accounting Date of September, rather than August.
Commitment Control Budget Overview and Cognos Grants Reports using KK ledger data (GM045\GL008) may reflect F&A expenses in the month of September, with no corresponding direct expenses.

ISSUE: Report GL008 - Revenue and Expense Activity Report is running very slowly this morning.
AFFECTED PROCESS/AUDIENCE: Cognos
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Re-run the report after 10:30am
COMMENTS: The issue resulted from Index creation job failure. There may be a backup in queued reports from this morning, but this should ease as the day progresses.

9/11/09

ISSUE: Cognos reports for users with access to ALL department ids returned inconsistent results
AFFECTED PROCESS/AUDIENCE: Cognos users with access to ALL department ids
EXPECTED RESOLUTION TIMEFRAME: Resolved at 9:25am
WORKAROUND (IF ANY): Re-run the report
COMMENTS: A report that was scheduled to run with a prompt saved in the project id field would have returned blank or incomplete data. This issue occurred because the central security run failed.


ISSUE: Report GL008 - Revenue and Expense Activity Report not returning data for reports run before 8:10am today
AFFECTED PROCESS/AUDIENCE: Cognos
EXPECTED RESOLUTION TIMEFRAME: Resolved at 8:10am
WORKAROUND (IF ANY): Re-run the report
COMMENTS: Schedules for all reports other than GL008 should have run normally. GL008 reports scheduled before 8:02am were blank; any GL008 reports that were run/scheduled before 8:40am were slow.

9/4/09

ISSUE: Nightly load of the reporting data is running late
AFFECTED PROCESS/AUDIENCE: GL008 - Revenue and Expense Activity Report run before 9 am
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Rerun the report after 9 am.
COMMENTS: If the report was originally scheduled before 8 am, rerun the report to ensure accurate data.

9/3/09

ISSUE: The SC027 – Match Exception Report by Department is currently not summing correctly.
AFFECTED PROCESS/AUDIENCE: Requesters
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Users can continue to Check for PO issues via Purchasing > Purchase Orders > Review PO Information > Activity Summary and or Document Status
COMMENTS: If there is more than one exception attributed to the transaction, it is incorrectly multiplying the Voucher Quantity, Voucher Unit Price, Voucher Merchandise Amount and PO Price by the number of match exceptions. Match Exceptions are still being resolved by AP and PRS.

9/2/09

ISSUE: Portal Actuals journals entered for FY09 (by changing the date on the portal) are accurately recorded to period 12, fy09 on Cognos reports, but are posted to period 01, FY10 in PeopleSoft.
AFFECTED PROCESS/AUDIENCE: Users of portal journals
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): None
COMMENTS: The portal functionality has been modified and the journals in error have been fixed.

8/27/09

ISSUE: Encumbrances for FY09 Purchase Orders created during the period from 8/24-8/26 (when two fiscal years were open) are being reflected in Period 1, FY10, rather than Period 12, FY09.
AFFECTED PROCESS/AUDIENCE: NUFinancials and Cognos reports
EXPECTED RESOLUTION TIMEFRAME: ASAP
COMMENTS:

  • This issue only affects FY09 Requisitions that were Approved and Sourced into Purchase Orders during the period from 8/24 – 8/26 (when two fiscal years were open).
  • The POs were dispatched to vendors as normally scheduled. 
  • We are currently working toward resolving this issue so that FY09 encumbrances and expenses are properly reflected in the correct fiscal period.

8/20/09

ISSUE: Drill down to Salary Detail report from GL008 amounts are off by $740.67 for journal ID HR00027899 and Journal_line = 3760. Amounts ARE correct in GL005 and GL008
AFFECTED PROCESS/AUDIENCE: Users of Salary Detail report from GL008
EXPECTED RESOLUTION TIMEFRAME: Close of business Monday 8/24
WORKAROUND (IF ANY): Use GL005 or GL008 dollar amount, not the Salary Detail amount.

9/01/09

ISSUE: Report SC016 – Open Encumbrance Report is not returning data
AFFECTED PROCESS/AUDIENCE: All users of Cognos reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Log into NUFinancials > Purchasing > Purchase Orders > Review PO Information > PO Accounting Entries...then go to KK Activity Log.

8/25/09

ISSUE: The data for the reports listed below are as of Thursday, 8/20/09. Data refresh for these reports did not run as scheduled.
AFFECTED PROCESS/AUDIENCE: Cognos warehouse-based reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Use GL008 or KK Inquiry pages in NUFinancials
COMMENTS: Tonight’s refresh will get the data as of 08/24/09. FAMIS and real-time reports are not affected. For a list of real-time reports, see: http://cafe.northwestern.edu/resources/tips.html#reports

8/24/09

ISSUE: Cognos reports scheduled to run this morning are not completing. Also, Cognos is running slowly.
AFFECTED PROCESS/AUDIENCE: All users of Cognos reports
EXPECTED RESOLUTION TIMEFRAME: Monday August 24, 2009
WORKAROUND (IF ANY): None
COMMENTS: As of 9:45am, 20 jobs are completed and approximately 20 are in queue.

8/13/09

ISSUE: Payroll and fringe expenses in Cognos reports are understated; Payroll and fringe expenses in NUFinancials inquiry pages are now correct.
AFFECTED PROCESS/AUDIENCE: Cognos budget statement reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: This issue occurred because the payroll encumbrance file was processed correctly but the corresponding payroll expense file was not. This issue was resolved during Wednesday night's batch processing.

7/27/09

ISSUE: Account dimensions failed during ETL load.
AFFECTED PROCESS/AUDIENCE: All users using Warehouse Reports (before 7:30am)
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: The Account dimension had failed during last nights ETL run. It was fixed today morning at around 7:30am. This means any user had scheduled warehouse reports before 7:30am would have failed. Users should re-run the reports.

7/24/09

ISSUE: GL068 & GL070 are returning all zeros.
AFFECTED PROCESS/AUDIENCE: Users of GL068 & GL070
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: This was caused by a data error and was fixed as of 11am. Anyone still seeing all zeros should contact the Help desk: consultant@northwestern.edu or 1-HELP, option 2.

7/21/09

ISSUE: Payroll and fringe expenses in NUFinancials inquiry pages and on Cognos reports are understated
AFFECTED PROCESS/AUDIENCE: NUFin users with payroll or salary-related access and users of Cognos budget statement reports
EXPECTED RESOLUTION TIMEFRAME: 8am Wednesday, July 22
COMMENTS: This issue occurred because the payroll encumbrance file was processed correctly but the corresponding payroll expense file was not. This issue should be resolved during tonight’s batch processing.

7/15/09

ISSUE: Payroll and fringe expenses on Cognos reports and on NUFin inquiry pages are overstated
AFFECTED PROCESS/AUDIENCE: Users of Cognos budget statement reports and NUFin users with payroll or salary-related access
EXPECTED RESOLUTION TIMEFRAME: 8am Thursday, July 16
COMMENTS: This issue occurred because the payroll expense file was processed correctly but the corresponding payroll encumbrance file was not. This issue should be resolved during tonight’s batch processing.

7/14/09

UPDATE 7/15

ISSUE: Scheduled GL008 reports run before 9:40am today may contain data from Friday, 7/10/09
AFFECTED PROCESS/AUDIENCE: Cognos GL008 - Revenue and Expense Activity Report
EXPECTED RESOLUTION TIMEFRAME: Original GL008 data issue resolved as of 9:40am Wednesday, 7/15/09
WORKAROUND (IF ANY): Use the KK inquiry pages and associated drill through capabilities in NUFinancials
COMMENTS: Nightly load of the reporting data for the GL008 did occur last night, however, the process did not complete until 9:40am, thus scheduled reports run before that time may display incorrect data.

7/9/09

ISSUE: GL068/GL070 - The “Recognized Revenue” column is not correctly reporting fiscal year-to-date revenue.
AFFECTED PROCESS/AUDIENCE: Users of GL068 and GL070 Cognos reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Use GL005 and GL008 in the interim

7/2/09

ISSUE: Payroll and fringe expenses on Cognos reports and on NUFin inquiry pages are understated
AFFECTED PROCESS/AUDIENCE: Users of Cognos budget statement reports and NUFin users with payroll or salary-related access
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: UPDATE 1pm 7/2: The HR actuals journal has now posted in NUFin. UPDATE 7/6: Cognos reports are now correct.

6/24/09

UPDATED 6/25
11am
ISSUE: Payroll and fringe encumbrances on Cognos reports were overstated
AFFECTED PROCESS/AUDIENCE: Users of Cognos budget statement reports and NUFin users with payroll or salary-related access
EXPECTED RESOLUTION TIMEFRAME: Friday morning 6/26
COMMENTS: As of 11am Thursday, the encumbrance journal has posted to NUFinancials, so the numbers should be correct there. Cognos reports remain incorrect at this time but will be correct tomorrow (Friday) morning.

6/9/09

ISSUE: The drill through from GM044 to GM045 Sponsored Project Budget statement is not working properly for June.
AFFECTED PROCESS/AUDIENCE: GM044/GM045 users
EXPECTED RESOLUTION TIMEFRAME: Resolved
WORKAROUND (IF ANY): Run the GM045 separately for current month data

6/8/09

ISSUE: GM044/GM045 Grants budget statements are not correctly reporting fiscal year to date or inception to date expenses when run for prior periods. THIS INCLUDES THE MAY CLOSE REPORTS.
AFFECTED PROCESS/AUDIENCE: All Sponsored Projects users
EXPECTED RESOLUTION TIMEFRAME: Resolved as of 3:45pm on 6/8
COMMENTS: June data was accurate during this issue.

6/3/09

ISSUE: GM045/GM044 June 2009 numbers are incorrect
AFFECTED PROCESS/AUDIENCE: All Sponsored Project users
EXPECTED RESOLUTION TIMEFRAME: Before month-end reports are ready
WORKAROUND (IF ANY): Run GL008 to get June transactions. Run GM044/GM045 to see any transactions before June.
COMMENTS: The GM044 Sponsored Project Portfolio and the GM045 Sponsored Project Budget Statement are producing incorrect numbers if you run them for FY 2009 AP June. For this case, all columns on the reports are incorrect. The reports do produce correct results for any accounting period prior to June.


3/18/09

Adobe Critical Flaw Fix

UPDATE: Adobe has released updates for versions 7 and 8. See Adobe's announcement:
http://www.adobe.com/support/security/bulletins/apsb09-04.html

3/12/09

UPDATE: Adobe has released security updates for Adobe Reader 9 and Acrobat 9. Note that submissions to grants.gov cannot use version 9.
Updates for versions 7 and 8 are expected to be available on March 18. Once you have the updates installed, you should be able to re-enable javascript. For more information, see: http://www.adobe.com/support/security/bulletins/apsb09-03.html

2/27/09

UPDATE: Adobe Critical Flaw Fix Effect on Cognos

Cognos reports will still be able to be run to PDF after you have followed the NUIT instructions to disable javascript in Adobe products.
The difference is:

  • When you click on the PDF icon in Cognos or select pdf as the report format, the pdf is returned within Adobe (outside of Cognos).
  • Be sure your popup blocker is turned off.
  • You ARE still able to email or save the report to your hard drive, but this will occur from Adobe as opposed to Cognos. 
  • You can then return to your Cognos window and click on the “return” icon at the upper right of the screen, which will take you back to the main list of reports.

cognosback

If you have scheduled the reports to run and be emailed in pdf, you will still receive them as scheduled. There is no negative impact.

ISSUE: "Critical Flaw in Adobe Reader/Acrobat" message sent this morning by NUIT.

  • We're still gathering information as to the effect the Adobe issue fix communicated by NUIT--disabling javascript within Adobe applications--will have on Cognos PDF functionality.
  • Disabling javascript in Adobe may make pdfs behave differently in Cognos, but this is probably not a significant difference.
  • One thing we're seeing for PC users is that, without javascript, the pdf will open in an Adobe application instead of in the browser and the "email" button won't work.
  • We will publish updates shortly

3/9/09

A drill through form the PI Portfolio has been enabled to the GM045 Budget Statement.

  • Users are now able to click the link for the Project ID in the GM044 Project Portfolio (HTML only) and will be taken to the GM045 Sponsored Project Budget Statement for that project ID.
  • In addition, there is a new prompt to allow users to run the GM044 for Negative Balances only.

NOTE: For those who copy reports to My Folders and save prompts or schedule reports to run, you will need to update the prompts (Set Properties). For a reminder on how to access Set Properties and other steps, please refer to our Job Aid: How to Save and Schedule Reports to be Delivered pdf icon.

3/5/09

NOTICE
ISSUE: Inconsistent data on a small number of expense reports

  • As a result of an earlier reported issue regarding Budget Checking not working on Expense Reports (2/19/09), a limited group of expense reports had inconsistent chart string data between the expense report and commitment control.
  • Therefore, the data represented on Cognos reports and the NUFinancials/PeopleSoft Budget Overview were not accurate.
  • Café performed a reconciliation on Tuesday evening (3/3/09) to bring the commitment control data in sync with the data on the expense reports.
  • As a result, Cognos reports may now display different data for chart strings that were utilized on those specific expense reports.
  • Please contact consultant@northwestern.edu or 491-HELP (1-4357) option 2 if you have questions about any of the information above.

Help

Call 847-491-HELP (847-491-4357) option 2 or email consultant@northwestern.edu.