[2011-05-16T20:34:42.184-05:00] [AnalyticProviderServices0] [ERROR] [] [oracle.EPMOHPS] [tid: 18] [userId:
java.lang.NullPointerException
at com.hyperion.dsf.server.framework.BaseLogger.writeException(Unknown Source)
at com.essbase.smartview.util.EssLogger.writeException(Unknown Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.EssbaseSmartView.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
... blah, blah, blah!
I did a quick search of the web and found nothing relevant, so I turned to my friend and fellow ACE Cameron Lackpour.. Cameron had just finished working his way through the Oracle Knowledgebase notes on Smart View on Oracle support. He came up with this nugget:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1098634.1
It told me the cause of my ills was an incomplete configuration and gave me a couple of different methods to complete the configuration. I chose to export and edit the datasources.xml file.
In the xml, I simply had to add my Essbase server name:
Once that was complete, I was able to create a private connection: