Friday, June 28, 2013

How to set up OBIEE Access through Smart View

I recently installed the new OBIEE 11.1.1.7 via the simple install option. This is the slim-down, easy to get up-to-speed route which really turned out to be pretty much straight forward. As opposed to the Enterprise installation option, this should only be used for prototyping and is not intended for use in an environment that's actively accessed by users, whether in DEV or PROD. It installs the basic components that are needed to play around with OBIEE's components and even installs Essbase and the various Essbase tools. I'm not going through the install, this has been documented very well in other blogs, e.g. here

Everything was pretty smooth until I got to trying out the SmartView integration with OBIEE. I came across a situation that noone had experienced out there, or at least blogged about. The desciption is: open up SmartView and Create a Private connection, then select the OBIEE Provider.


Unfortunately, all I saw was what you can see below: the Oracle BI EE provider was missing:


Something was off. So I tried out a bunch of this, like using the Smart View HTTP Provider and entering the url for the OBIEE provider, but this didn't work. I was sure that all needed services were installed, though, because I was able to access the url for the OBIEE provider without an error.


Since the private connection didn't work, I tried out a Shared Connection without success. I followed the step in the Smart View User Guide for version 11.1.2.2.310 and saw the option about Accessing Shared Connections from an XML File. I followed the steps explained in there, used forward slashes instead of backslashes etc., but it did not work - because my SmartView version wasn't up to speed.

As soon as I had upgraded Smart View to version 11.1.2.2.310, everything was working fine. Both the OBIEE Provider was available as well as the setup via the local XML file for the Shared Connections worked. I really like the Shared Connection option which I was able to implement using the following SmartViewProviders.xml file which contains providers for Essbase, Financial Reports and OBIEE:

<?xml version="1.0" encoding="UTF-8"?>
<res_GetProvisionedDataSources>
<Product id="APS" name="APS-11.1.2" displayVersion="11.1.2.2.200">
<Server name="Oracle Hyperion Provider Services" 
                   context="http://localhost:7001/workspace/SmartViewProviders"> 
                </Server>
</Product>
<Product id="RAFramework" name="RAFramework-11.1.2" 
           displayVersion="11.1.2.2.000">
<Server name="Reporting and Analysis Framework" 
                   context="http://localhost:7001/raframework/browse/listXML">
                </Server>
</Product>
<Product providerType="ExtensionProvider" name="OBI EE-11.1.1.7" 
           displayVersion="11.1.1.7">
<Server name="Oracle BI, Fusion Edition" 
                   context="OBI:http://localhost:7001/analytics/jbips">
                </Server>
</Product>
<sso></sso>
</res_GetProvisionedDataSources>

After referencing this file as my Shared Connections URL


I can now see the following drop-down list of available Shared Connections in the Smart View panel:


After selecting Oracle BI, Fusion Edition, I am able to select the content that I'm interested in from the BI Presentation Catalog.


If you run into the same issue as I did, just upgrade Smart View to 11.1.2.2.310. Enjoy the new OBIEE Integration with SmartView.


2 comments:

  1. Hi,Good information about "How to set up OBIEE Access through Smart View ", and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee online training

    ReplyDelete