How to Hide the View Worksheet Link for a Discoverer Portlet

Tip applicable to Discoverer 9.0.2+

Solution:

You need to modify the worksheet_run.xsl file. This file is located in your middle tier ORACLE_HOME. The full path for the file is shown below.

1. Open the file: /j2ee/OC4J_BI_Forms/applications/discoverer/web/portal/worksheet_run.xsl

2. Look for the section in the file that looks like this:

3. <a href="{$viewwslink}">
   <font color="#003366" size="2">
   <xsl:call-template name="func_build_resource_string">
   <xsl:with-param name="phrase_name">ws_show_viewer_link</xsl:with-param>
   </xsl:call-template>
   <xsl:text> </xsl:text>
   </font>
   </a>

4. If you remove this section between the and including the tags as shown below, you will not see the Viewer link in the portlet.

4. You need to restart OPMN before you can view the changes you have made.

Note: Changes to XSL may be overwritten when installing a patch. Make sure you backup/document your changes and verify them after you have applied the patch.