APAR status
Closed as fixed if next.
Error description
_add_days function add 2 days too much for an date in number from an Excel file imported in the portal as a Data module In Excel Column 1 is your date Column 2 is the same date but cell converted to number. e.g 2021-06-12 = 44359 Import this file from the Cognos portal then create a data module. Create a List report from the data module Add a query calculation _add_days (1900-01-01, 44359) Result is 2021-06-14 when it should be 2021-06-12 Issue not observed on FM packages.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Analytics 11.2.2 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH38183
Reported component name
COG REPORT STUD
Reported component ID
5724W12RS
Reported release
B09
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-06-16
Closed date
2022-03-28
Last modified date
2022-03-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B09"}]
Document Information
Modified date:
29 March 2022