APAR status
Closed as program error.
Error description
In 8.4 reports fail to run having the option to run reports using Excel 2000 as the output. This is expected behaviour, as we do not support Excel 2000 but we do support the Excel 2000 format for use in newer versions of Excel. However, the entry Excel 2000 causes confusion and should be removed.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * Want to control the presence of the Excel 2000 menu. By * * default want to hide the menu option while making it * * possible to "unhide" it using a reconfiguration procedure * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos 8 Business Intelligence 8.4.1 FP2 * * * * Reconfiguration instructions: * * * * By default the Excel 2000 menu option will be hidden. * * Reconfiguration is achieved by modifying XML files. * * Comments in XML file are contained within a "<!--" and * * "-->". The opening of the block comment is "<!--" and * * marking the close of the block is "-->". * * * * * * Report Studio * * * * Determine Current Setting: * * * * View the contents of the two ASCII XML files: * * ReportStudioLaunch.xml and ReportStudioPPReportLaunch.xml * * which reside in the directory <C8 * * install>/templates/ps/portal/launch. * * * * Locate the block starting with the XML comment â˜<!-- This * * ui.hideXLS declarationâ™. Below this section there are two * * blocks each of which assigns different values to the param * * XML element whose name attribute is "ui.hideXLS". Only one * * definition of those two definitions must be in effect. * * * * If the definition below is not commented: * * * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * * * then the Excel 2000 menu option will be hidden regardless of * * the Firewall status. Otherwise if block below is not * * commented: * * * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * * * then Excel 2000 output menu option is available when the * * Cognos Firewall is disabled. * * * * Change Current Setting: * * * * Edit both ASCII XML files: ReportStudioLaunch.xml and * * ReportStudioPPReportLaunch.xml which reside in directory <C8 * * install>/templates/ps/portal/launch. * * * * Using an editor of your choice locate the block starting * * with the XML comment â˜<!-- This ui.hideXLS declarationâ™. * * Below this section there are two blocks assigning different * * values to the param XML element whose name attribute is * * "ui.hideXLS". * * * * To restore the Excel 2000 menu option (so it is visible when * * Cognos Firewall is off) uncomment the block (remove the * * leading <!-- before the <param> and the closing --> after * * the </param>): * * * * <!-- (REMOVE THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * --> (REMOVE THIS LINE) * * * * and comment the block : * * * * <!-- (ADD THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * --> (ADD THIS LINE) * * * * To hide the Excel 2000 menu option (the default behavior) * * comment the block such that it looks as below: * * * * <!-- (ADD THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * --> (ADD THIS LINE) * * * * and uncomment the block such that it looks as below: * * * * <!-â” (REMOVE THIS LINE IF PRESENT) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * --> (REMOVE THIS LINE IF PRESENT) * * * * This modification is required to both files: * * ReportStudioLaunch.xml and ReportStudioPPReportLaunch.xml in * * directory <C8 install>/templates/ps/portal/launch. Restart * * the service for the modification to take effect. * * * * * * Analysis Studio * * * * Determine Current Setting: * * * * View the contents of the two ASCII XML files: * * AnalysisStudioLaunch.xml and * * AnalysisStudioPPReportLaunch.xml which reside in the * * directory <C8 install>/templates/ps/portal/launch. * * * * Locate the block starting with the XML comment â˜<!-- This * * ui.hideXLS declarationâ™. Below this section there are two * * blocks each of which assigns different values to the param * * XML element whose name attribute is "ui.hideXLS". Only one * * definition of those two definitions must be in effect. * * * * If the definition below is not commented: * * * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * * * then the Excel 2000 menu option will be hidden regardless of * * the Firewall status. Otherwise if block below is not * * commented: * * * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * * * then Excel 2000 output menu option is available when the * * Cognos Firewall is disabled. * * * * Change Current Setting: * * * * Edit both ASCII XML files: AnalysisStudioLaunch.xml and * * AnalysisStudioPPReportLaunch.xml which reside in directory * * <C8 install>/templates/ps/portal/launch. * * * * Using an editor of your choice locate the block starting * * with the XML comment â˜<!-- This ui.hideXLS declarationâ™. * * Below this section there are two blocks assigning different * * values to the param XML element whose name attribute is * * "ui.hideXLS". * * * * To restore the Excel 2000 menu option (so it is visible when * * Cognos Firewall is off) uncomment the block (remove the * * leading <!-- before the <param> and the closing --> after * * the </param>): * * * * <!-- (REMOVE THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * --> (REMOVE THIS LINE) * * * * and comment the block : * * * * <!-- (ADD THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * --> (ADD THIS LINE) * * * * To hide the Excel 2000 menu option (the default behavior) * * comment the block such that it looks as below: * * * * <!-- (ADD THIS LINE) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue><cafValue * * type="signedreporturls"/></defaultValue> * * </param> * * --> (ADD THIS LINE) * * * * and uncomment the block such that it looks as below: * * * * <!-- (REMOVE THIS LINE IF PRESENT) * * <param name="ui.hideXLS"> * * <alias>hideXLS</alias> * * <defaultValue>true</defaultValue> * * </param> * * --> (REMOVE THIS LINE IF PRESENT) * * * * This modification is required to both files: * * AnalysisStudioLaunch.xml and * * AnalysisStudioPPReportLaunch.xml in directory <C8 * * install>/templates/ps/portal/launch. Restart the Cognos * * service for the modification to take effect. * * * * * * Query Studio, Viewer and Cognos Connection * * * * The Excel 2000 output menu option presence is controlled by * * an entry in system.xml. This system.xml file exists in <C8 * * install>/templates/ps (there are other files with the same * * name in different locations so confirm changes are being * * made to the correct file). * * * * Determine Current Setting * * * * In the system.xml file there is an entry listed below which * * could be commented out. When the entry is commented then * * the above three UIs will not show Excel 2000 as a possible * * output option in their menus. * * * * <format id="XLS" browserHide="safari moz other" * * downloadable="false" appMode="basic adv rv" * * cafaction="true"/> * * * * Change Current Setting * * * * To hide the Excel 2000 menu option (the default behavior) * * * * Using an editor of your choice modify the system.xml file * * and add an XML comment to the format element whose "id" * * attribute is "XLS". For example such as below: * * * * <!-- <format id="XLS" browserHide="safari moz other" * * downloadable="false" appMode="basic adv rv" * * cafaction="true"/> --> * * * * To restore original behavior that is Excel 2000 menu is * * displayed when Cognos Firewall is off. * * * * Using an editor of your choice remove the XML commenting * * around the "format" element whose "id" attribute is "XLS" * * such that the entry look as below and is not contained in * * any XML comment block: * * * * <format id="XLS" browserHide="safari moz other" * * downloadable="false" appMode="basic adv rv" * * cafaction="true"/> * ****************************************************************
Problem conclusion
Modifications to 2 launch template files for Report Studio and 2 others for Analysis Studio. In these files there are two defin itions of an element. One is commented while the other is not. To switch behavior the operator would need to uncomment one ent ry while commenting the other. The system.xml in templates/ps has been modified to comment out the XLS report format entry. This has the effect of making View er and Cognos Connection hide the Excel 2000 menu option. To sw itch the user would have to remove the comment around the commen ted entry.
Temporary fix
Comments
APAR Information
APAR number
PK89181
Reported component name
COG8 BI INST CO
Reported component ID
5724W12IC
Reported release
840
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-17
Closed date
2010-06-28
Last modified date
2010-06-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 INST CO
Fixed component ID
5724W12IC
Applicable component levels
R841 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.4","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 November 2022