Beginning in mid-August 2016, FFRA website content will be moving to the Northwestern IT site's new section for Administrative Systems.

Cognos BI Issues

Resolved issues are shown below: resolved issues.

 


8/5/15

 

ISSUE: Federal Awards received on or after 6/1/2016 under the new tiered F&A rate agreement display the latest future F&A rate
AFFECTED REPORTS: Cognos BI Grants Reports GM044, GM045, GM023 and GM086; Research Portal
EXPECTED RESOLUTION: TBD
COMMENTS: Northwestern’s latest F&A rate agreement, applied to new awards and competitive renewals received on or after 6/1/2016, includes rates tiered by fiscal year. Reports are displaying the future F&A rate rather than the current one, and calculating F&A encumbrances using that rate.
· On the GM045, this impacts the F&A rate displayed in the activity header, and the calculation of F&A (account 78710) in columns E (Open Requisitions and Encumbrances) and F (Budget Checked not Posted).
· On the GM044, this affects the F&A % displayed, and the F&A Encumbrance column.
· On the GM023, this impacts the total amount of Open Encumbrances.
· On the GM086, this impacts the F&A Encumbrance amount.
· On the Research Portal, this impacts the Encumbered F&A amount.
In all cases, it does not affect the F&A rate applied to posted transactions; the rate currently in effect is used to calculate F&A posted to account 78710.

 

6/29/16


ISSUE: The Manager/Reviewer prompt for Grants projects may not return projects in pre-spending
AFFECTED PROCESS: Cognos Grants reports which use the Manager/Reviewer prompt (GL008, GL069, GL073, GM044, GM045, GM086)
EXPECTED RESOLUTION TIMEFRAME: Use workaround at present. Resolution will depend on decisions made during the Financials upgrade.
WORKAROUND: Run the desired report by project id or department rather than Manager (PI) to obtain pre-spending projects.

 

4/14/14

 

ISSUE: Scheduled Cognos BI reports may not run after a NetID password change
AFFECTED PROCESS/AUDIENCE: Scheduled Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: User determined
WORKAROUND: Log in to Cognos. This should automatically re-set your credentials, allowing your scheduled reports to run at the next scheduled time.
COMMENTS:
If you have not logged into Cognos since changing your NetID password, there is a chance your scheduled reports will not run.

While simply logging in to Cognos BI with the new password should address the issue, you may wish to take additional steps to renew your credentials to ensure that the change is complete prior to your next scheduled report run.

  1. Log into Cognos BI and click the person icon near the upper right of the screen
  2. Select My Preferences from the dropdown.

Cognos screenshot

On the Personal tab (1), under Credentials, click the "Renew the credentials" link (2).

Cognos BI screenshot

Enter your password. This will complete the re-set.

 

Cognos BI screenshot

There is also the option to manually schedule your reports. For assistance, please contact our Help desk:

consultant@northwestern.edu or 1-HELP, option 2 (847-491-4357).

 

3/20/13

ISSUE: Users of Cognos BI reports are unable to drill after upgrade to Internet Explorer 10 and 11
AFFECTED PROCESS/AUDIENCE: Cognos BI reports in Internet Explorer 10 and 11
EXPECTED RESOLUTION TIMEFRAME: User determined
WORKAROUND: Use Firefox browser
COMMENTS: To address the issue:

  1. In Internet Explorer 10 (IE 10), navigate to Tools > Compatibility View settings.
  2. Once the little window appears, add the website northwestern.edu and click Add.
    This website should now appear in the lower section.
  3. Click the Close button, and retry running your reports.

If you still have issues, log out of Cognos BI (if you are currently logged in on IE) and log back in. If it is still not working, please contact our Help desk:

consultant@northwestern.edu or 1-HELP, option 2 (847-491-4357).

 

2/19/10

ISSUE: Cognos reports run between 10pm and 7am may show inconsistent data
AFFECTED PROCESS/AUDIENCE: Cognos reporting
EXPECTED RESOLUTION TIMEFRAME: 7am daily
COMMENTS: Nightly updates occur during this time period, so we advise waiting until updates are finished to get the most current data.

2/9/10

ISSUE: The GM045 Sponsored Project Budget Statement does not display F&A calculated on encumbrances until an F&A expense has posted.
AFFECTED PROCESS/AUDIENCE: Research administrators and central users of the budget statement.
EXPECTED RESOLUTION TIMEFRAME: TBD
WORKAROUND (IF ANY): Manually calculate the F&A encumbrance amount based on the F&A rate displayed on the report.
COMMENTS: This issue affects only projects that draw F&A, and which have encumbrances subject to F&A, but which do not yet have F&A expenses posted. The primary impact is at the start of the project period.

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 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. TBD If you get an Oracle error message, try again to run the report; usually the second attempt is successful.

 

 


RESOLVED ISSUES

 

7/1/16

 

ISSUE: GM044 and GM045 reports run for Current Period returned no data
AFFECTED SYSTEMS: Cognos BI Reporting and Northwestern Research Portal
AFFECTED REPORTS:
· GM044 Sponsored Project Portfolio
· GM045 Sponsored Project Budget Statement
EXPECTED RESOLUTION: Resolved as of 10:50am 7/1/2016
COMMENTS: GM044 and GM045 reports run for Current Period on July 1st are affected.
If you ran or scheduled any of these reports using Current Period before 10:50am on July 1st, please re-run them.

3/17/16

 

ISSUE: Cognos BI GL008 ad hoc data is as of Tuesday, March 15.
AFFECTED PROCESS: GL008 Revenue & Expense Activity Report ad hoc only
EXPECTED RESOLUTION: Resolved
COMMENTS:

  • The GL008 nightly update was complete by 7:45am today, except for ad hoc data.
  • The ad hoc environment is expected to be refreshed with 3/16 data by noon today (3/17)

4/27/16

ISSUE: There is a delay with ad hoc data for Cognos BI GL005 - Summary Budget Status.
AFFECTED PROCESS: Reports built in Query Studio that use the GL005 Ad Hoc
EXPECTED RESOLUTION: 11am 4/27
COMMENTS: If you built a report using GL005 in Query Studio, rerun the report after 11am to ensure accurate data.

3/3/16

 

RESOLVED: Subcontract/Subaward F&A Issue

Due to a change in a supporting table in InfoEd, we have found that subcontract/subaward F&A is being double counted during the process that exports the data from InfoEd to Cognos.


Issue Details:

  • Only records created or modified since September 2015 that have subcontracts/subawards are affected
  • InfoEd Adhoc – ‘Request Direct Amount’ and ‘Awarded Direct Amount’ fields for the affected records will double count subcontract F&A for the records meeting the criteria above
  • InfoEd Award reports are not affected by this issue

InfoEd Proposal Reports which will include double subaward F&A for some records:

GM050 - Illinois Proposals
GM051 - Proposals with Required Cost Sharing
GM052 - Faculty Proposal Activity
GM059 - Proposed and Funded Cost Share
GM065 - Proposals Summary by Sponsor Type
GM066 - Proposals Summary by Management Area
GM071 - Monthly Proposal Detail
GM073 - Proposal Success Rate
GM085 - Pending Proposals - All Roles
GM088 - ARRA Monthly Proposal Detail


Approximately 100 award records and 200 proposal records were affected by this issue.

 

2/22/16

 

ISSUE: Re-run InfoEd Cognos Ad Hoc and Reports GM084 and GM085
AFFECTED SYSTEM: InfoEd Reports
EXPECTED RESOLUTION: RESOLVED as of Tuesday, February 23 at 8 am
COMMENTS:

  • Proposal amounts for a subset of proposals on reports GM084 – Current, Pending, and Completed Awards and GM085 – Current, Pending, and Completed Active Awards and in the ad hoc environment were miscalculated in the warehouse after an unrelated change on February 10.
  • The issue has been corrected.
  • Please re-run any GM084/GM085 or ad hoc reports run between Feb. 10 and Feb. 23.


2/16/16

ISSUE: InfoEd report data is as of 7pm on Sunday, Feb. 14.
AFFECTED PROCESS: Cognos BI reports on InfoEd data
EXPECTED RESOLUTION: Resolved as of 8am Wednesday, Feb.17
COMMENTS:
Nightly data updates did not complete overnight Feb. 15. As of Feb. 17, InfoEd report data is as of 7pm Tuesday, Feb. 16

2/10/16

ISSUE: The drills from GL008 - Revenue and Expense Activity Report to GL059 - GL Drill-through Detail (DT) are timing out.
RESOLVED: 9:30AM on 2/10
COMMENTS:

  • Affected reports run today before 9:30AM today should be rerun

1/25/16

ISSUE: GM044 & GM045 returning no data for some projects

AFFECTED PROCESS/AUDIENCE: Users who ran the following reports on Monday, January 25, 2016

GM023 - Multi-Project Summary
GM044 - Sponsored Project Portfolio
GM045 - Sponsored Project Budget Statement

EXPECTED RESOLUTION: Resolved at 1:15pm, on Monday, January 25, 2016

COMMENTS:

  • Please re-run any listed reports scheduled or run prior to 1:15pm today.
  • There were multiple issues with these reports today, so please use 1:15pm as a final resolution time.
  • There were no reports to the help desk of GM023 being blank.

9/2 ISSUE UPDATE: Cognos BI NUFinancials report data errors and GL008

  • Data errors have been corrected for all reports
  • The GL008 – Revenue & Expense Activity Report (and associated ad hoc) currently only shows data for FY15 and FY16, not prior years
  • GL008 will be updated tonight to include prior year data by 8am tomorrow, Sept. 3
  • Affected Reports:
    GM045 Fact reports:
    GM023 - Multi-Project Summary
    GM044 - Sponsored Project Portfolio
    GM045 - Sponsored Project Budget Statement

    GL008 Fact reports:
    GL003 - Off Cycle Budget Changes Report(Year-to-date)
    GL004 - Off Cycle Budget Changes Report(Month-to-date)
    GL008 - Revenue and Expense Activity Report
    GL056 - Budget Journal Detail (DT)
    GL059 - GL Drill-through Detail (DT)


9/1/15

ISSUE: Cognos BI NUFinancials report data errors (please see list of affected reports)

AFFECTED REPORTS:
NUFinancials – All warehouse-based reports (see list in comments, below) and related ad hoc reports

The following reports are NOT affected:

EXPECTED RESOLUTION: 8am Wednesday, September 2

COMMENTS:

  • NUFinancials warehouse-based reports will be unavailable as of 5pm today, Sept. 1 so that we can correct the issue.
    Please plan to re-run any of the following reports you may have run or scheduled for today after 8am tomorrow morning, Sept. 2

Full List of Affected Warehouse-based Reports


GL002 - Gift Summary Report
GL003 - Off Cycle Budget Changes Report(Year-to-date)
GL004 - Off Cycle Budget Changes Report(Month-to-date)
GL005 - Summary Budget Status Report
GL008 - Revenue and Expense Activity Report
GL009 - Expense/Revenue Budget
GL010 - Operating Budget Report
GL011 - Historical budget performance
GL012 - Project By Attribute/Activity Designated Funds
GL013 - Year End Performance Review Report
GL018 - Summary of Agency Project Cash Balances
GL019 - Plant Fund Open Accounts Balance and Cash Summary
GL023 - Detail of Unexpended Plant Expenses
GL025 - Faculty Start-up Attribute Summary (Faculty/PI)
GL026 - Faculty Start-up Attribute Summary
GL056 - Budget Journal Detail (DT)
GL059 - GL Drill-through Detail (DT)
GL061 - Agency Project Detail
GL062 - Detail Drills (DT)
GL062 - Gift/Endowment Project Detail
GL064 - Project By Attribute/Activity Non-Designated Funds
GL067 - Valid Chartstrings
GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
GL071 - Financial Summary - Historical Comparison (Excluding Agency and Multi-Year Funds)
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 - Financial Summary with Management Level & Project Purpose
GL077 - School Income Statement
GL078 - School Income Statement (DT)
GM001 - Upcoming Billing Events
GM003 - Prepaid Award Spending Report
GM004 - Salary Detail Report
GM005 - Billing Activity Report
GM008 - Revenue Recognition Report
GM009 - Unapplied Deposits Report
GM011 - Sponsored Research Expenditures Report
GM013 - F&A Rate by Effective Date Report
GM014 - F&A Revenue Offset Setup Report
GM015 - F&A Revenue Offset Recovery Report
GM018 - Sponsored Project Subcontractor Billing Status Report
GM019 - Milestone (Deliverable) Status Report
GM020 - No Automatic Carry Forward
GM023 - Multi-Project Summary
GM024 - Pre-Spending Project Monitoring
GM026 - Project Information Lookup Report
GM028 - Project Close Out Notification Report
GM032 - Subcontract Analysis
GM034 - F&A Awarded and Expended Report
GM035 - Industry Clinical Trial Activity Report
GM037 - NIH Grants - Estimated Balances Greater Than 20%
GM038 - BI Limit Budget Exception
GM041 - Budget Category Query
GM042 - Overspent Budget Category
GM044 - Sponsored Project Portfolio
GM045 - Sponsored Project Budget Statement
GM046 - InfoEd Subcontract ID Details
GM047 - Milestone (Deliverable) Report
GM086 - Projects Balances Report
GM089 - Internal Recharge Center Query
GM091 - Sponsor Payments Received Report
SC006 - 1099 Verification Report
SC017 - New Purchased Equipment ~ Capital Equipment
SC021 - New Purchased Equipment ~ Non-Capital Equipment
SC022 - New Purchased Equipment ~ Fabricated Equipment
SC026 - Expenses by Submission & Workflow Status

8/10/15

ISSUE: Reports run before 10:30am today may show incomplete data.
AFFECTED REPORTS: see below
EXPECTED RESOLUTION TIMEFRAME: Resolved at 10:30am, Monday, August 10
COMMENTS: Data refreshing issues caused a delay in loading the Ledger table on Monday, August 10.

Users who ran the following reports between 9 a.m. – 10:30 a.m. on 8/10 should rerun them for the most current data:

FM003 - Capital Project Financial Position - Summary
FM004 - Capital Project Financial Position - Detail
GL002 - Gift Summary Report
GL003 - Off Cycle Budget Changes Report(Year-to-date)
GL004 - Off Cycle Budget Changes Report(Month-to-date)
GL005 - Summary Budget Status Report
GL009 - Expense/Revenue Budget
GL010 - Operating Budget Report
GL011 - Historical budget performance
GL012 - Project By Attribute/Activity Designated Funds
GL013 - Year End Performance Review Report
GL019 - Plant Fund Open Accounts Balance and Cash Summary
GL025 - Faculty Start-up Attribute Summary (Faculty/PI)
GL026 - Faculty Start-up Attribute Summary
GL062 - Gift/Endowment Project Detail
GL064 - Project By Attribute/Activity Non-Designated Funds
GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
GL071 - Financial Summary - Historical Comparision (Excluding Agency and Multi-Year Funds)
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 - Financial Summary with Management Level & Project Purpose
GM018 - Sponsored Project Subcontractor Billing Status Report
GM020 - No Automatic Carry Forward
GM034 - F&A Awarded and Expended Report
GM037 - NIH Grants - Estimated Balances Greater Than 20%
GM041 - Budget Category Query
GM042 - Overspent Budget Category
GM086 - Projects Balances Report
GM093 - Cost share Report

6/15/15

ISSUE: Payroll encumbrance may be overstated in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Wednesday, 6/17
COMMENTS:

  • The weekly payroll HR Encumbrance journal dated 6/12 has not yet posted.
  • HR Encumbrances may be overstated until the journal posts.
  • Reports should include encumbrances on Wednesday at 8am.
  • HR Expense has successfully posted and is represented on reports.

4/28/15

ISSUE: Cash balance amounts on the GL061 report are incorrect.
AFFECTED REPORTS: GL061 - Agency Project Detail
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS:

  • Opening cash balances for some projects are doubling.
  • Please refrain from running this report until the reporting database can be corrected during nightly updates.

 

4/13/15

ISSUE: Users are unable to access FFRA systems using the NUPortal
AFFECTED PROCESS/AUDIENCE: FFRA systems via the NUPortal
EXPECTED RESOLUTION: Resolved
WORKAROUND: Use the following page instead:

COMMENTS: Please note that the Financial Management Systems Gateway page is available from "Login" link in the top navigation of the FFRA website. There are also a direct link to the systems in the dropdown area of that navigation item.

2/19/15

ISSUE: Some sponsored research report transaction data is displaying incorrectly.
AFFECTED REPORTS:

  • GM023 Multi-Project Summary
  • GM044 Sponsored Project Portfolio
  • GM045 Sponsored Project Budget Statement

EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS:

  • GM044, GM045, and GM023 reports run on Feb. 19 are affected.
  • If you ran or scheduled any of these reports on Feb. 19, please re-run them after 8am on Feb. 20.

2/5/2015

ISSUE: FM005 Materials Usage Report, FM014 Maintenance Spending Report, and the FAMIS Ad Hoc Work Order Detail star show data as of Tuesday, Feb. 3.
AFFECTED PROCESS: Cognos BI Reports for FAMIS
EXPECTED RESOLUTION: Resolved
COMMENTS: There was an issue with a piece of the nightly data update affecting two reports and FAMIS Ad Hoc. FM031/FM032 Job Cost Reports are NOT affected.

1/7/15

ISSUE: Cognos BI unavailable Jan. 18 from 10am - Noon
AFFECTED PROCESS: Cognos BI
EXPECTED RESOLUTION TIMEFRAME: Noon on 1/18
COMMENTS: System upgrade will include enhancements to icons and Chrome (browser) support.

UPDATE 12/18/14

ISSUE: Incomplete data on GL008 - Revenue and Expense Activity and GL075 - Financial Summary and Control reports run prior to 10am today
AFFECTED PROCESS: GL008, GL075 and ad hoc version of GL008 run prior to 10am on 12/18/14 (including scheduled reports)
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Nightly data updates for NUFinancials reports were delayed. Please re-run any scheduled GL008 or GL075 reports after 10am.
GL008 - Revenue and Expense Activity Ad Hoc will have data as of 12/16/2014 5pm. It will update overnight.

12/06/14

ISSUE: FFRA Systems Unavailable 12/6, 6am-noon
AFFECTED PROCESS: FFRA applications: NUFinancials, FAMIS, NUPlans, iBuyNU (requesters only), Cognos BI Financial Reports, InfoEd
EXPECTED RESOLUTION TIMEFRAME: Noon, Saturday, 12/6
COMMENTS:

  • The datacenter will be applying a database update to the production systems.
  • Shoppers WILL be able to access iBuyNU directly, but Requesters will not be able to process carts until NUFinancials is back up.

10/21/14

ISSUE: Data for Cognos BI GL077 - Income Statement Report requires extra time to finish loading.
AFFECTED PROCESS: GL077 - Income Statement Report
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Scheduled GL077 - Income Statement Report will need to be rerun for most current data.
All other data is as of Monday, Oct. 20.

10/14/14

ISSUE: Cognos BI NUFinancials reports run prior to 9:45am may show incomplete data
AFFECTED PROCESS/AUDIENCE: Cognos BI NUFinancials reports run prior to 9:45am on 10/14/14 (including scheduled reports)
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS:

  • Nightly data updates for NUFinancials reports were delayed.
  • Updates completed at 9:45am. Please re-run any reports scheduled or run before that time.
  • GL077 Income Statement and GL008 ad hoc data are as of 5pm Saturday, 10/11.

10/10/14

ISSUE: Data for Cognos BI GL077 - Income Statement Report took extra time to finish loading.
AFFECTED PROCESS: GL077 - Income Statement Report
EXPECTED RESOLUTION TIMEFRAME: Resolved at 9:15
COMMENTS: Please rerun your GL077 for most current data.

9/3/14

ISSUE: Payroll expense is not fully reflected in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Thursday, 9/4
COMMENTS: The monthly payroll HR Actuals journal dated 8/29 (FY14) has posted as of 9/3 and will appear in NUFinancials reports on 9/4. Users may use online inquiry pages like Budget Overview and Budget Detail to see up-to-date FY14 balances.

7/31/14

ISSUE: The GM004 Salary Detail Report is not showing any data for reports using dates after 2009.
AFFECTED PROCESS:  GM004 Salary Detail Report
EXPECTED RESOLUTION TIMEFRAME:  Resolved
COMMENTS: Currently the data is accurate up to the year 2009.

 

ISSUE: Users were unable to access Cognos BI for approximately 40 minutes this morning and some scheduled Cognos BI reports may not have run.
AFFECTED PROCESS: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: The affected server was restarted at 9:10am. If your scheduled reports did not run, please run them manually.

6/10/14

ISSUE: The FAMIS data warehouse nightly update did not complete until 10am
AFFECTED PROCESS: Data warehouse based Facilities Management reports (see list, linked below)
EXPECTED RESOLUTION TIMEFRAME: Resolved at 10am today
COMMENTS:

 

6/2/14

ISSUE: Cognos BI reports experienced intermittent delays this morning and possibly this weekend.
AFFECTED PROCESS: Scheduled and on-demand Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Issue has been resolved as of 9:45 a.m. Monday, 6/2
COMMENTS:

  • The system is now attempting to 'catch up' and rerun scheduled reports that did not run earlier.
  • If you do not receive your scheduled report by 11 a.m. today, please rerun your report manually.


5/21/14

ISSUE: Data for Cognos BI GL008 - Revenue and Expense Activity detail ad hoc has not finished loading.
AFFECTED PROCESS: Cognos Query Studio GL008 - Revenue and Expense Activity Report ad hoc
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Please rerun your GL008 ad hoc reports after 10am.

1/29/14

UPDATE 2/2/14

  • This issue has been resolved.
  • The GL008 - Revenue & Expense Activity report reflects data as of Saturday, Feb. 1.
  • Please re-run and review your month-end GL008 for December consistent with your normal post-audit practice if you had purchasing-related transactions during that month.

UPDATE 1/31/14:

  • We are ready to put a fix into production so that reports will be accurate prior to the start of business on Monday, Feb. 3.
  • Part of the fix process involves reloading all FY14 financial warehouse data for the GL008 - Revenue & Expense Activity report.
  • As a result, GL008 reports run between 6pm on 1/31 and 6pm on 2/1 may show incomplete data.
  • Once the fix process is complete, we will post an update on this page and send a message to the Cafe Core User listserv.

UPDATE 1/30/14:

  • We are currently testing a fix and will publish more details as they become available.

ISSUE: NUFinancials Cognos BI report data anomalies around purchasing-related pre-encumbrances, encumbrances, and expenses
AFFECTED PROCESS/AUDIENCE: NUFinancials Cognos BI GL008 - Revenue & Expense Activity and possibly other reports
EXPECTED RESOLUTION TIMEFRAME: February 10th or sooner
WORKAROUND: Use SC016 - Open Encumbrance Report for accurate encumbrance data or Budget Details or Budget Overview in NUFinancials for accurate data for all transaction types
COMMENTS:

  • We are investigating issues around purchase orders and vouchers on GL008 and related ad hoc reports.
  • This issue may appear as a negative encumbrance and/or a missing expense on the GL008 and other reports.
  • Please plan to hold off on running final January reports until this issue is resolved.
  • Real-time reports appear to be unaffected.

For help with viewing Budget details/overview, you may wish to consult the following training guides:

Viewing Budget Performance Using Budget Details pdf icon
Viewing budget Performance Using Budget Overviewpdf icon
Using Budget Overview for Project Budgets pdf icon

1/23/14

ISSUE: Data for Cognos BI GL008 - Revenue and Expense Activity reports did not complete until 8 a.m. today (1/23). Similarly, detail adhoc (a.k.a. GL008 adhoc) data did not finish until 10:30 a.m. this morning.
AFFECTED PROCESS/AUDIENCE: Cognos BI GL008 - Revenue and Expense Activity Report
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Users who ran the GL008 canned or adhoc reports manually or via schedule before these times will not see yesterday’s data. Please rerun your reports again if you ran these reports in the aforementioned time periods.


12/18/13

ISSUE: Payroll encumbrance is overstated in Cognos BI reports for NUFinancials, including GL008
AFFECTED PROCESS: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Resolved as of Friday, 12/20
COMMENTS:

  • The HR Encumbrance journal dated 12/13 has not completed processing. Encumbrances shown on Cognos BI reports for NUFinancials are overstated by the 12/13 payroll amount.
  • The journal is expected to complete processing on 12/19 and should be reflected on reports on 12/20.

12/10/13

ISSUE: During the NUFinancials downtime (6pm 12/10 - 8am 12/16), data warehouse-based reports consuming NUFinancials data will not be updated.
AFFECTED PROCESS/AUDIENCE: Cognos BI warehouse-based reports on NUFinancials data
EXPECTED RESOLUTION TIMEFRAME: 8am Monday, 12/16
COMMENTS: The next data refresh of data warehouse-based reports is scheduled to occur on Sunday, December 15.
Until that time:

PeopleSoft data is as of 7:45 pm, Tuesday, December 10, 2013
InfoEd data is as of 7 pm, Tuesday, December 10, 2013
FAMIS data is as of 10 pm, Tuesday, December 10, 2013

 

ISSUE: During the NUFinancials downtime (6pm 12/10 - 8am 12/16), real-time reports consuming NUFinancials data will not be available.
AFFECTED PROCESS/AUDIENCE: Cognos BI real-time reports on NUFinancials data
EXPECTED RESOLUTION TIMEFRAME: 8am Monday, 12/16
COMMENTS: If you attempt to run a real-time report during NUFinancials downtime, you may see the error "Unable to find the data source 'PS_RealTime' in the content store."

12/3/13

ISSUE: During the NUFinancials downtime (6pm 12/10 - 8am 12/16), Grants Management reports (e.g., GM045) consuming NUFinancials data may not reflect the current status of Tuesday’s (12/10/13) Grant-related financial transactions.
AFFECTED PROCESS/AUDIENCE: Grants Management (GM) reports on NUFinancials data
EXPECTED RESOLUTION TIMEFRAME: 8am Monday, 12/16
COMMENTS:

  • Example: Actual expenses incurred Tuesday, 12/10, would not be integrated into the Project Costing module and have F&A calculated.
  • The Cognos BI warehouse will be updated for business Monday December 16.
  • GM reports consuming InfoEd Data are not affected by the NUFinancials Upgrade.

12/6/13

ISSUE: NUFin Cognos ad hoc reporting (Query Studio) ONLY: Ad hoc queries / reports run before 9:45 am today should be rerun.
AFFECTED PROCESS/AUDIENCE: Users of Café Cognos ad hoc reporting (Query Studio), specifically the Ledger KK Summary fact table
EXPECTED RESOLUTION TIMEFRAME: RESOLVED as of 9:45am
COMMENTS: The database update for the ad hoc Ledger KK Summary fact table completed at 9:45 am today. Only ad hoc (Query Studio) reports are affected.

11/6/13

ISSUE: GM045 update incomplete prior to 7:30am today.
AFFECTED PROCESS/AUDIENCE: GM045 - Sponsored Project Budget Statement run or scheduled before 7:30am today
EXPECTED RESOLUTION TIMEFRAME: RESOLVED
COMMENTS: The database update for GM045 took longer than expected last night. Anyone who manually ran GM045 this morning or had it scheduled to run before 7:30am today should rerun the report.

9/9/13

ISSUE: Reports showing year-to-date information that were run in September using the date option ‘Previous Period’ (August) incorrectly included this month’s (September) values.
AFFECTED PROCESS/AUDIENCE: Cognos BI report users who ran reports under all of the following conditions:
1. Ran a report (see list below) that shows year-to-date information
2. Ran the report using the date option Previous Period
3. Ran the report between Sept. 3 and Sept. 9 (Noon)
4. Already had added September transactions into the system

EXPECTED RESOLUTION TIMEFRAME: RESOLVED 9/9/13 12pm
COMMENTS: Please note that the month of August will not be officially closed until September 20th.

Reports that could be affected by this issue:

GL005 - Summary Budget Status Report
GL007 - CUFS to PS Department Budget Conversion for Revenue and Expenses
GL008 - Revenue and Expense Activity Report
GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
GL071 - Financial Summary - Historical Comparison (Excluding Agency and Multi-Year Funds)
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 - Financial Summary with Management Level & Project Purpose
GL075 - Financial Summary and Control Report
GM044 - Sponsored Project Portfolio
GM045 - Sponsored Project Budget Statement
GM086 - Projects Balances Report

10/7/13

ISSUE: Payroll encumbrance is overstated in Cognos BI reports for NUFinancials, including GL008
AFFECTED PROCESS/AUDIENCE:
Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME:
Wednesday, 10/9
COMMENTS:

  • The HR Encumbrance journal dated 10/4 has not completed processing.
  • Encumbrances shown on Cognos BI reports for NUFinancials are overstated by the 10/4 bi-weekly payroll amount.
  • The journal is expected to complete processing on 10/8 and should be reflected on reports on 10/9.

UPDATE 9/11/13

ISSUE: Payroll expense is not fully reflected in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Thursday, 9/12
COMMENTS:

FY13 Payroll Expense

  • The bi-weekly payroll HR Actuals journal dated 8/31 (FY13) has posted and will appear in NUFinancials reports on 9/12.
  • Users may use online inquiry pages like Budget Overview and Budget Detail to see up-to-date FY13 balances.

FY14 Payroll Encumbrance (resolved)

  • The HR Encumbrance journal dated 9/6 (FY14) now appears in NUFinancials reports.

UPDATE 9/10/13

ISSUE: Payroll expense is not fully reflected in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Thursday, 9/12
COMMENTS:

FY13 Payroll Expense

  • The bi-weekly payroll HR Actuals journal dated 8/31 (FY13) has not completed processing and does not appear in Cognos BI reports for NUFinancials.
  • FY13 expenses are understated on all NUFinancials reports.
  • The journal is expected to complete processing on 9/11, and should be reflected on reports on 9/12.

FY14 Payroll Encumbrance

  • The HR Encumbrance journal dated 9/6 (FY14) has posted and will appear in NUFinancials reports on 9/11.
  • Users may use online inquiry pages like Budget Overview and Budget Detail to see up-to-date FY14 balances.

9/9/13

ISSUE: Payroll expense is not fully reflected in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: Wednesday, 9/11
COMMENTS:

  • The bi-weekly payroll HR Actuals journal dated 8/31 (FY13) and the HR Encumbrance journal dated 9/6 (FY14) have not completed processing and do not appear in Cognos BI reports for NUFinancials.
  • FY13 expenses and FY14 obligations are understated on all NUFinancials reports.
  • The journals are expected to complete processing on 9/10, and should be reflected on reports on 9/11.

9/5/13

UPDATE:

ISSUE: Payroll expense is not accurately reflected in Cognos BI reports, including GL008-Revenue & Expense Activity.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS:

  • The monthly payroll HR Actuals journal dated 8/30 has completed processing on 9/5, but does not yet appear in Cognos BI reports.
  • Reports will include the journal on 9/6, however users may use online inquiry pages like Budget Overview and Budget Detail to see up-to-date balances.

9/3/13

ISSUE: Payroll expense is not accurately reflected in Cognos reports, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: The monthly payroll HR Actuals journal dated 8/30 has not completed processing and does not appear in Cognos reports. The journal is expected to complete processing on 9/4, and should be reflected on reports on 9/5.

7/31/13

ISSUE: Payroll expense is not accurately reflected in Cognos BI reports for NUFinancials, including GL008.
AFFECTED PROCESS/AUDIENCE:
Cognos BI reports for NUFin
EXPECTED RESOLUTION TIMEFRAME:
Resolved
COMMENTS:
The bi-weekly payroll HR Actuals journal dated 7/26 has not completed processing and does not appear in Cognos BI reports. The journal is expected to complete processing on 7/31, and should be reflected on reports on 8/2.

ISSUE: Incomplete data causing errors in the GM045.
AFFECTED PROCESS/AUDIENCE: GM045 - Sponsored Project Budget Statement
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Data on the GM045 and GM023 are now accurate as of 5pm on 7/30. Please re-run these reports if you ran them earlier today (7/31).

6/27/13

ISSUE: Cognos BI real-time reports will be unavailable on Saturday, 7/6/13 from 8am - 6pm
AFFECTED PROCESS/AUDIENCE: NUFinancials, Cognos BI real-time reports
EXPECTED RESOLUTION TIMEFRAME: 6pm on 7/6/13
COMMENTS:

6/19/13

ISSUE: Payroll expense is not accurately reflected in Cognos BI reports, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: The bi-weekly payroll HR Actuals journal dated 6/14 has not completed processing and does not appear in Cognos reports. The journal is expected to complete processing on 6/20, and should be reflected on reports on 6/21.

5/30/13

ISSUE: Some Cognos BI reports are displaying blank results.

AFFECTED PROCESS/AUDIENCE: Cognos BI reports listed below
EXPECTED RESOLUTION TIMEFRAME: 10am Thursday 5/30/2013
COMMENTS: Please re-run any scheduled reports shown below after 10am

AFFECTED REPORTS:

FM003 - Capital Project Financial Position - Summary
FM003 - Capital Project Financial Position (DT)
FM004 - Capital Project Financial Position - Detail
GL002 - Gift Summary Report
GL003 - Off Cycle Budget Changes Report(Year-to-date)
GL004 - Off Cycle Budget Changes Report(Month-to-date)
GL005 - Summary Budget Status Report
GL009 - Expense/Revenue Budget
GL010 - Operating Budget Report
GL011 - Historical budget performance
GL012 - Project By Attribute/Activity Designated Funds
GL013 - Year End Performance Review Report
GL019 - Plant Fund Open Accounts Balance and Cash Summary
GL025 - Faculty Start-up Attribute Summary (Faculty/PI)
GL026 - Faculty Start-up Attribute Summary
GL062 - Gift/Endowment Project Detail
GL064 - Project By Attribute/Activity Non-Designated Funds
GL065 - Endowment Summary Report
GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
GL071 - Financial Summary - Historical Comparison (Excluding Agency and Multi-Year Funds)
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 - Financial Summary with Management Level & Project Purpose
GM018 - Sponsored Project Subcontractor Billing Status Report
GM020 - No Automatic Carry Forward
GM034 - F&A Awarded and Expended Report
GM037 - NIH Grants - Estimated Balances Greater Than 20%
GM041 - Budget Category Query
GM042 - Overspent Budget Category
GM044 - Sponsored Project Portfolio
GM086 - Projects Balances Report

5/20/13

ISSUE: NUPortal "Vendor Lookup" link under Vendor Add/Maintenance not functioning
AFFECTED PROCESS/AUDIENCE: NUPortal/Cognos BI
EXPECTED RESOLUTION TIMEFRAME: 8am Tuesday 5/21
COMMENTS: Please go directly to the report through Cognos BI:
Public Folders ‎> Project_Cafe_Reports ‎> School ‎> Supply Chain > SC025 - Vendor Info Query - Expanded Search

5/13/13

ISSUE: Cognos BI reports will be unavailable on Saturday, May 18 from 9am - 2pm.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: 2pm on 5/18
COMMENTS: The NU Business Intelligence System (also known as Cognos Reporting) will be unavailable while a scheduled software upgrade is performed. For more information, see NUIT's announcement:

http://www.it.northwestern.edu/transitions/2013/bi-system-upgrade.html

4/8/13

ISSUE: Incomplete data causing errors in the GM045 reports and associated reports.
AFFECTED PROCESS/AUDIENCE: GM045 reports listed below.
EXPECTED RESOLUTION TIMEFRAME: 3 PM, Monday, April 8
COMMENTS: Reports will need to be rerun after issue is resolved, likely today after 3pm.
The issue affected reports from both the current period (April) and previous period (March).
AFFECTED REPORTS:

GL023 - Detail of Unexpended Plant Expenses
GM001 - Upcoming Billing Events
GM003 - Prepaid Award Spending Report
GM005 - Billing Activity Report
GM007 - Pre-Billing Letter of Credit Summary Report
GM008 - Revenue Recognition Report
GM011 - Sponsored Research Expenditures Report
GM013 - F&A Rate by Effective Date Report
GM024 - Pre-Spending Project Monitoring
GM026 - Project Information Lookup Report
GM028 - Project Close Out Notification Report
GM035 - Industry Clinical Trial Activity Report
GM038 - BI Limit Budget Exception

3/4/13

ISSUE: Payroll encumbrance/expense is not accurately reflected in Cognos reports, including GL008.
AFFECTED PROCESS/AUDIENCE: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: The monthly payroll HR Actuals journal dated 2/28 has not completed processing and does not appear in Cognos reports.
The journal is expected to complete processing on 3/5, and should be reflected on reports on 3/6. Monthly reports for the February close will be available on 3/7.

2/25/13

ISSUE: Scheduled reports using the ‘Current Period’ or ‘Previous Period’ in the Date Options are returning incorrect months.
AFFECTED PROCESS/AUDIENCE: All Cognos BI users who ran or scheduled reports using one of the date options prior to 9 a.m. on Monday, February 25, 2013.
EXPECTED RESOLUTION TIMEFRAME: Issue is now resolved, but users who scheduled reports prior to 9:45 a.m. should rerun scheduled reports and reports from the list below.
COMMENTS: Row-level security is also currently not working, users may wish to wait until that issue is resolved as well before re-running scheduled reports with row-level security.

ISSUE: Row-level security is not working at this time for Cognos reporting.
AFFECTED PROCESS/AUDIENCE: All Cognos BI reports that use row-level security. Also users who scheduled row-level secured reports to run this morning.
EXPECTED RESOLUTION TIMEFRAME: Resolved
COMMENTS: Row-level security reports are as follows:

AM002 - Asset Inventory Report
FM003 - Capital Project Financial Position - Summary
FM004 - Capital Project Financial Position - Detail
GL002 - Gift Summary Report
GL003 - Off Cycle Budget Changes Report(Year-to-date)
GL004 - Off Cycle Budget Changes Report(Month-to-date)
GL005 - Summary Budget Status Report
GL008 - Revenue and Expense Activity Report
GL009 - Expense/Revenue Budget
GL010 - Operating Budget Report
GL011 - Historical budget performance
GL012 - Project By Attribute/Activity Designated Funds
GL013 - Year End Performance Review Report
GL018 - Summary of Agency Project Cash Balances
GL025 - Faculty Start-up Attribute Summary (Faculty/PI)
GL026 - Faculty Start-up Attribute Summary
GL061 - Agency Project Detail
GL062 - Gift/Endowment Project Detail
GL064 - Project By Attribute/Activity Non-Designated Funds
GL065 - Endowment Summary Report
GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)
GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds)
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds)
GL071 - Financial Summary - Historical Comparision (Excluding Agency and Multi-Year Funds)
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 - Financial Summary with Management Level & Project Purpose
GL075 - Financial Summary and Control Report
GM011 - Sponsored Research Expenditures Report
GM014 - F&A Revenue Offset Setup Report
GM023 - Multi-Project Summary
GM026 - Project Information Lookup Report
GM035 - Industry Clinical Trial Activity Report
GM044 - Sponsored Project Portfolio
GM045 - Sponsored Project Budget Statement
GM086 - Projects Balances Report
SC026 - Expenses by Submission & Workflow Status
FM008 - Job Cost - FAMIS Billing Summary
FM009 - Job Cost Labor Detail Report
FM010 - Job Cost Materials Detail Report
FM011 - Job Cost Work Order Detail Report
FM012 - Facilities Invoice Detail
FM026 - Job Cost - FAMIS Billing Summary (Extended)
GE002 - Transactional data file: Pre-Encumbrance detail
GE004 - Transactional data file: Encumbrance detail
GE005 - Transactional data file: Expense detail
GE006 - Transactional data file: Revenue detail
GE010 - Department Data Security Profile
GM033 - Project Account Summary

2/4/13

ISSUE: Payroll encumbrance/expense is not accurately reflected in Cognos reports (GL008).
AFFECTED PROCESS/AUDIENCE: Cognos BI reports
EXPECTED RESOLUTION TIMEFRAME: Wednesday, 2/6
COMMENTS: The monthly payroll HR Actuals journal dated 1/31 has not completed processing and does not appear in Cognos reports. The journal is expected to complete processing on 2/5, and should be reflected on reports on 2/6.

1/18/13

ISSUE: Because of the holiday weekend, data for the NUFinancials/PeopleSoft data warehouse will not be refreshed on Saturday evening, 1/19.
AFFECTED PROCESS/AUDIENCE: Cognos BI data warehouse based reports on Sunday and Monday
EXPECTED RESOLUTION TIMEFRAME: Tuesday, January 22 at 7 am
WORKAROUND (IF ANY): none
COMMENTS:

2/5/13

ISSUE: Ad hoc reports returning zero dollar amounts.
AFFECTED PROCESS/AUDIENCE: All Cognos BI ad hoc reports for NUFinancials
EXPECTED RESOLUTION TIMEFRAME: As soon as possible, 2/5
COMMENTS: This issue started yesterday morning and continues today.

2/4/13

ISSUE: NU Café Data Warehouse outage at 12:30 pm
AFFECTED PROCESS/AUDIENCE: All Cognos BI reports scheduled for 12:30
EXPECTED RESOLUTION TIMEFRAME: 1pm 2/4/13
COMMENTS: Anyone with a report processing at 12:30 may experience a hang or error. If your report "hangs" or you receive an error, please try again after 12:30.

1/3/13

ISSUE: GM045 returns blank results if run for Fiscal Year 2013, Accounting Period 5 (Jan) & Current Period.
AFFECTED REPORT: GM045
EXPECTED RESOLUTION TIMEFRAME: Thursday, 1/3/13, approximately 1pm
COMMENTS: None

 


Support

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