Updating the data source name in the tabular SQL query

If you are upgrading to the latest supported version of Cognos Analytics, you will have to specify the data source name (usually workbrain) for all custom reports that use tabular SQL. If you do not make this update, you may receive this error in Cognos Analytics: Data source "" was not found in Content Manager. This issue occurs when generating PDF and Excel output for the report.

For more information on how to update the tabular SQL query for reports, see "Build a Report Using Your Own SQL" in the IBM Cognos Analytics - Reporting User Guide. Report authors should be familiar with this process.

These are the reports affected by this change:

• Productivity Summary Report
• Schedule Effectiveness Report
• Cost Summary Report
• Unauthorized Records Report
• Schedule Effectiveness Summary Report
• Productivity Variance Report
• Payroll Based Journal Export for CMS
• Payroll Approval Summary - Unauthorized Records
• Weekly Time Card Report
• Schedule Audit Report
• Healthcare - Nurse Manager KPIs
• Healthcare - Worked Hours Per Patient Day Trend Graph Report
• Healthcare - Team Productivity Hours Report
• Healthcare - Team Productivity Cost Report
• Healthcare - Detailed Productivity Hours Report
• Healthcare - Detailed Productivity Cost Report
• Healthcare - Cost Summary Report