PM86086: EVEN THOUGH THE SAME QUERY IS USED FOR CROSSTAB AND CHART, DIVIS ION USED IF CLAUSE IN THE QUERY IS INCORRECT FOR THE CROSSTAB

APAR status

• Closed with unknown close code.

Error description

• Even though the same query is used for crosstab and chart,
  division used if clause within the query is incorrect for the
  crosstab. ?The customer created like the following division and
  they are able to obtain the expected result for chart, however,
  it is incorrect for crosstab. ??----?IF ([Measure A] is null)
  THEN?(null)?ELSE IF(?daiatari?='1') THEN?(([Measure B]) /
  ([Measure D]))?ELSE?(([Measure C]) / ([Measure D]))?----??They
  are able to obtain the expected result when removing if clause
  or using cast to float like below. ??----?IF ([Measure A] is
  null) THEN?(null)?ELSE IF(?daiatari?='1') THEN?(cast(([Measure
  B]) / ([Measure D]),FLOAT))?ELSE?(cast(([Measure C]) / ([Measure
  D]),FLOAT))?----??(Environment)?Cognos BI 10.1.0 + FP1 --
  reproduced.?Cognos BI 10.2 -- not reproduced.?
  

Local fix

• Remove if clause or use cast to float
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1  or Upgrade to IBM Cognos Business Intelligence 10.2  *
  * Fix Pack 1 or IBM Cognos Business Intelligence 10.1.1 Fix    *
  * Pack 3                                                       *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• 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

• RA21 PSN

     UP