IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    PH11656

  • Reported component name

    COG DASHBOARDS

  • Reported component ID

    5724W12DB

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-01

  • Closed date

    2019-10-15

  • Last modified date

    2019-10-15

  • 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



Document information

More support for: Cognos Analytics
Cognos Dashboards v11x

Software version: B0A

Reference #: PH11656

Modified date: 15 October 2019