APAR status
Closed as fixed if next.
Error description
When attempting to add two measures to a dashboard visualisation when there is no common dimensional values when in scope the visualisation will error out saying Query Service Internal Error. The XQE logs says: Caught error in the Query Service: java.lang.ClassCastException: com.cognos.xqe.resultsets.ContextMember incompatible with com.cognos.xqe.resultsets.ContextValue Example condition: Source 1 fields: Reporting month, Measure 1 Source 2 fields: Reporting Month, Measure 3 Issue: If we are using 'Reporting month', Measure 1 and Measure 3 in a Dashboard chart or table, it works fine if both Source 1 'Reporting Month' and Source 2 'Reporting month' has same data(at least one value matching). If there are no common values in Source 1 ' Reporting Month' and Source 2 'Reporting Month' then the chart throw an error. It's same for all the dimensions in the cube.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Analytic 11.0.12.0 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI93947
Reported component name
COG DASHBOARDS
Reported component ID
5724W12DB
Reported release
B09
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-02-19
Closed date
2018-06-29
Last modified date
2018-06-29
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B09","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 November 2022