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)
Very HELPFUL issue
It actually worked.
Thank you.
Celvin, Can you tell me where to place this xml file in hyperion planning web server?
@anon it is not on server. That file is in shared services.
wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website 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! Thanks a ton once again, Regards,
obiee training in hyderebad
Thanks to this post, such an easy resolution
Cheers,
Celvin, I can see this xml file in 11.1.2.1 but not on 11.1.2.2. Any thoughts?
Further update….I was able to find the xml file in the aps/bin directory on 11.1.2.2 environment but can't see it in the shared services console.
From the version which they introduced Shared connection in a XML, datasources.xml is not needed. I guess it was added from 11.1.2.2.102 (not sure)
I don't see the file in 11.1.2.4. So I assume it no longer works?
No I guess it got changed in 11.1.2.3 (maybe before) code line, it is not used anymore. You can define your own Shared Connections in an XML file. I've covered that here Smart View Shared Connection in an XML
We have a requirement where the server aliases need to be visible instead of the servers to all the users who use smartview across different time zones. In 11.1.2.1, I could change the datasources.xml file and users were able to view the aliases instead of server in smartview. Is this possible in 11.1.2.4?
Check my comment above for doing that in 11.1.2.4
I am only able to view the Essbase Servers and want to replace the Essbase Servers with the aliases in the drop down in Smartview. For Example: EssbaseCluster-1 should be visible as EssbasePROD (Alias for EssbaseCluster-1) in the Drop down list for Users in Smartview
How can we add a new Essbase Server to the essbase Servers list in Smartview?