Importing data from Essbase cubes.

While using Oracle Essbase as your data source in OBIEE, there are some additional things that you need to configure before proceeding.

My previous article about "Setting Up Essbase Data Sources" will help to do this.

When you are done with this configuration steps, you are good to go with handling Essbase data source with OBIEE. But there's a problem if you don't know what are default port on which your Essbase data source is installed. If everything is installed on the default ports by your Admin, you are lucky enough; but unfortunately that's not the truth always. If it is not, you might get the following error message,

Essbase Error: 1030818: Login failed. Please check if server and port are correct. If you received timeout or handshake failure, please check if you tried to connect to secure port without secure keyword or clear port with secure keyword.

To get on which port your essbase can be accessible, you can follow the below steps.

• Open you easconsole
• http://Ess_Server:9704/easconsole
• Launch application.
• Put the credentials to connect your Essbase server.
• Expand Essbase servers.
• Select your particular Essbase server where your cubes are residing. (In my case, EssbaseCluster-1)

• Right click and go to Edit > Properties.

• Move to Environment tab.

You can use this AGENT PORT at the time of importing your cubes in OBIEE. Refer the following screenshot,

Happy stay.. :-)