Smartview Installation Guide

By: Jia Huang - Principal Consultant
Published: May 18, 2020

This is an article that is providing steps to properly install Oracle Smart View to Excel due to the common failure of installation. Smart View is an Excel add-in tool, that connects with Hyperion Planning and Essbase, to create formulas to calculate data values.

Step 1

Download and install the compatible version of Smart View and Smart View Extension from an EPM Cloud Application. After downloading successfully, install the SmartView application first (refer to the screenshot below). Then install the SmartView Add-On for Administrator if needed.

Step 2

Open Excel and see if SmartView showed up in the top tool bar. If not, enable SmartView according to the following steps.
File > Options > Add-ins > Active Oracle Smart View for Office for Excel Add-in and COM Add-in Once Oracle SmartView for Office is enabled, access to the same Add-ins page, and check Excel Add-Ins, make sure the SmartView file, HsTbar.xls, is also enabled.

Step 3

Restart Excel and the Smart View tab should be available at the top tab of the Excel window.

Smart View Benefits

  • Easily access data from Business Intelligence and EPM applications
  • Able to update data to be imported into database
  • Creating custom reports
  • Effectively drill down to the appropriate hiearchy of data
  • Add custom formulas to analyze data


Schedule your Free Consultation, to see it in action!
Contact Us!

We offer Autonomous Systems for EPM Cloud Applications such as Oracle Planning & Budgeting Cloud Service (PBCS/EPBCS), Financial Close & Consolidations Cloud Service (FCCS), Enterprise Data Management Cloud Services (EDMCS), Account Reconciliation Cloud Service (ARCS), Profitability & Cost Management (PCM) and more.