RSS
 

Flex OLAP Take Two

15 Jun

After running some OLAP benchmarks it was obvious that a more scalable OLAP solution was needed.

After some quick searching and downloading, I’ve wired up a scalable Flex OLAP UI.

I downloaded and setup Mondrian from Pentaho for my OLAP server. Mondrian supports XMLA making integration easy.

I found a few Flex projects interfacing to OLAP via XMLA. The most robust appears to be Grebulon by the guys over at Sherlock Informatics

Mondrian setup required a few tweaks, as I’m running Java 6:

Added the following JARs
axis.jar
commons-discovery-0.2.jar (removed commons-logging)
jaxrpc.jar
wsdl4j-1.5.1.jar
xalan.jar

Also set the following parameters in tomcat
-Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl
-Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl
-Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl
-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl

Using the FoodMart as a reference, the setup was very straight forward.

I had to download the Grebulon source as the .swcs had hardcoded in a few references (PivotGrid) to the FoodMart datasource.

Commercially, I’d check out FlexMonster too 🙂

 
1 Comment

Posted in RIA

 

Leave a Reply

 

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Anti-spam image

 
  1. Twitter Trackbacks for Flex OLAP Take Two | Joshua Ostrom - riafan [joshuaostrom.com] on Topsy.com

    June 15, 2010 at 5:36 pm

    […] Flex OLAP Take Two | Joshua Ostrom – riafan joshuaostrom.com/2010/06/15/flex-olap-take-two/ – view page – cached After running some OLAP benchmarks it was obvious that a more scalable OLAP solution was needed. Tweets about this link Topsy.Data.Twitter.User[‘geekguypc’] = {“photo”:”http://a1.twimg.com/profile_images/960752858/Sin_t_tulo-1_normal.png”,”url”:”http://twitter.com/geekguypc”,”nick”:”geekguypc”}; geekguypc: “Flex OLAP Take Two http://dlvr.it/1ksWW ” 2 hours ago retweet Topsy.Data.Twitter.User[‘mojogeeks’] = {“photo”:”http://a3.twimg.com/profile_images/476530319/twitterProfilePhoto_normal.jpg”,”url”:”http://twitter.com/mojogeeks”,”nick”:”mojogeeks”}; mojogeeks: “Flex OLAP Take Two: After running some OLAP benchmarks it was obvious that a more scalable OLAP solution was neede… http://bit.ly/9qMpBo ” 2 hours ago retweet Filter tweets […]