Friday, June 28, 2013

How to set up OBIEE Access through Smart View

I recently installed the new OBIEE 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 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, 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"?>
<Product id="APS" name="APS-11.1.2" displayVersion="">
<Server name="Oracle Hyperion Provider Services" 
<Product id="RAFramework" name="RAFramework-11.1.2" 
<Server name="Reporting and Analysis Framework" 
<Product providerType="ExtensionProvider" name="OBI EE-" 
<Server name="Oracle BI, Fusion Edition" 

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 Enjoy the new OBIEE Integration with SmartView.


  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

  2. i2econsultancy is a leading EPM solution provider who is Microsoft certified partner that offers customized solutions to analyze, maintain, and regulate essential data of different projects organized by a company on one general portfolio. For More details

  3. Thanks for sharing these information. It’s a very nice topic. We are providing online training classes oracle bi online training

  4. we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact
    obiee training in hyderabad


  6. Hello,Thanks for the Useful information about "how to set up OBIEE access to smart view".Graphical representation is giving a clear understanding.I found the same kind of explanation from TekSlate as well.
    OBIEE online training

    1. Revanth Technologies which is a high profiled Java and J2EE online training institute in India offers online training with real time experts and with real time concepts. We provide integrated IT training services and the complete range of IT training to provide all the requirements of both individual learners and corporate clients.

      We are the leaders in the field of professional Online IT training services in implementing world class infrastructure and technology. We provide the training with industry leading experts with real time scenarios..

      In the course duration we are covering Core Java Training which includes Collection Frameworks and Swing Provided with Free Project implementation. Object Oriented Programming Concepts. Manual programming as well as training with Eclipse and J2EE Training covers JDBC with Servlets, JSP and EJB and struts with Webservers like Apache Tomcat 5.5 and Application Servers like Bea Weblogic Server with Eclipse IDE with XML.

      For more details please contact 9290971883 or 9247461324.
      Mail id :
      For course content and more details please visit

  7. Thank you for your great information on salesforce online training in hyderabad.

    salesforce online training
    salesforce online course