IBM Support

PM02783: INCONSISTENT TIME INTERVAL DATA FORMATTING IN CROSSTAB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Time interval formatting is partially lost in crosstab when
    crosstab refers to a union query. Issue appears when cast([data
    item], interval second) function is used on a number in the
    queries that then make up the union. When the report is run if
    there is an empy cell in the crosstab all the following cells
    will lose the Time Interval formatting.
    

Local fix

  • apply the cast([data item], interval second) function directly
    on the data item in the union.
    

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM02783

  • Reported component name

    COG8 BI REPORT

  • Reported component ID

    5724W12RS

  • Reported release

    840

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-04

  • Closed date

    2010-10-28

  • Last modified date

    2010-10-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    COG8 BI REPORT

  • Fixed component ID

    5724W12RS

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 October 2010