PH11656: NO DATA AVAILABLE WHEN DRILLING FROM DASHBOARD TO REPORT ON NULLVALUE

APAR status

• Closed as fixed if next.

Error description

• A dashboard is created based on a data module.  The dashboard
  contains a visualization which has categorical entries, like a
  bar chart.  One of the category values is NULL.  A drill is set
  up from this dashboard to a report, which contains a
  parameterized filter on the same categorical column.  Drilling
  on one of the non-NULL values works as expected, and returns
  report results filtered on the selected value.  When drilling on
  the NULL value, the report shows a No Data Available message as
  no rows are returned.
  

Local fix

• Create a calculation in the Dashboard and in the report query to
  replace NULL values with another string, like:
  
  if (Category is null) then ('N/A') else (Category)
  
  Change the report filter to use this calculation instead of the
  original column.  Change the dashboard visualization to use this
  calculation, and change the drill through definition to pass
  this calculated field to the report parameter.  After making
  these changes, the drill will work for the 'N/A' value.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.4                       *
  ****************************************************************
  

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