Exalytics and OBIEE 11g: How To Remove 'Download Oracle BI Tools' Menu Links from Presentation Server without Removing Privileges to SmartView and BIOffice (Doc ID 1950079.1)

Last updated on DECEMBER 04, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Information in this document applies to any platform.

Goal

OBIEE Administrator does not want to display the following menu in the OBIEE presentation server -> BI home -> 'Download BI Desktop Tools'


To accomplish this, the catalog privileges were modified and 'Access to Oracle BI for Microsoft Office' was set to Denied.  This removed the links, but then prevented users from accessing SmartView.  If user attempted to use SmartView, an error occurred:

'Logon error. The user does not have the MSOffice authority'

How can the "Download BI Desktop Tools" links be removed and still allow access to SmartView?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms