IBM Support

PM78652: "REFRESH DATA AND FORMATTING" OPTION IN CAFE TAKES EXCESSIVELY LONG TIME TO RUN IN COMPARISON TO "REFRESH DATA"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • Through testing various options within CAFE for report
    refreshing, the majority of methods to refresh data (e.g.
    "Refresh Data" and "Refresh All Data") return data in a short
    time (2 minutes, based on test case provided) whereas "Refresh
    Data and Formatting" takes a very large amount of time (~25
    minutes with the same test case).??According to the client, this
    has not always been the case.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Importing a report takes longer because both data and format hav
    e to be rendered. Rendering the format takes much longer than re
    ndering the data and this is a limitation with Excel. This is wh
    y there are two ways to refresh the report. Refresh data is the
    recommended way to refresh because it is much faster than refres
    h with format. Refresh with format is necessary only when the fo
    rmat of the report is changed.
    

APAR Information

  • APAR number

    PM78652

  • Reported component name

    COG FOR MS OFFI

  • Reported component ID

    5724W12GO

  • Reported release

    A11

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-06

  • Closed date

    2013-03-21

  • Last modified date

    2013-03-21

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 November 2022