Skip to main content

Shared Connection and Private Connection


You connect to data sources through shared or private connections.
Shared Connections
•Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename.
Private Connections
•Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection.

Shared Connections :



1.From the Smart View ribbon, click Panel.

2.From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following:


•Click a connection name under Recently Used. You can click    to pin items to this list.•Select Shared Connections to open the Shared Connections panel, where you select a data source from the drop-down menu. Connections available for the selected data source are displayed in a tree list•Enter the Username and Password for the database you wish to connect to.

Once you are connected to data source select the server to proceed.

Your server can be Essbase, Planning or Reporting and Analysis as per your requirement.

Here we are selecting Planning Server.

Once you select the Planning Server, it will show you the available planning server and the databases under it with Forms,                Task Lists, Dimensions under it ; depending on the level of access you have to the database.





Private Connections:

To add a connection using a URL:
1.From the Smart View ribbon, click Panel.
2.From the Smart View panel, click the arrow next to Home Icon, and then select Private Connections.
3.In the text box, enter the URL or the local storage directory for the data source to which you want to connect. The URL syntax for the various data sources is as follows. Contact your system administrator for the URL to use:
Financial Management: http(s)://servername:port/hfmofficeprovider/hfmofficeprovider.aspx
Hyperion Enterprise: http://servername:port/heofficeprovider/heofficeprovider.aspx
Planning: http(s)://servername:port/HyperionPlanning/SmartView
Essbase: http(s)://servername:port/aps/SmartView
Reporting and Analysis: http(s)://servername:port/raframework/browse/listxml
Financial Close Management: http://servername:port/fcc/servlets/smartview/fcmsvservlet
Oracle Hyperion Strategic Finance: http://servername:port/StrategicPlanning/SmartView

While using a Planning Server so let me show you how to add a Private Connection for Planning :
Step1 : Go to Private Connection Panel -> Select Create New Connection
Step2 : Select Smart View HTTP Provider to give the data source link to the Smart View.
Step3 : Enter the URL as per the Data Source used (here Planning), Click on Next.
Step4 : Select the available Server and the database you want in your Private Connection, Click on Next
Step5 : Name your Connection, you can also set a description for it (not compulsory)
Step6 : Click on Finish. Your Private Connection is established.

You can now see your Private Connection enlisted and connect to do Adhoc Analysis, Open Forms, Dimensions etc. from it.
Once you Add a Connection as Private Connection you will be able to see it under Active Connections.




Thanks!!

Popular posts from this blog

Temp files related issues on your Essbase Server

While running an Aggregation process or a restructure in essbase have you ever encountered either of these: EAS quits accepting logins Essbase going down time and again. Failed Data load / Failed Data Export / Failed Level 0 export All of the above together :) In all these cases, there is a huge possibility that you are facing creation of tmp files issue on your Essbase Server, specifically if you are on Linux The Temp directory contains mostly files that are required temporarily. Many programs use this to create lock files and for temporary storage of data. Do not remove files from this directory unless you know exactly what you are doing! Many of these files are important for currently running programs and deleting them may result in a system crash. Usually it won't contain more than a few KB anyway. On most systems, this directory is cleared out at boot or at shutdown by the local system. In MS-Dos  and Windows , the temporary directory is set by the environment ...
Home

Registry file to update Smart View Timeout Settings

“ The Request Timed Out. Contact your Administrator to Increase netRetryCount and netRetryInterval. IE7 and IE8 & IE9 have a 30-second timeout when waiting for communication from the server. When adding form data, Smart View can take longer than 30 seconds to get confirmation from the Planning server that the changes were made and saved. A similar constraint exists for Essbase data. Pre update registry Settings Open the command prompt window by clicking the start  button   >Search bar >Key in regedit navigate to the below path and check the existing settings you might not have” KeepAlive,ServerInfo & ReceiveTimeout ” HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings Automated Resolution Steps 1)       Create a file called “test.reg” 2)       Edit the file in notepad. 3)       Add th...
Home