PM27555: AGGREGATION 'COUNT DISTINCT' OVER DATE COLUMN IN A CROSSTAB RESULTS 'DPR-ERR-2074' AND REPORT SERVER CRASH.

APAR status

• Closed as fixed if next.

Error description

• Crosstab report with multiple conditional (IF-THEN) calculations
  in Query Items fails with 'DPR-ERR-2056/DPR-ERR-2074' when
  aggragion is set to 'count distinct' for date column in a
  crosstab. ????If a new Query Item with valid expression fe. '1'
  is dragged into right side edge of crosstab columns, after
  problematic 'count distinct' QI, error does not occur. Tested
  issue with Informix datasource 8.4.1 FP2 and Cognos 10 - happens
  in both.
  

Local fix

• Create a new Query Calculation and drag that into crosstab after
   problematic Query Item (set box type 'none' to hide).
  

Problem summary

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

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