CODEWITHSUNDEEP
oracle-databasebusiness-intelligenceoffice-addinsobieesmartview
Atefeh
Atefeh

Reputation: 181

Using smart view in OBIEE 12C

I was going to use smart view (which is downloaded, installed and added as a tab to Microsoft's products ex. Execl) and connect it to OBIEE 12.2.1.4. So I have downloaded 11.1.2.5 version.

enter image description here

According to my searching on the internet, I have found that in order to create a private connection, it should be done be selecting 'Oracle BI EE' connection provider, whilst I have not this option now. As a result, I fail to connect to OBIEE. I mean like below image:

enter image description here

As an additional INFO, I have found this URL, http://epmstream.blogspot.com/2013/06/how-to-set-up-obiee-access-through.html , which had a same problem and solved. But in my case, I couldn't unfortunately download 11.1.2.2.310 version

Could anyone help me with this issue?

Upvotes: 0

Views: 1355

Answers (1)

Chris
Chris

Reputation: 2752

You're not providing much info, but with any fresh installation of SmartView you just click SmartView -> Panel -> Private Connection and then at the very bottom "Create new connection".

There probably was something messed up on the Windows/Excel side during install (it's Windows after all...) or you had some Office product running whle installing SmartView.

You have to close all Office products completely, then find JBIPSProviderInstaller.svext on your file system (Normally C:\Oracle\SmartView). Right-click it -> Open With -> Oracle Smart View for Office.

You should get a message saying it's installed.

Upvotes: 1

Related Questions