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 11.1.2.5.600 Installation and Configuration Guide

There are a few great sections:

• Installing Smart View
• Administering Extension Installations and Updates
• Accessing Shared Connections from an XML File
• Installing and Configuring Help Locally or on a Web Server
• Tips and Troubleshooting
• Limitations

 Let us focus on the Tips and Troubleshooting section!

• Diagnostics Tools
• Installation and Languages
• Windows, Office, and Smart View Locale Settings
• Error When First Launching Excel After Installing Smart View
• Internet Explorer Compatibility View Settings for Financial Reporting
• Working with Custom HTML-based Login Forms
• Browser Settings When Working with XML Files on HTTP Server
• Flickering Issues on Office 2013 32-bit and 64-bit
• Issues When Starting Excel in Automation Mode
• Slowness with Extension Options Dialog Box
• Performance and Memory Usage Considerations for Smart View with Excel
• Smart View HTTP Session Timeout
• Duplicate Queries in Word Slow to Refresh
• Issues with Dynamic Data Exchange Option in Excel
• Transition Navigation Keys Not Supported 

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!

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 11.1.2.4.000 and later
• Hyperion Planning - Version 11.1.2.4.000 and later
• Hyperion Financial Management - Version 11.1.2.4.000 and later
• Generic Windows
• This issue applies to all versions of Smart View

Symptoms

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.


Changes

New installation of Smart View.

Cause

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

Solution

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.