COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Croky on 19 May 2016 03:55:09 AM

Title: Disable CSV output for Users but not for Administrators
Post by: Croky on 19 May 2016 03:55:09 AM
If it's possible to disable the option "View in CSV" for customers/users, but keep it still  available for Administrators.
Title: Re: Disable CSV output for Users but not for Administrators
Post by: cognoslearner1 on 09 Jun 2016 05:12:03 AM

To achieve this you have to make changes in systems.xml file . Please find the below steps.

Open the system.xml file in the c10_location/templates/ps directory.

In the below code, remove or comment out the format element associated with the report format you want to disable.
<param name="reportFormats">
<!-- Comments -->
   <format id="HTML" browserHide="" downloadable="false"
appMode="basic adv rv"/>
   <format id="XHTML" browserHide="" downloadable="false"
appMode="adv"/>
   <format id="HTMLFragment" browserHide="" downloadable="false" appMode="adv"/>
   <format id="PDF" browserHide="" downloadable="true"
appMode="basic adv rv" extension="pdf"/> -->
   <format id="spreadsheetML" browserHide="safari" downloadable="true"
appMode="basic adv rv" extension="xlsx"/>
   <format id="XLWA" browserHide="safari" downloadable="true" appMode="basic
adv rv" extension="xls" mime="application/vnd.ms-excel"/>
   <format id="singleXLS" browserHide="safari" downloadable="true"
appMode="basic adv rv" extension="xls"/>
   <format id="XLS" browserHide="safari moz other" downloadable="false"
appMode="basic adv rv" cafaction="true"/>
   <format id="CSV" browserHide="" downloadable="true"
appMode="basic adv rv" extension="csv"/>
   <format id="XML" browserHide="" downloadable="true"
appMode="basic adv rv" extension="xml"/>
</param>


The following example shows how to disable the PDF format:

<!-- <format id="PDF" browserHide=""
downloadable="true" appMode="basic adv rv"/> -->
The following example shows how to disable support for the CSV format for advanced run options and scheduling by deleting the adv attribute:

<format id="CSV" browserHide="" downloadable="true"
appMode="basic rv"/>
Save the system.xml file.

Restart the IBM Cognos service.

http://www.ibm.com/support/knowledgecenter/SSRL5J_1.1.0/com.ibm.swg.ba.cognos.ug_cra.10.1.1.doc/t_customizereportformatsincognosconnectionandcognosviewer.html

-- Cognoslearner1
Title: Re: Disable CSV output for Users but not for Administrators
Post by: Penny on 10 Jun 2016 12:33:51 PM
Is it not possible to do this in Administration - Capabilities?
Title: Re: Disable CSV output for Users but not for Administrators
Post by: cognoslearner1 on 15 Jun 2016 03:07:34 AM
Yup - This can be done in administration as well. Just go to launch > administration > capabilities > select output as csv . and change permissions here.

--Cognoslearner1.