IBM Support

PH02533: CALCULATED FIELDS ON NON-NUMERIC COLUMNS CANNOT BE USED TO FILTER DASHBOARDS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as unreproducible.

Error description

  • A customer is reporting that when attempting to create a
    calculation on a dashboard, then using that calculated field as
    a filter, filtering does not work. This is only the case when
    the calculation references a non-numeric column.
    
    Generally, calculations cannot be made on non-numeric columns,
    but doing this is 'possible' by selecting a numeric column from
    navigation, creating a calculation, then adding in a non-numeric
    column name manually to the expression (type in column name to
    expression in calculation wizard).
    
    This is seen by support as a work around to achieve a behavior
    that is not the intended design of the product. We believe
    taking this unusual action to create a calculated field is the
    reason for the field's inability to be used as a filter. The
    reason for creating this calculated column was simply a work
    around to give a column a new name.
    
    I have raised this as an APAR logged against documentation
    because if there is a defect here, I believe it is the fact that
    when a user attempts to create a calculated field with a
    non-numeric column, they should be met with an error message. It
    seems clear that we do not expect users to create calculations
    on non-numeric columns since users cannot do so by selecting the
    column from navigation; it can only be done by manually adding
    the column name to an expression after choosing the numeric
    column to prompt the calculation wizard.
    
    Case: TS001284831
    
    Customer is looking for a definitive statement from OM that this
    is not design intent.
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH02533

  • Reported component name

    COG DASHBOARDS

  • Reported component ID

    5724W12DB

  • Reported release

    B09

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-06

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

  • 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: B09

Reference #: PH02533

Modified date: 05 June 2019