OLAP

New White Paper on Oracle OLAP and Exadata

Oracle has posted a very nice white paper on Oracle Technet that shows how Oracle OLAP on Exadata can be used to support adhoc OLAP-style queries on a half-rack Exadata box.  The white paper builds on the SalesTrack analytic workspace with 2.2 million customer dimension values, and 1,000,000,000 fact rows.  Fifty simultaneous queries ran against the database, simulating many more business users--no "think time" between queries.

The most interesting part for me is the appendix that shows the scripts used to build the queries and the settings used to put the analytic workspace into Exadata flash cache.  This becomes the Oracle standard of how to implement cubes on an Exadata box.

Simba Release 3.0 MDX Provider for Oracle OLAP

For those at Oracle OpenWorld, or those that closely follow Simba, this may not be news, but Simba has officially released version 3.0 of their MDX Provider of Simba’s MDX Provider for Oracle OLAP 3.0.  Simba’s MDX Provider for Oracle OLAP software enables users to feed their PivotTables with live enterprise data directly from their Oracle database, enabling better, faster decisions.  Version 3 of Simba’s software adds deeper analytics functionality to deliver answers faster and more choices for report customization and data presentation.

We are especially excited about the ability to automatically drill-trhough to detail data from a pivottable, using the mappings stored in the Oracle database, and the support for sub-queries, with better support for dimension attributes.  Read the full press release here.

Vlamis to Give OBIEE 11g Hands-on Session at NEOOUG

Dan Vlamis will be the featured speaker in Cleveland, Ohio at the NorthEast Ohio Oracle User Group meeting on September 16, 2011.

Dan's presentations include:

  • How Executives Visualize Corporate Data with Oracle Business Intelligence 11g
  • Fast Complex Analysis with Oracle OLAP
  • Hands On with Oracle Business Intelligence 11g


The final presentation will include a quick overview of the changes in OBIEE 11g. Bring your laptop for a unique experience as you get to experience for yourself just how easy it is to create a simple dashboard yourself in OBIEE 11g. Be sure to have a browser configured for wireless internet access so you can participate yourself!

For more details, see the NEOOUG Home page or the presentations page at vlamis.com.

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!

BIWA TechCast on OBIEE 11.1.1.5.0 Posted

The slides for today's BIWA TechCast on OBIEE 11.1.1.5.0 are now available on our web site under Papers and Presentations under "BIWA TechCast".

The TechCast drew a great audience with many questions.  My thanks go out to IOUG for hosting the TechCast, to BIWA for organizing it and drawing an audience, and to Marty Gubar, Bob Ertl, and Alan Lee for helping to field questions.  We were not able to get to all of the questions.  We'll try to get answers to them and post the questions and answers here.  My understanding is that IOUG will be making the recording of this 1-hour TechCast (as well as Shyam's last week on BI Apps 7.9.6.3) available in the next few weeks.  I'll post a link to it here when it's available.  In the meantime, you can check out the slides.