Wednesday, September 28, 2016

Smart View Tips & Options

Not to take away anyone's Thunder & Lightning from Oracle Open World this year, I was not in attendance, but it seems from all of the emails, posts, tweets and other social media outlets that, well, there is a push for all things Cloud?!?!

But in other news, for those of you that still need to use Smart View, here are a few tips, options, settings etc. for you to keep in mind to help in your data retrieval journey while you are not cloud surfing.

First, when you install Smart View, this link can be a great tool to read over for both Admins and Users alike: Oracle Smart View for Office Release Installation and Configuration Guide

There are a few great sections:
 Let us focus on the Tips and Troubleshooting section!

I hope that the links, tips and options help all users easliy hurdle some of the more common questions that I get from users and also see on many blogs and forums.

In preparation for soon to be submitted KScope 17 abstracts, the deadline is quickly approaching, Oct-14th!, I hope that you are able to Wrangle some more data via Smart View .. or in my case, maybe not Smart View, stay tuned!

Wednesday, September 7, 2016

Information Regarding NEW Smart View Installs (Doc ID 2174747.1)

posted by Oracle yesterday, Sep-06-2016

Information Regarding NEW Smart View Installs: New Installs Displays Certificate Message: "Warning: The digital signature on the application add-in is invalid and cannot be trusted. Application add-in is disabled.The following new My Oracle Support Knowledge Article is available:

Doc ID 2174747.1

per the document:

Applies to:

  • Hyperion Essbase - Version and later
  • Hyperion Planning - Version and later
  • Hyperion Financial Management - Version and later
  • Generic Windows
  • This issue applies to all versions of Smart View


After installing Smart View and opening Excel, a Microsoft Office Security Options window opens with:

"Warning: The digital signature on the application add-in is invalid and cannot be trusted. Application add-in is disabled."

This affects all new installations of Smart View. Existing installations are not impacted.


New installation of Smart View.


The certificate for the "Digital Signature" for the HsTbar.xla has expired. This is used for Spreading and VBA's.


To workaround the certificate warning:

  1. Install Smart View ("Run as Administrator"). Do not launch Excel prior to performing the next step. 
  2. Rename the HsTBar.xla file to HsTBar.xla_badcert.  This file is located in the \SmartView\bin folder. 
  3. Launch Smart View.