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.
Mondrian setup required a few tweaks, as I’m running Java 6:
Added the following JARs
commons-discovery-0.2.jar (removed commons-logging)
Also set the following parameters in tomcat
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 🙂