APAR status
Closed as documentation error.
Error description
Refreshing data using Cognos for Microsoft office in Excel causes duplicate charts when report contains a repeater with charts
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: * * CA users * **************************************************************** * PROBLEM DESCRIPTION: * * Report contains a repeater table which contains charts. * * Report imports fine into Excel using Cognos for Microsoft * * Office. * * When refreshing the data for the report, the charts are * * duplicated. * * * * Testcase: * * * * Report spec attached created against GO Sales (query). * * Report contains repeater table with charts. * * Launch Excel with the Cognos for Microsoft Office enabled. * * Import the report into Excel. It does not make any * * difference it you import the whole report or just the * * repeater. * * From the IBM menu, select Refresh All Data->Refresh the data * * only * * At first it looks fine, but if you click on one of the * * charts and move it, you will see a chart underneath. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
, I've added the following note to the Cognos for Microsoft Office User guide: Note: If charts are contained in repeater controls within Excel, refreshing data may cause the charts to duplicate. See these topics: * (11.1) https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=office -retrieving-content-from-cognos-analytics * (11.2) https://ibmdocs-test.dcs.ibm.com/docs/en/cognos-analytics/11.2.0 ?topic=office-retrieving-content-from-cognos-analytics (the 11.2 topic will be on production server tomorrow)
Temporary fix
Comments
APAR Information
APAR number
PH42636
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B0A
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-12-08
Closed date
2023-03-17
Last modified date
2023-03-17
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0A","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
17 March 2023