m-ic3
Re:Ask HN: OLAP and Reporting that feels like 2012
on Wednesday May 02, 2012 @05:37AM (#3918233)
I guess http://www.icCube.com (an in-memory OLAP server) is quite easy to setup (in JAVA following Web standards). Then, a quite simple JSON/HTTP interface is provided in addition to the standard XMLA. There's currently a JS client API and an early JAVA API as well. The JS client API is used by their visualization library / dashboards.
I'm not sure that OLAP cubes are good for 200G / week. I would go for something in between. Use a map/reduce algo. to mine your data and generate the relevant data from which you will build cubes for later and different analysis.
As somebody said, I guess OLAP cubes concepts are still good nowadays and MDX is a very powerful language that goes far beyond SQL.
My 2 cents (disclaimer I work for icCube)