PI05363: COGNOS BI 10.2.1 XTAB SHOWS SECTION LABELS AND "NO DATA AVAILABLE" FOR EMPTY RECORDS AND NPR WITH SUPPRESSION.

APAR status

• Closed as fixed if next.

Error description

• IBM Cognos BI 10.2.1 crosstab report against Informix CQM and
  DQM data sources shows section labels and "No Data Available"
  block for ??section (crosstab) that does not bring any records
  from database. When applying suppression for sectioning list,
  Null Pointer Error ??is thrown in DQM. ??Filtering out measure
  values in crosstab Query using ([m] is not null) will get rid of
  the section labes and "No Data Available" ??blocks. List report
  by default does show any data in same situation neither does
  crosstab against Cognos SQL Server samples.??
  

Local fix

Problem summary

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

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

• RA22 PSN

     UP