APAR status
Closed as fixed if next.
Error description
When we insert "ceiling" function and click it on "Expression Definition" pane, the following "ceiling" information is displayed in "Information" pane . [Returns the smallest integer greater than or equal to "numeric_expression". ceiling ( 0.75 ) Result: Returns 0.8.] The example is not correct. The result should be 1.
Local fix
1. Copy <c11>/configuration\functions/DB2Strings_en.xml so DB2Strings_en.xml.org. 2. Open DB2Strings_en.xml with a text editor and change the following row. before: <string id="db2_ceiling.result.1" type="String">Result: Returns 0.8.</string> after: <string id="db2_ceiling.result.1" type="String">Result: Returns 1.</string> 3. Save it and we have to modify other language files if we use. 4. Restart CA service.
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
PH39868
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B0A
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-08-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":"B0A"}]
Document Information
Modified date:
29 March 2022