Written By: Jia Huang - Principal Consultant
Publication Date: 05/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.
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.
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.
Restart Excel and the Smart View tab should be available at the top tab of the Excel window.
Paradigm SES provides EPM and BI solutions to companies across the globe. Our team of experts have over 30 years of hands-on functional experience. We deliver process improvements, data management, data visualization and reports, and greater insights to multiple fortune 500 companies.
Our experience in hundreds of different functions allows us to quickly identify proven solutions that will work within most any area of a business environment. We are passionate about creating better work environments through efficiency and imaginative solutions.
Call Us If you are interested in our services!
We offer Autonomous Systems for EPM Cloud Applications such as Oracle Planning & Budgeting Cloud Service (PBCS)/EPBCS, Financial Close & Consolidations Cloud Service (FCCS), Hyperion Financial Management (HFM), Account Reconciliation Cloud Service (ARCS), Profitability & Cost Management (PCM) and more.