Then you should see the Catalog displayed on the right You can then give the connection a name to save it as Choose Private Connection, then Create new connection from the bottom of the screen.Select the OBIEE Extension to install, once successful you should see You need to check Check for updates when Microsoft Office starts, then you should get a link above saying Check for Updates, New Installs and Uninstalls The OBIEE extension is no longer installed out of the box Fortunately a colleague of mine pointed out the OBIEE extension wasn't actually installed by default any more, so that's what I needed to do next. When I last did this (not sure how long ago that was), I think the OBIEE extension was installed by default, so I put in the OAC connection string and then couldn't work out why I kept getting an error. Double click to install and accept the defaults.

Download Smart View (see here) - for reference I downloaded version 11.1.2.5.910.All I needed to do was get Smart View connecting to OAC. I wanted to demonstrate what I thought would be a simple task to a client today, however it turned out to be a little more complex than I first anticipated, so I thought I would publish here.

Download smartview excel