Cognos 7.0.0.6 resolved issues
Total: 4 issues
----------------
WFMBI-4070
Cognos standard model, query subject VIEW_PARSE_CLOCKS_MOD2 Error when selecting from views VL_CLOCK_TRAN_TYPE and VIEW_PARSE_CLOCKS when localization of VL_CLOCK_TRAN_TYPE is turned on
When localization of the VL_CLOCK_TRAN_TYPE view is enabled, an error occurs in the Cognos standard model, with the VIEW_PARSE_CLOCKS_MOD2 query subject:
Error converting data type varchar to numeric.
The query subject is used by the Employee Punches by Day report.
Outcome
Fixed by adding filter "where VIEW_PARSE_CLOCKS.WRKS_CLOCKS is not null" to the select query.
----------------
WFMBI-4083
Cognos: Balance Summary Report
The Balance Summary report was timing out due to performance issues.
Outcome
Fixed. The Balance Summary report now only displays balances for active employees.
----------------
WFMBI-4084
Cognos: Balance Detail Report
The Balance Detail report was timing out due to performance issues since the report is executed for all employees (inactive/active).
Outcome
Fixed. The Balance Detail report now only displays balances for active employees.
----------------
WFMBI-4112
Cognos Reports: Remove hard-coded $ in column labels in all Cognos Reports
Removed the $ sign from the data rows of the following reports:
- Premium\Cross-Industry\Premium Detailed Time Code by Employee.xml
- Premium\Cross-Industry\Premium Employee Overtime.xml
- Premium\Cross-Industry\Premium Time Code by Team.xml
- Premium\Healthcare\Healthcare - Cost Summary Report.xml
- Premium\Healthcare\Healthcare - Nurse Manager KPIs.xml
- Premium\Retail\Forecast vs. Actual Labor Performance Graphs.xml
- Premium\Retail\Forecast vs. Actual Labor Performance.xml
- Standard\Work Adjustment Report.xml
Also made changes to these reports:
- Enterprise Productivity Report.xml: Renamed 'Payroll Dollars' with 'Payroll Cost' and removed the localized labels
- Healthcare - Cost Summary Report.xml: Renamed 'Total Paid Dollars' with 'Total Paid', and removed the localized labels (Page one and page two)
----------------