How to get Smart View 11.1.2 Shared connections back, if it got removed 15


In 11.1.2 Version of Hyperion Smart View you can have shared connections which will allow the user to connect to
  • Essbase (As an Administrator you’ll have to add this)
  • Planning
  • RAFramework (Reporting)
All the users can use a centralized connection.
So I was using such a shared connection in one of my projects and one day all the shared connections got disappeared. (nothing was showing up in the drop down of shared connection)
Lot of trouble shooting was done, like re-starting the services and so on, which didn’t resolve the issue.
So I thought of checking what all files are there related to APS in Shared Services Registry.
I found that there is a file called datasources.xml, so I exported the file for edit.
Open the file in an editor
File contents
<dataSources><type name=”essbase”><dataSource srv=”essbaseserver.essbase.com” url=”” app=”” cube=”” form=””/></type><type name=”planning”/><type name=”obiee”/></dataSources>
All the entries were in-tact in the file, (but not coming up in the Smart View panel) so I just added one more Essbase server and imported the xml back to Shared Services.
<dataSources><type name=”essbase”><dataSource srv=”essbaseserver.essbase.com” url=”” app=”” cube=”” form=””/></type><type name=”essbase”><dataSource srv=”essbaseserver” url=”” app=”” cube=”” form=””/></type><type name=”planning”/><type name=”obiee”/></dataSources>
I restarted all the Hyperion products and that’s it – the issue was resolved!!!!!
I got all the connection back together will new Essbase connection. (So if you are not able to add a new Essbase connection, you can use this method to add new Essbase connection to Shared Connection)

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

15 thoughts on “How to get Smart View 11.1.2 Shared connections back, if it got removed