Setting A Discoverer Preference At A User Level

For Discoverer 10g:

1. On the Discoverer 10g Server machine, please set the environment variables by running the following script,

. ./$OH/discoverer/discwb.sh (Note : It is dot space dot slash …)

2. Then run the following command to set the preference at the user level,

dis51pr -user [user_name]@[dbstring] -setpref “Application” “ExcelExportWithMacros” 1

Note: Please ensure to provide the username, database string value in the above command.

For Discoverer 11g:

1. On your Discoverer 11g Server machine, please set the environment variables by running this following script.

. ./<ORACLE_INSTANCE_Home>/Discoverer/Discoverer_bi111_inst/util/discenv.sh   (Note : It is dot space dot slash …)

2. Then run the following command to set the preference at the user level,

dis51pr -user [user_name]@[dbstring] -setpref “Application” “ExcelExportWithMacros” 1

Note: Please ensure to provide the username, database string value in the above command.