Business Intelligence – Oracle

Oracle BI EE – Connectivity to Essbase – First Impressions

Posted by Venkatakrishnan J on January 21, 2008

I had some time today to quickly install Essbase and BI EE to test out the newly added feature of Essbase connectivity. Following are the list of bare minimum components that you would need to get this up and running.

1.   BI EE – If you are doing an upgrade from an earlier release ensure that you have added ESSBASE = nqsdbgatewayessbasecapi; to your NQSConfig.ini
2.   Hyperion Essbase Server
3.   Hyperion Essbase Client (This is very important for the connectivity to work. If you already have an Essbase server somewhere then you would just need 1 and 3).
4.   Hyperion Administration Services (This is for starting up various Essbase applications).

You can download the Essbase components from Just an observation from my end. Ensure that you are restarting your machine once all the components have been installed (After installing Essbase, it might not ask you to restart. But BI EE would not be able to identify Essbase immediately since the Essbase client APIs need some Environment variables that get populated only after a restart). Once this is done, go to the admin tool and click on Import from Multi-Dimensional.



So far so good.


As you see, you can import databases from multiple applications simultaneously. The next step is to create a Business Model and Presentation Layer. For this we do not have to design BM and PL. All we need to do is drag and drop the folders directly into BM and PL. For example, when you drag the Sample database, you can see that all the hierarchies and joins would automatically be imported from Essbase.



Even the final reports seem to be very fast. Of course, the sample applications do not have a large dataset. Lets see how the connectivity works on a larger data set in a future blog entry.


P.S: Came to know about the existence of a new Oracle OLAP blog via Mark’s blog here. Any users who want to know about Oracle OLAP, this blog is where you should go since this is maintained by 3 well known OLAP gurus, if i may call them that. Having grown to reading Kevin Lancaster’s long educative replies in our internal mailing lists, i have been waiting for him to be part of a blog so that others can also benefit. Looks like the wait is over :-). Also, the other 2 authors, Keith and Jameson are well known within Oracle OLAP circle. Both Keith and Jameson are former Product Managers. If you do not know where to start you should start with their Workshop series.


13 Responses to “Oracle BI EE – Connectivity to Essbase – First Impressions”

  1. Brijesh Goyal said

    Hi Venkat,

    I tried to connect to the essabse cube following the steps given by you but ende with the errir saying “Admin Tool has encountered the problem and need to close”.


  2. Venkatakrishnan J said

    @Brijesh – Restart your BI Server and try again. I have seen that happening for some users. If it still does not work re-install your hyperion essbase client API.

  3. Brijesh said

    Hi Venkat,

    I had re-install the hyperion essbase client API. But it still showing error —
    “Error Signature—-
    AppName: admintool.exe AppVer: ModName: essapinu.dll
    ModVer: Offset: 00009eb1”

    The following files will be included in this error report

    I am using OBI and Essbase analytic server and admin server and hyperion analytics client

    Is there any role of Provider services in for connection and any type of configuration is required for this purpose.



  4. Anan said

    Hi Venkat,

    When I tried to do the import. The system is giving me the following message:

    “You do not have sufficient access to get this substitution variable.”

    Do you have any idea what that means?

    Is it the account that I am using to connect to the database?



  5. JGinta said

    Hi Brijesh,

    I was using the same configuration as you did, and having the same problem.

    After installing the latest Essbase Client API (just the client) version 9.3.1, it’s solved.

    My OBI-EE connects to Essbase Cubes. Looks like OBI can only connect to Essbase through the latest Essbase Client API.


  6. Timorro said

    Hi Venkat,

    I’ve successfully connected an Essbase cube to obiee, I also tested out ragged dimensionality which seems to work quite well. What’s great is the drag and drop from physical to business layer. What I find strange is that Oracle doesn’t provide this nice functionality for it’s OWN oracle olap. Connections to olap datasources require quite a bit of work in the business model, and don’t provide ragged hierarchy support (out of the box). Is it in oracle’s strategy to allow oracle connectivity to olap as a multdimensional source in future releases of OBIEE?

    Cheers and thanks for the blog posts have been invaluable in my OBIEE work 😉


  7. edoardo said

    Hi all,
    Im using BI and Essbase
    No problem importing metedata with Administrator; I can also use administrator in online mode.
    When I try to use answer to view data I have the following error:

    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError:
    10058] A general error has occurred. [nQSError: 12002] Socket communication error at call=recv: (Number=10038) An operation was attempted on something that is not a socket. (HY000) SQL Issued: SELECT FedMog.Cost saw_0 FROM “”
    If I use a releational database I don’t have any problem.

    Do you have any suggestion?

    Thanks in advance

  8. Gurpreet said

    Hi Venkat,

    I imported the tables from the ESSBASE. When I tried update them again after few days, The system is giving me the following message:

    “You do not have sufficient access to get this substitution variable.”

    I am using the admin user name password for ESSBASE. I already talked to ESSBASE administrator, he said no variables are changed.

    Do you have an idea??

  9. Gregory said

    I am having the same issue as mentioned above. I receive the following error message when trying to connect to Essbase:

    “You do not have sufficient access to get this substitution variable.”

    Has anyone found a solution for this?

  10. Vinod said

    hi gregory,

    U need to be supervisor for the cube that you are trying to access.

  11. Praveen said

    Hi Venkat,

    Can you explain in detail how the connection between Oracle BIEE and Essbase is established. I have sent you an email yesterday. Could you please let me know indetail.
    What is the use of the following parameter:
    ESSBASE = nqsdbgatewayessbasecapi;


  12. Thomas Dodds said

    I can import correctly, but when I try to view results in Answers I get:

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. cannot open shared object file: No such file or directory [nQSError: 36001] Unable to load the dll (HY000)

    Any help appreciated.

    OBIEE – Linux AS 4.6 – ESSBASE Client 9.3.1.

  13. ST said

    Timorro (#6)

    what do you mean by

    ‘I also tested out ragged dimensionality which seems to work quite well.’

    You still are looking it from OBIEE Answers?…can you elaborate?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: