BI Admin Tool Local Install RPD Development with Oracle OLAP

For those that saw my presentation Oracle BI 11.1.1.5 Released - Changes and New Features yesterday, you may have noticed that I didn't actually import Oracle OLAP metadata.  I was working with a local install of BI Admininistrator Tool and importing OLAP metadata wasn't working.  I was getting the error "[nQSError:77005] An invalid parameter was passed to the nQWebIBotAPI.dll. Verify that the Agent configuration is correct." when trying to import the metadata.

 

Hmmm...not a very helpful error message.

 

I asked Bob Ertl after the presentation and got a very helpful reply.  Apparently, BI Admin Tool needs to be able to talk to a JAVAHOST.  Since BI Admin Tool is installed locally, there's no JAVAHOST installed with it.  So we need to modify the NQSConfig.ini for BI Admin Tool to point to a JAVAHOST that can provide the services to BI Admin Tool.

I shut down BI Admin Tool and found my NQSConfig.ini at "C:\Program Files (x86)\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\config\OracleBIServerComponent\coreapplication\NQSConfig.INI".  Since I'm running Windows 7, I had to right-click Notepad.exe and "Run as Administrator" since the file is under Program Files and I found the Javahost section at the bottom of the file and placed the following in there:

###############################################################################
#
#  Javahost Section
#  
###############################################################################

[JAVAHOST]
#JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = "<machine-name1>":<port_number1>,<machine-name2>:<port_number2>;
JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = "192.168.56.101:9810";

As you can see, my OBIEE instance is at 192.168.56.101 (actually running in a VM under Virtual Box under Linux on my Windows 7 host).

Now that I've made the change, when I choose "Import Metadata", I get the right dialog box:

 Click to enlarge image of BI Admin Tool Import Metadata dialog box I can select the portions of my Analytic Workspace that I want to import and continue on.  Hooray!  And I'm even able to do this work with the RPD in offline mode.  So a local install of BI Administrator Tool *does* work with Oracle OLAP and the Import Metadata wizard!  Enjoy!