How to hide Excel option from Cognos Connection, Cognos Viewer and all Studios?
Technote (troubleshooting)
Problem(Abstract)
This Knowledge Base document describes how to hide the Excel option from Cognos Connection, Cognos Viewer and all Studios.
Environment
Cognos 8.3
Resolving the problem
Make backup of below files and then modify them according to instructions from Steps:• c8\templates\ps\system.xml • c8\templates\ps\portal\system.xml • c8\webcontent\pat\res\ menus.xml • c8\webcontent\pat\res\ toolbars.xml • c8\templates\ps\qs\features.xml • c8\webcontent\explore\ ANSCompiledJS.js
Steps:
1. To hide Excel in Cognos Connection and Cognos Viewer:
a) Within the file c8\templates\ps\system.xml, change the line to
b) Within the file c8\templates\ps\portal\system.xml, add the following lines after
c) Within the file c8\templates\ps\portal\system.xml, comment out the following lines by prefixing to the end of the line.
2. To hide Excel in Report Studio:
a) Within file c8\webcontent\pat\res\menus.xml, comment out the line:
b) Within the file c8\webcontent\pat\res\toolbars.xml, comment out the line:
3. To hide Excel in Query Studio:
Within the file c8\templates\ps\qs\features.xml open, comment out the following lines:
View
4. To hide Excel in Analysis Studio:
Within the file c8\webcontent\explore\ANSCompiledJS.js, remove (do not comment) the following line of code: _On=new ContextItem('',_0v,CUIWorkSheet.SafeRunReport,false,_zU,_CL);_On.SetSkipUncomitChangesChecking();_0v=_Bw.GetString('APP_RUN_MENU_EXCEL_2007');var _zU=new Array(_I2,"spreadsheetML");
5. Restart Cognos 8 service and test the Excel option to ensure they work properly.
* Note: (For 1.b) There can be only one element in system.xml. Therefore, all items you want to hide must be placed inside this element.
Related information
Administration and Security Guide for Cognos 8.3 BI (Pg - 463 & 645) -
