My Oracle Support Banner

Oracle SmartView: OBIEE Provider / Extension Not Installed (Doc ID 2444075.1)

Last updated on OCTOBER 19, 2022

Applies to:

Primavera Analytics Cloud Service - Version 18.7 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Oracle Hospitality OPERA Reporting and Analytics Cloud Service - Version 21.1 and later
Oracle Hospitality OPERA Reporting and Analytics Cloud Service v9.1 - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When attempting to "Create new connection" within Excel --> Smart View, "Oracle BIEE" is not an available connection provider type.

EXPECTED BEHAVIOR

"Oracle BI EE" should be an available connection provider type from within Excel --> Smart View --> Create new connection.

STEPS

The issue can be reproduced at will with the following steps:

  1. Access the Primavera Cloud environment and click "Primavera Analytics login".
  2. From the "Download BI Desktop Tools (drop-down)", select "Smart View for MS Office".
  3. From http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html, click "Download latest version" of "Oracle Smart View for Office"
  4. Download svc11125800.zip. Extract files. Run setup.exe to install.
  5. Launch Excel and observe the Smart View ribbon is visible.
  6. Select the Smart View [tab] --> Panel --> Private connections.
  7. Click the drop-down and select "Create new connection".
  8. Observe Smart View HTTP Provider is visible, but, OBIEE is not.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, the user cannot create a new connection for Oracle BI EE provider type.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.